The most recent content from our members.
Table of Contents * Overview of PIVOT * Poor Man's SWQL PIVOT* The Example Entities * Summary Overview of PIVOT For anyone who has worked with the SolarWinds Query Language (SWQL) for any amount of time knows that it mimics traditional SQL in many ways. But there are some limitations that aren't put on traditional SQL.…
Can anyone comment on PIVOT functionality with SWQL? Perhaps an example of where it's been used previously? I have a web resource for the dashboard view using SWQL perfectly, but I would love to see the row data flipped around into column for easier consumption. I did exactly what I wanted to do on a web report with a…
Can anyone show me how to display a "NULL" value from the SQL Query below? I am trying to pivot some data on the details page and would for the "cpname" column to display "null" or blank if no data is entered. What I'm trying to do is create a pivot table that will consist of 20+ custom properties, and I want the user to…
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…
I know this has been discussed 2 years ago, but I'm wondering if something has changed, or if we can do this? PIVOT function with SWQL? Or, if someone knows how to pull the data and aggregate the count into a number? Reason being is that we do not want to release all of the "raw" data export so that someone else can run a…
It looks like you're new here. Sign in or register to get started.