Need SQL query
Created: 10 Feb 2013 | Updated: 17 Mar 2013 | 4 comments
This issue has been solved. See solution.
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
Discussion Filed Under:
Comments 4 Comments • Jump to latest comment
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.
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).
Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com
My team is working on memtioned comments will confirm any more help require
Would you like to reply?
Login or Register to post your comment.