I know this has been discussed 2 years ago, but I'm wondering if something has changed, or if we can do this?
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 'pivot' on excel. We would like to generate a scheduled report directly from Solarwinds.
Thanks you in advance!
The PIVOT syntax has not been added to SWQL. But if you describe your use case in more detail, we might be able to find something workable.