0 Replies Latest reply on May 26, 2017 12:14 PM by mwb

    Web Report with SQL pivot for Volume Drive Letters

    mwb

      Looking to pick brains here on the limitations of the SolarWinds Web Reports.

       

      I built a lovely little SQL query with a dynamic pivot included to list out the volume letters of each of my Windows machines and their sizes, with each column being a drive letter, with the data populated underneath or NULL if that drive letter doesn't exist.

       

      Runs perfectly in SQL, runs perfectly in SolarWinds with "Advanced Database Query" and the preview results button... however, when moving to putting that data into a table, you need to select the columns from your SQL query results and add column simply does not prompt the drive letters past C: as an option?

       

      Does anyone know why this would be?  Is this simply a bug that needs to be reported?

       

      dynpivot.PNGdynpivot2.PNG