Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

swql for nodes currently down & currently up, also swql for number of Service now tickets raised - thanks in advance

jasonf1971

Hi all not having much look trying to find the info - but i need some swql for nodes currently down & currently up, also swql for number of Service now tickets raised - thanks in advance

Find more posts tagged with

Accepted answers

All comments

jasonf1971

Also which widgets should i be using for this - thanks

bobmarley

The widget name is this:

Below are a couple query's you can use, depending on which select you remark out it will either give you the numbers or a list.

----------------------------------------------------------

--Count of Up Nodes
SELECT Count(Caption) AS Caption 
--SELECT Caption , StatusDescription -- List of Down Nodes
FROM Orion.Nodes
Where Status LIKE '1'

-----------------------------------------------------------
--Count of Down Nodes
SELECT Count(Caption) AS Caption 
--SELECT Caption , StatusDescription -- List of Down Nodes
FROM Orion.Nodes
Where Status LIKE '2'

------------------------------------------------------------

Seashore

....and here is some code to show number of tickets per state. Maybe you can use that to show what you want.

SELECT 
    I.State
    ,Count(I.ID) AS QTY
FROM Orion.ESI.AlertIncident AS I
GROUP BY
    I.State

jasonf1971

hi - i might be having a moment here but it doesnt like the code for the ticket status

jasonf1971

sorted it - thanks

jasonf1971

ok - so i need an amendment to the swql for nodes down to not include the following -

CoreProductionSystem No

at the moment the swql is pickining up nodes and i only need Live nodes (CoreProductionSystem Yes)

thanks

bobmarley

--Count of Down Nodes
SELECT Count(Caption) AS Caption 
--SELECT Caption , StatusDescription -- List of Down Nodes
FROM Orion.Nodes
Where Status LIKE '2' and [Nodes].CustomProperties.CoreProductionSystem LIKE '%YES%'

vinod.kumar

Hi There,

I used this to show the number of incidents created but I can't make them clickable. Can you please help me to make them clickable?