Legacy Report Migration Tool

Hello,

We currently use version 2020.2.6 and we need to use the Legacy Report Migration Tool before we upgrade because it will be unsupported after we upgrade. I have read the following guide and I am fairly comfortable with the steps, I just have a question about it:

https://www.solarwinds.com/documentation/helploader.aspx?topic=orioncorereportmigrationtool

Under step 6, it looks like I need to manually remove the legacy reports from schedules and reassign the new reports after the migration. Is there a report I can run that will show me all the reports on our deployment and what schedules are assigned to it? It would just make the process more manageable.

Many thanks.

Find more posts tagged with

npm

Legacy Reports

Accepted answers

stuartd

You can either fire up SWQL Studio and do a query against Orion.ReportJobs or you could drop the following into a custom report:

SELECT Name AS [Schedule name], ReportTitles, Enabled, AccountID, LastRun
FROM Orion.ReportJobs
Order BY Name

All comments

stuartd

You can either fire up SWQL Studio and do a query against Orion.ReportJobs or you could drop the following into a custom report:

SELECT Name AS [Schedule name], ReportTitles, Enabled, AccountID, LastRun
FROM Orion.ReportJobs
Order BY Name

mrldg123

Hello,

This was spot on.I put the SWQL query into acustom report and it gave me what I needed.

Many thanks.

ecklerwr1

This is interesting stuff!

ecklerwr1

Stuart you always have some good tricks up your sleeves!

stuartd

Thank you Bill.

I know how badly out of water I was when I first came across needing to know SWQL. Doesn't mean that I know it all now, but when I spot something or somebody I can help then why not .

In all truth, it helps me as much as it helps others.