1 Reply Latest reply on Jun 12, 2013 9:56 AM by javajo91

    Need help with SQL Queries on Summary Home page.

    javajo91

      Good Morning -

       

      I would like to see all my physical vol usage for just my servers under "All Volumes" on the Summary Home page

      I've written one SQL query to weed out the desktops:

      comments != 'Desktops'

       

      How would the query look if I also wanted to weed out everything but physical disk?

       

      OK - the query for just fixed disk is:

      volumetype = 'fixed disk'

       

      Is it possible to have two queries for this monitor?

       

       

      Thank you for any help.

       

      Joe