Custom SQL Report URL

Question

We have a need to write a custom SQL report and would like to add a varaiable to the report URL. This would save us from having to write hundreds of reports. Simple example would be.

Custom SQL

select nodeid,ip_address,caption from nodes where ip_address = @p1

We need to be able to put the IP in the URL to save us from writing a report for every IP.

Example

http://orionServer/Orion/Report.aspx?Report=Examplereport;@p1='192.168.0.1'

Anyone else need this functionallity? Anyone have a work around?

Thanks

bshopp · Accepted Answer

So I chatted with Dev and you can’t do this directly.

There is one feature that might help you. You can include a “NetObject=N:123” option in the query string, then use macros in the report with that net object as the context. So you could have a report with a query like:

select nodeid,ip_address,caption from nodes where ip_address=${IP_Address}

And request it using a URL like:

http://orionServer/Orion/Report.aspx?Report=Examplereport&NetObject=N:123

And it would return the NodeID (123), IP Address, and Caption for that one node. Obviously this is somewhat limiting since you have to know the Orion NodeID to use it – you can’t do the lookup by IP address.

Custom SQL Report URL

Top Replies