jasonford1971 · IT Operations Specialist · ✭✭✭

just not sure where i need add the below into the swql also listed below FROM Orion.Volumes AS v v.Node.CustomProperties.CoreProductionSystem LIKE '%YES%' with nolock swql SELECT v.Node.Caption AS NodeName ,CONCAT(v.DeviceId,'/') AS [Drive] ,CASE WHEN V.size >= 1099511627776 THEN CONCAT(ROUND(V.size/1099511627776,2), '…

so tried it for Drive Performance & Drive Space FROM Orion.Volumes AS v v.Node.CustomProperties.CoreProductionSystem LIKE '%YES%' with nolock but (it may be me!) getting the error message - Provided SWQL query is not valid. Details: undefined

sorry but where about in swql would i enter where v.Node.CustomProperties.CoreProductionSystem LIKE '%YES%'

ok -so i have the disk space query now on my dashboard -i need to amend the swql so it only picks up the following - (n.CustomProperties.CoreProductionSystem LIKE '%YES%') - how would i swql look - thanks

thank you -ill work through the above over the next couple of days 

OK - Thanks, but i dont have SWQL studio access 

Have tried the above and the SWQL is not working - Provided SWQL query is not valid is the error being displayed

thanks for replies - very much appreciated, are the above table widgets ?

thank you just what i needed

Thank you 

So need to amend the swql just to pickup up nodes that are monitored (not unmanaged) how would the swql look for adding Where Status LIKE '1' and [Nodes].CustomProperties.CoreProductionSystem LIKE '%YES%' - to the below - thanks SELECT N.DisplayName ,N.PercentMemoryUsed FROM Orion.Nodes AS N WHERE N.PercentMemoryUsed>90…

thank you - works a treat

thank you 

Thank you 

So i have the above swql for memory usage -how would the swql look just for monitoroing core productions nodes ? (n.CustomProperties.CoreProductionSystem) - thanks 

Thank you - works a treat

so- can you have the swql to do the following MachineType like 'Red Hat Enterprise Linux & (n.MachineType like 'net-snmp' ? in one query ?

ok - right so i have 118 net_snmp devices up but when using the query to see how many are online is only showing 45 of these SELECT COUNT(NodeID) AS myCount FROM Orion.nodes n WHERE (n.status = 1) AND (n.MachineType like 'net-snmp%') My count 45

Would you be able to share the swql for this, I would like to add this to a dashboard I am currently working on - thanks

For a modern dashboard

thank you - works a treat

Anyone willing to help on this - thanks

anyone able to help me here - just need script to pick up 90% memory usage - thanks 

Anyway this can be used for swql for a modern dasdhboard - thanks

thanks for the above - much appreciated, just having a slight issue on where i need to put in "AND [Nodes].PercentMemoryUsed < 90" into the SWQl, currently i have this - SELECT [Nodes].DisplayName , [Nodes].PercentMemoryUsed FROM Orion.Nodes AS [Nodes] any help gladly appreciated 

Yep - that was from my account that was being blocked at the time - obviously now unblocked hence why its a duplicate post 

tried to contact the admins but i couldn't post !