There is the em_database_menu command that can generate a report on space and other information.
What error are you getting via the CCM?
What i really want is the way to set a CTM Job to check the space available in the CTM EM DB. As i have not any command to acomplish this i need to find one and then set a job to monitor the DB in a daily basis.
By the way, this is the error im gettin when using the Check Space in the Cong. Manager:
I would contact support with the error you are getting and see if they can't point you in the right direction.
Aside from that, since you are using SQL Server, you can use this little script to generate information about file sizes, database size, etc. Just put it in a CTM for Datbases job or call it in a wrapper script.
You can find the script as the first item on my helpful query page located at http://www.robertstinnett.com/control-m-resources/helpful-sql-queries-for-control-m/