Active SCOM Alerts on Impacted Config Items
Similar to the two customizations before it:
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.