SCSM 2012 - Active incidents reporting - Active incidents showing to high

WHen I do a cube report and show the number of active incidents it shows as 63210, I know for a fact that we only currently have 58 incidents in an active state so why is this happening?

When I looked at the incidentid for some of the 63210 incidents I can see they are closed.

September 19th, 2013 8:34am

the "Incidents Active" in the pivot table represents the total number of the incidents that were & are in active status. In other words, the total number of the created Incident including any deleted Incident (because deleting Work Items using SMLets remove-object, deletes it from SM DB but NOT from the DW DB)

to get the incident status (e.g. in progress):

Check IncidentDimCount > Scroll down to IncidentDim_IncidentStatus, expand More Fields and check IncidentStatusValue   

Free Windows Admin Tool Kit Click here and download it now
September 19th, 2013 9:02am

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

Other recent topics Other recent topics