My organization has two Orion instances and one EOC
My task is to consolidate all the reports and associated report schedules into one spreadsheet.
I was so excited that I could do a SQL query to get part of the way there, but I am having a hard time with the second half.
My query is such,
SELECT *
FROM ReportDefinitions
This appears to be populating all of the report names (as well as some other cool data)
I need to "JOIN" that data to the report scheduling data.
And pump all that out into an excel spreadsheet.
I harken to you Orion Champions, to aid me in my quest!