Reply
Highlighted

Looking for a Perl Module to export a Report

Expert
Posts: 127
8610     0

Hi Everyone!

Does anyone know of a Perl Module that I can use to grab the output of a report that is generated by NetMRI?  Perhaps via the report_id?

Thanks,

Lon.

Highlighted

Check here:

Adviser
Posts: 437
8610     0

Check here:

api/2.10/report_job_runs/docs

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

www.sifbaksh.com
Highlighted

Thanks Sif, but that just

Expert
Posts: 127
8610     0

Thanks Sif, but that just returns the array of ReportjobRun (/api/2.10/report_job_runs/model) and it contains all the info about the report, but I don't see where I can grab the actual report?

Cancel Time
Created At
Foreground?
Priority
ProcessID
Report Start
Report Type
ReportID
Size
Start Time
Status
Updated At
UserID
id
report_job_specification_id

 

 

Re: Thanks Sif, but that just

Adviser
Posts: 437
8610     0

I don't see any API call to get it, I will ask the Engneering team.

 

Sif

 


 

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

www.sifbaksh.com
Highlighted

Re: Thanks Sif, but that just

Adviser
Posts: 437
8611     0

Lon,

Need to file an RFE with the account team, looks like it's not aviable via an API call.

 

Sif

Follow me on LinkedIn: https://www.linkedin.com/in/sifbaksh
Twitter: https://twitter.com/sifbaksh

www.sifbaksh.com
Highlighted

Re: Thanks Sif, but that just

Techie
Posts: 9
8611     0

HI Sif, 

Was an API call ever created to pull the output of a report that is generated by NetMRI?

Highlighted

Re: Thanks Sif, but that just

Member
Posts: 1
8611     0

Seems like an oversight what is the point of having access to the Report object if the API call is not there to pull data from the object. 

Highlighted

Export Scheduled Reports over API

[ Edited ]
Community Manager
Community Manager
Posts: 70
8611     0

A little bit of creative API-ing

 

  1. I assume you know the name of the report
    1. For this example I am going to use “Vlan Interface Summary”
  2. I assume you know how to get a REST auth cookie
  3. Check /api/3.4/report_job_runs/index this will give you a json object with the scheduled reports as they were run
  4. Take the “id” value of a report that you want to obtain
  5. Use the following API call:
    1. curl --request GET 'https://demo-netmri.infoblox.com/WebViewer/frameset?__format=xls&__document=/var/local/netmri/report...'  --header 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8' --header 'Content-Type: application/x-www-form-urlencoded'  --header 'Cookie: use your cookie here'
    2. The variables that matter are
      1. Format
        1. Either html,xls,doc,pdf
      2. Report id
        1. see: /var/local/netmri/reports/repDoc7684.rptdocument
        2. Use the ID to craft the filename
      1. Report name
        1. pFile=VlanInterfaceSummary
        2. Use the name of the report and drop the spaces
Showing results for 
Search instead for 
Did you mean: 

Recommended for You