Health State SCOM SQL Query

Hi,

I got all the Network Devices and Windows Computers that currently monitoring in SCOM through the SQL Query from OperationsManager DB. but i am unable to find the Health State status of Windows Computers and Network Devices ..

Please guide which query/in which SQL Table i have to look for health state sta

July 30th, 2015 2:08am

use this SQL query

select healthstate=
case healthstate
when'1' then 'success'
else 'uninitialized'
end
, InMaintenanceMode=
case InMaintenanceMode
when '0' then 'false'
when '1' then 'true'
end
, displayname from managedentitygenericview;

For detail, pls. refer to

http://syscentercldman.blogspot.hk/2015/04/scom-db-insider-part-3.html

Roger

Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 3:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics