Hi Everyone,
May get help on this?
I am trying to get a query to give me a list of nodes and other information
I want to filter only those nodes where the UnManaged box is not checked.
How would I state that in the "AND" statement.
Thanks!
Cheryl
This fails: AND UnManaged <> Checked
SELECT VolumeSpaceAvailable/VolumeSize*100.0 AS Percentage_Available,
FullName,
SupportGroup,
Remedy_Service,
Comments_Notes,
VolumeSize/1000000000 AS VolumeSize_GB,
VolumeSpaceAvailable/1000000 AS SpaceAvailable_MB,
Prod_Dev,
v_DISK_Alert
FROM [Solarwinds-NetPerfMon].[dbo].[Volumes], [Solarwinds-NetPerfMon].[dbo].[Nodes]
WHERE VolumeType = 'Fixed Disk' AND VolumeSize>0
AND Volumes.NodeID = Nodes.NodeID
AND Prod_Dev = 'Production'
AND UnManaged <> Checked
