I don't have to do it often, but when I do I can never remember how to "PIVOT" data between elements in the SolarWinds API. I decided to write something up and share it as a custom query.
This particular example uses statistic and message data returned from SAM Script Templates. It doesn't matter if the sources are SAM templates or Universal Device Poller results - this same PIVOT logic should work. Please note that this isn't a simple copy/paste. You'll need to look at the connected data points. This is simply created to show how to do a SWQL Pivot.
Links of Interest
- Navigation Properties
- "Easy" Status Icons
- Adventures in PIVOTing - how to do a poor man's pivot in SWQL
