I am wondering how we can get an SWQL report for UnDP's to have the output 'rows' as columns instead. I see a lot of older threads about reports from UnDP, but no one seems to have found solutions except to write extremely complicated SQL queries. Is there an easier solution to this? See example below:
Current Output of report:
Device 1 | Last Time Tested | 6/9/2020 | Current Temp | 90F |
Device 2 | Last Time Tested | 7/2/2020 | Current Temp | 86F |
Device 3 | Last Time Tested | 7/4/2020 | Current Temp | 89F |
What I would like to see:
Node Name | Last Test Date | Current Temp |
Device 1 | 6/9/2020 | 90F |
Device 2 | 7/2/2020 | 86F |
Device 3 | 7/4/2020 | 89F |
Thanks!