jfoudy

So in the first part of the query I'm doing this: WHERE (n.CustomProperties.AssetTag= 'SQL' and n.CustomProperties.Environment= 'Production')) a It is basically filtering out only nodes that have those custom properties and I know that they're windows boxes with SQL Server on them and they'd all have the drives I listed.…

Using the Examples above I was able to create a "PIVOT" query for Disk Volumes per Node. You'll need to add addition columns as needed. You can also add/remove the left joins as needed for the drives you want to view. This ends up looking like this: Config of Drive Column: SELECT a.Caption, a.NodeStatus, a.DetailsURL,…

Here's one that anyone can use. This one should always return no results because there is no node with a negative number. Select TOP 10 NodeID, Caption FROM Orion.Nodes WHERE NodeID = -1 This is the one I was using in the example above: SELECT n.Caption as NodeName,c1.ComponentName,c1.DetailsUrl as…

I found this out myself. Trying to put some weight into it also so it bubble up high io and cpu to the top: SELECT TOP 25 cs.NodeID, n.Caption, cs.ApplicationID, cs.ApplicationAvailability, cs.ComponentID, cs.ComponentName, cs.ComponentType, cs.ComponentAvailability, cs.ComponentErrorCode, cs.ComponentPortNumber,…