Exporting All Reports

bharris1

Is there a way to export all reports into XML?  it seems I can only export one report at a time under Manage Reports.  We are building out a new fresh Solarwinds environment and would like to export the reports.

wluther

bharris​ I "borrowed" KMSigma​'s PowerShell script which exports the device templates, and converted it to export the reports. I take absolutely 0% of the credit, as KMSigma​ had previously done all of the work. I simply had to swap out the query, and that's about it.

Export Non-Default Device Templates

Using PowerShell, you should be able to export all of your reports, in separate XML files, to the directory of your choosing.

Import-Module SwisPowerShell
$swis = Connect-Swis -Hostname meow -UserName arf -Password moo

# Path where we will export our reports 
$exportPath = "c:\reports"

# Verify export path exists, and create a new folder if it does not.
if ( -not ( Test-Path -Path $exportPath -ErrorAction SilentlyContinue ) )
{
    Write-Warning -Message "Creating new folder: $exportPath"
    New-Item -Path $exportPath -ItemType Directory | Out-Null
}

# SWQL query to get all reports.
# Use the where clause to adjust reports returned
$reports = Get-SwisData $swis "
SELECT Name,Title,SubTitle,Category,Type,Description,Owner,Definition FROM Orion.Report"

# Loop through reports, exporting each to its own xml file.
# Each file exported/created uses the "Name" column from the query above.
foreach ($r in $reports)
{
    $filename = "$($r.Name).xml"
    $r.Definition | Out-File -FilePath (Join-Path -Path $exportPath -ChildPath $filename) -Encoding ascii -Force -Confirm:$false
}

The only real issue I found is naming the exported files which contain "illegal" chars, such as the "90/95/99th Percentile..." reports. Otherwise, I was able to run this script, then import the reports back into the system without any issues. The exported reports appeared to function/display properly once imported back into the system, and ran.

I hope this works to get you where you need to go.

Thank you,

-Will