Search code examples
t-sqlcoldfusionwmicpu-usageperfmon

Get Total CPU # via WMI or T-SQL


I don't want the list of all process, just a total percentage like you would see in windows taskmanager.

I will be using this information via coldfusion, but i am having all kinds of problems just trying to find a total number of current cpu usage.

I don't care if it comes from wmi or t-sql, i just want a total number for which i will be using to populate a gauge chart that via ajax will be showing my current cpu usage percentage...

Thank You...


Solution

  • You can use the Win32_PerfRawData_PerfOS_Processor WMI class to get this information. In your query you would use Win32_PerfFormattedData_PerfOS_Processor.Name='_Total'. See the article ColdFusion and WMI for more information on using WMI as well as the sample vbscirpt code in this article.