SNOW tickets orion Dashboard

No, that is not how this function works. This widget will only display incidents that have been generated by the Orion alerting engine.

If you want to create something more than this, you may be able to do so via the Custom HTML widget, by creating some Javascript code that pulls data from the SNOW API for display.

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

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

It is worthwhile you looking at the basics of SQL/SWQL, as if you have this requirement now you are going to have more in future. The following is the standard place to start learning - https://www.w3schools.com/sql/sql_where.asp

In the following adjustment to the previous statement, you can see I have added an AND, which means both the IncidentID field is not empty and the state field must equal a value, where you replace <value> with the value that equates to the ticket still being open.

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

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

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

I included the <> to define that this is a dynamic sample value and to replace the whole of that block. Try this:

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

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

I do not have access to a populated instance to confirm the values, so you will have to identify the correct keyword yourself from the contents of that table cell. Replace Open (leave the single quotes) with whatever is the right keyword.

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?

the beauty of SWQL (SQL) is the level of control of the data you have. To give you guidance, I would expect this to help:

SELECT COUNT(ID) AS IncidentCount
FROM Orion.ESI.AlertIncident
WHERE IncidentID IS NOT NULL AND (State = 'Assigned' OR State = 'somethingelse')

works a treat - thank you 

works a treat - thank you