6 Replies Latest reply on Aug 14, 2015 5:16 PM by cmatrask

    SQL Statement to filter out nodes via the UnManaged box in the DB

    cmatrask

      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