SWQL for a KPI WIget for Component services being down

jasonford1971

Hi - need some swql for a KPI Widget for the number of component being seen in a warning or critical state and including "CustomProperties.CoreProductionSystem = YES" - thanks

Find more posts tagged with

Accepted answers

All comments

jasonford1971

Any help on this would be very much appreciated - thanks

bourlis

Hi JasonFord1971,

Here's 2 SWQL commands that'll work for you.

(Option 1) Combined count with the status of 'warning (3)', 'critical (14') and 'down (2)'. If you don't want to add down simply remove it from the query.

SELECT DISTINCT count (a.componentname) as [Puppy]

FROM Orion.APM.Component a


WHERE 1=1
 and a.application.node.CustomProperties.CoreProductionSystem = 'yes' and a.status in ('3','14','2')

with nolock

(Option 2) Separate KPI's for warning, critical and/or down

SELECT DISTINCT count (a.componentname) as [Puppy]

FROM Orion.APM.Component a


WHERE 1=1
 and a.application.node.CustomProperties.CoreProductionSystem = 'yes' and a.status = '3'

with nolock

SELECT DISTINCT count (a.componentname) as [Puppy]

FROM Orion.APM.Component a


WHERE 1=1
 and a.application.node.CustomProperties.CoreProductionSystem = 'yes' and a.status = '14'

with nolock

SELECT DISTINCT count (a.componentname) as [Puppy]

FROM Orion.APM.Component a


WHERE 1=1
 and a.application.node.CustomProperties.CoreProductionSystem = 'yes' and a.status = '2'

with nolock

jasonford1971

Thank you - just what i needed

jasonford1971

Could you confirm what the SWQL would look like without CustomProperties.CoreProductionSystem = YES" - thanks - thanks

bourlis

Sure

SELECT DISTINCT count (a.componentname) as [Puppy]

FROM Orion.APM.Component a


WHERE 1=1
 and a.status = '3'

with nolock