cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

UnDP SWQL Reports and Columns

Jump to solution

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 1Last Time Tested6/9/2020Current Temp90F
Device 2Last Time Tested7/2/2020Current Temp86F
Device 3Last Time Tested7/4/2020Current Temp

89F

 

What I would like to see:

Node NameLast Test DateCurrent Temp
Device 16/9/202090F
Device 27/2/202086F
Device 37/4/202089F

 

Thanks!

0 Kudos
1 Solution

Nope there is no easier solution, the data in the DB is arranged in the way you see it in your first example and the only way to re-arrange it is with custom SQL.

- Marc Netterfield, Github

View solution in original post

3 Replies

Nope there is no easier solution, the data in the DB is arranged in the way you see it in your first example and the only way to re-arrange it is with custom SQL.

- Marc Netterfield, Github

View solution in original post

Have you configured any SQL for this and/or do you have any examples of how to make it work?

0 Kudos

Ah geez... ok thanks for the info.

0 Kudos