Hi, Daniel, Brian.

The second select statement is selecting from filespaces.  If you have a 2GB
client drive with 1GB of data on it, and if that counts as a filespace on
your OS, then your filespaces table will show that filespace as having a 2GB
capacity and 50% utilization.  That's data on the client at last backup, not
in the ADSM server.  However, when you go into the realm of storage space
used on the ADSM server, the number from filespaces doesn't take into
account the fact that there are inactive versions and deleted files stored
on the *SM server associated with that node.  The first select statement
includes those inactive and deleted files.

I hope that helps.

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax

PS:  output from HELP Q FI

Capacity (MB)
     Specifies the amount of space, in megabytes, assigned to this file
     space on the client node.

Pct Util
     Specifies the percentage of the file space that is occupied.