Sql Query Report

Help,

I need to build an advanced SQL query report on a custom poller and I have no clue about sql queries.

I have a custom poller for OID 1.3.6.1.4.1.9.9.23.1.2.1.1.6. It is pulling the CDP neighbors table, and it is working great. I now have a need to run a report that will list each host device and in a seperate column display the neighbor(s) on that host.

Find more posts tagged with

query

orion

sql

sql_2005

report_writer

solarwinds

sql_variable

sql_2005_database

sql_report_writer

sql_query

report

Accepted answers

Yann

Have you tried to do it using Report Writer?

See this post:

All comments

Yann

Have you tried to do it using Report Writer?

See this post:

calremo

Hi Solarwinds Experts,

I think I do also have the same problem. We are trying to pull reports using UnDP from Tellabs sub-interfaces. We do have the OID's for these. The problem is when we get the report, it can only be viewed per node. We do need to seperately display these reports for individual sub-interfaces and map them to individual department/group web views but Solarwinds support team advised us to use Advance SQL Query of which I totally have no idea how to use. This is quite a large deployment of Orion

Hope someone can share any useful information for us to be able to address this issue.

Regards to all,

Orion v9.5