I am trying to play around with PA in SNOW, After I enabled the plugins and had the historical data job run I got the below errors. I don't see any data in the dashboard. Can someone help?
Invalid query conditions: resolved_atONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)^EQ
Invalid query conditions: opened_atONToday@javascript:gs.daysAgoStart(0)@javascript:gs.daysAgoEnd(0)^ORopened_at<javascript:gs.daysAgoStart(0)^resolved_atISEMPTY^ORresolved_at>javascript:gs.daysAgoEnd(0)^EQ
I checked
Below is how my Indicator Source are setup out of the box. Is this the problem?
Hi Julio,
the collection error is because the OOB definition of the 'Incidents.Open' and 'Incidents.Resolved' indicator sources is looking for a field 'Resolved' (resolved_at) that you do not use in your environment. :
and
So you want to replace that with a user defined resolve date, or the close date 'Closed' (closed_at).
The 'Resolved' date is also used in a PA script 'Incident.Resolve.Time.Hours' so you want to change that one as well. Make sure that you add the field to the list of Fields (1) and replace the resolved_at field (2) in the script:
The resolved and resolved by fields get installed when you activate the plugin 'Incident Resolution Fields (com.snc.incident_resolution_fields). The plugin will not only add the two fields to the incident table, but also, similar to Closed and Closed by, populate the fields with a business rule when an Incident is resolved/closed.
You don't want to change the conditions for closed/resolved incidents using a state or 'active is false'. If you do, you will not get accurate numbers if you do a historical scores collection.
Hope this helps.
Cheers, Pieter
