I am trying to create a Dashboard Widget that I thought would have been simple, but I can't seem to get it right.
I want to show CI items that have open, active Incidents associated with them. There is a counter on the CI form that shows this, but its a Text Expression, not a field. When I attempt to create a similar field on the form with the same counter, it does not behave the same way. The Open Incidents on the Left automatically updates even when someone links a CI to an Incident from the Incident form.
The Active Incidents field I created (set to autopopulate using the same expression as the other one) only updates if you manually Save the CI form.
All I want in a Widget that displays CIs where the Open Incidents > 0
Anyone have an example of something like that?
Had a quick look at our system 9.5.1
OOTB has a query under Configuration Item association in Global for Assets with linked Incidents
I edited this slightly by adding 2 more clauses onto it for Status not equal Closed / Resolved