SQL for a group of nodes.

Question

for subplots for a bunch of servers. On each pane of glass they was different site subplot = 'Prod Environment Cleveland' AND Volumes.Caption <>'cached memory' and Volumes.VolumeType='Fixed Disk' and VolumePercentUsed >= 90 subplot = 'Prod Environment Parma' AND Volumes.Caption <>'cached memory' and Volumes.VolumeType='Fixed Disk' and VolumePercentUsed >= 90 subplot = 'Test Environment - Canton' AND Volumes.Caption <>'cached memory' and Volumes.VolumeType='Fixed Disk' and VolumePercentUsed >= 95 subplot = 'Test Environment UCRC' and Volumes.Caption <>'cached memory' and Volumes.VolumeType = 'Fixed Disk' and VolumePercentUsed >=40 I cannot get anything to appear in the top one no matter what I change that last number to. There are nodes in that "subplot" I copied it from the custom properties of one of the nodes in there. Why is it not displaying anything (it doesn't indicate an error either. Is there a better why to write the sql query?

fabian.s · Answer

https://thwack.solarwinds.com/people/trilobite%20rex  wrote:

So I started down the path and just had items that were in that "subplot".  All items that appeared were memory related.  Beyond that I can get nothing to appear.

I'm not sure how you have tried to find the root cause but below is an idea. Just let me know if you did that already.

What do you get if you run the following SQL statement against the Orion database:

Change 'n.Applications' to your customproperty name, most likely n.subplot

SELECT  v.Caption as volume_name

,n.Caption as node_name

,v.VolumeType

,v.VolumePercentUsed

,n.Applications -- CUSTOMERPROPERTIES NAME. Please adjust

from Volumes v

JOIN Nodes n ON n.nodeid = v.NodeID

WHERE n.Applications ='Prod Environment Cleveland' -- CUSTOMERPROPERTIES NAME. Please adjust

order by n.Caption, v.Caption

You can then compare the result of the SQL statement above with the filer ' subplot = 'Prod Environment Cleveland' AND Volumes.Caption <>'cached memory' and Volumes.VolumeType='Fixed Disk' and VolumePercentUsed >= 90 ' .

Of course you can also expand the SQL exactly with your filter but I personally like always to start simple.

regards

mesverrum · Answer

Sounds like you didn't discover any fixed disks on the nodes in that suplot, need to check that out and maybe redo your discovery.

trilobite_rex · Answer

So I started down the path and just had items that were in that "subplot".  All items that appeared were memory related.  Beyond that I can get nothing to appear.