Active SCOM Alerts on Impacted Config Items
Similar to the two customizations before it:
This new SCOM integration now surfaces the Alert counts (Critical/Warning) of Computers, on the Impacted Config Items list of an Incident. Zip file includes the icons, sql to pull data from SCOM via the Dashboard Query page, and the javascript to drop into CustomSpace.
There are two visual things here I'm not entirely sure how to account for yet and one item on the to do list:
- Background color of the div changes on hover the Alert counts, but the rest of the CI row is fine
- Moving the two metrics directly to the right of the CI Name
- The SQL query should use the GUID of the object as its identical from the one in SCOM. This would require some substring manipulation to pull the GUID from the /DynamicData/ portion of the URL and then use in the query. So the initial WHERE becomes "tme.ManagedEntityGuid" instead of "tme.DisplayName". I didn't go this route yet because I want to recurse up the SCOM Health Explorer tree so you could see the Alert Count at the parent level instead of the child object that could be potentially be shown in Affected Config Items.
Comments
Changed up the IF logic a bit. Should handle multiple Impacted CIs better now.
Should also add, this customization can easily be extended to Change Requests. Which means your Change meetings can highlight Active SCOM Alerts for the very Config Items you are proposing changes for.
All you have to do is update the ClassName condition from:
to