jasonf1971 ✭✭

i have tried it but it does not like the swql im not sure why not 

Sorry should have been more clearer also needs it to contain the following - SELECT COUNT(1) AS KPI_Numbe from Orion.Nodes WHERE Status=2 AND (nodes.customproperties.AssetTag='Store Router')

Hi would you be willing to share the swql - thanks

I'll give it a try thanks 

One KPI should be ok 

Is there a way where the KPI widget can pickup all cities rather than having to add them into the swql individually

works a treat - thank you 

Think i have got it - SELECT COUNT(ID) AS IncidentCount FROM Orion.ESI.AlertIncident WHERE IncidentID IS NOT NULL AND State = 'Assigned' this is showing 6 tickets assigned - can i get the swql to also pickup work in progress?

Sorry - i should have been clearer - i did try the above and it was also coming back with 0 

SELECT COUNT(ID) AS IncidentCount FROM Orion.ESI.AlertIncident WHERE IncidentID IS NOT NULL AND State = '<Open>'

Have tried the above and tried open and assigned as a value but 0 is being displayed

Would appreciate your help on swql for just open tickets - not to sure on the correct structure 

Is this for all tickets raised or just open tickets ?

works a treat - thank you

SELECT TOP 1000 ID, InstanceID, AlertObjectID, ActionID, AlertUrl, IncidentID, AlertTriggerState, LastTriggerTime, CreatedOn, IncidentNumber, IncidentUrl, AssignedTo, State, Description, LogicalState SELECT COUNT(ID) AS IncidentCount FROM Orion.ESI.AlertIncident WHERE <ColumnNamewithSNOWID> IS NOT NULL - Is this correct -…

right - i have tried the above which works - but i need it to go into a kpi widget to give the total number of incidents rather than incident number, assignedto etc etc 

I Basically want a kpi widget that shows the number of service now tickets - thanks

Have used the above but it only shows triggered alerts - i need it to include the service now incident number etc 

after some help / advice with regards to creating a widget for Snow Incidents on a Modern Dashboard - much appreciated 

i sorted it 

Hi - where about in the query does the above go ? thanks

im not building an alert - the report i am using is picking up the severity of each alert but the alerts themselves have a totally different severity 

thank you - looks like i currently dont have the required access to do the above 

HI - Thanks for the above - how do i change the report to string values - thanks