Is there a way/query to export a particular excel report among all the reports from OrionNPM using orionsdk API.

Hi Everyone,

I am new to OrionNPM, I have a task to automate like selecting a particular report and exporting a excel Report from OrionNPM.

While I am able to collect all the report names and its ID using the query "SELECT ReportID, Name, Description FROM Orion.Report". But I want to select one report among all and export the data in the report to excel using orionsdk API in python.

Any guidance/help to write a query will be highly appreciated.

Thanks in Advance

Find more posts tagged with

Reports

network_performance_monitor

npm

custom

Accepted answers

All comments

taylor.crowley

Hi there and welcome to SolarWinds!

Out of interest, are you not able to use the in built export to PDF within SolarWinds? You can set reports up on a schedule to email to specified mailboxes a PDF export of the report.

In terms of your query if this is the route you want to go, you just need to change the query to include a WHERE such as WHERE Name LIKE "%[REPORT NAME]%" or you could set it to look at the specif ReportID for the report you are interested. Int his scenario the WHERE clause would be WHERE ReportID = [ID]

In case you are interesting in scheduling these reports please see the documentation here: https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-scheduling-reports-sw2009.htm

Please let me know if you have any questions

bobmarley

This URL shows you how to run a SWQL query within powershell and export the results to a CZV. I'm sure Python would be very similar. (+) Export Custom Properties - Scripts - The Orion Platform - THWACK (solarwinds.com)

akhilp

Hello thanks for the response. I am interested in writing a query to export a report from Reports section in orionNPM using orionsdk in python.

I have tried the query as below, received an error message.

report_name = 'All sw and ro - with DNS entries'

data = swis.query('SELECT IPAddress, NodeName, DNS FROM Orion.Report WHERE Name = @report_name';, report_name=report_name)

Error: requests.exceptions.HTTPError: 400 Client Error: Cannot resolve property IPAddress for url:

Please let me know if this is correct approach or not.

Thanks

akhilp

Hello thanks for the response,

I want to understand about the query mentioned in the file which you have shared.

Do I need to use FROM Orion.Nodes or Orion.Reports, since I want to export a report from Reports section in OrionNPM.

Please let me know how to write a query.

Thanks