How much space does a file (active version) use?

[JR Trimark]

Does anyone know how to write a sql script that would display how much
data (active version only) would be restored for a volume/drive?