Query to fetch PC utilization

Question

Trying to integrate .net application with SCOM . Need queries through which I can display information like CPU Utilization  Memory Usage  Number of Processes running on the client machine . SCOM has its own database but unable to create a query that can fetch the said information.

Rajeev Punhani · Answer

Hi Hemali SELECT (physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB (locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB (total_virtual_address_space_kb/1024) AS Total_VAS_in_MB process_physical_memory_low process_virtual_memory_low FROM sys.dm_os_process_memory; If the above solution is helpful then accept the answer.