Video Screencast Help

Need SQL query

Created: 10 Feb 2013 • Updated: 17 Mar 2013 | 4 comments
This issue has been solved. See solution.


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

Comments 4 CommentsJump to latest comment

CBaelum's picture

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.

Tim.Jing's picture

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

mclemson's picture

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).

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner

akgs's picture

My team is working on memtioned comments will confirm any more help require