Howdy folks,
I used this previous post to get myself started - but don't believe I am on the right track for what I want. While i've been working with SCOM for a little while now, I am still not that comfortable inside the DB --- which brings me here.
I am looking to create a simple dashboard webpage in IIS on a seperate machine. This machine already hosts our internally developed inventory front-end. At my last job, our SCOM admin developed something similar, and it was invaluable. In short, I want to create a dashboard that queries the OperationsManager DB every minute or two for the last heartbeat time of an agent. regardless of whether its managed or not, and regardless of whether its a gateway or not. From there, let the page determine that its outside its 180 second timeout (ignoring the SCOM state of the agent effectively)
The above solution appears to give me the agent state, not the heartbeat time. It also does not indicate when a gateway is offline, only agents.
The idea here is getting a raw dashboard of what agents are not responding in a timely fashion, and giving me the flexibility of coupling it with our internal inventory/CMDB solution to display unhealthy servers with useful information (such as location, application running on it, os version).
at my last shop we had a solution that displayed this data, with links for automating setting it into MM, and making work log entries to our CMDB. not sure i'll go that far - right now, just want a simple dashboard to tell me whats not happy at a basic level.