Client Management Suite

Hello,

Currently i am using symantec managemant 7.1 ,I need one sql query where i will received following information.

Computer name ,IP address, C Drive Space ,CPU utilization.

Please provide that type sql query

I am not sure that you can get the CPU Utilization from the Altiris database, but the rest of the information can be found with this SQL query.

select w.Name as [Computer Name], ip.Device as [Network Device], ip.[IP Address], ld.Name as [Disk Name], ld.[Size (Bytes)]/1073741824 as [Total HD Size (GB)], ld.[Free Space (Bytes)]/1073741824 as [Free Space (GB)] from Wrksta as w

join Inv_AeX_AC_TCPIP as ip on w.Guid = ip._ResourceGuid

join Inv_HW_Logical_Disk as ld on w.Guid = ld._ResourceGuid

where ld.Name = 'C:' and ip.Physical = 1

order by w.Name

 The number 1073741824 is to get from Bytes to Gigabytes.

If you the resource manager on a computer in the database and then choose "View -> Inventory", you can see all kinds of information that the agent has sent back to the database.

If you see a dataclass that is called "HW Computer System". The table in the database would be called "Inv_HW_Computer_System", so it is quite easy to make SQL queries if you can find the information in Resource Manager for an item in the database.

CPU utilization would be some sort of real time monitoring and something in the database to track that?

You'll want to run the Processor Utilization report at Reports > Monitoring and Alerting > Monitor > Servers > Common Performance > Processor > Processor Utilization.  You need to monitor the resources using Monitor Solution for this data to be gathered.  If you use Monitor Solution, you can clone this report and add in the information from Inv_HW_Logical_Disk as needed (see above for an example).