I see.
I don't know how you can find appropriate bulk material properties to model your base material.
If you actually don't know which is the weak link, base or beam or fasteners, then the problem is much more complex because you can't model any of them as ideally rigid. I think most folks in this situation would use finite element modelling software and not formula based calculations.
The lifting force comes from the moment divided by the distance between the center of the beam and the fastening point, I think.
If nothing is pushing the vertical-with-repsect-gravity beam from side to side, then there is no moment and hence no lifting force. The concrete may crumble if the beam is too heavy, I guess. I don't know how to calculate that, though, you may be able to Google something useful about concrete properties.
edit: I see in your initial diagram you mean there is a cantilevered force at the top of the beam. You can get the lifting force by calculating the moment at the base of the beam and then dividing by the distance to the fastening point, as I said above.
Look here -
https://www.engineeringtoolbox.com/cantilever-beams-d_1848.html
to see how to calculate the moment if there is transverse force acting on the beam.