I am a new user of solarwinds orion npm, and I have a task to extract some data from its database. Well I need to export reports in Excel format, but here in this entreprise where I am a trainee they say that they don't have access to the report writer so I think that I'll have to connect to the orion database through JDBC and use JAVA language and sql query to extract data. Any Idea about this??
SQL Server supports many connection methods. I sometimes use Excel and/or Access to connect to the database and perform quick queries.
For more complex reporting, I do nightly extracts to a separate database server so as to not load up the production server - this also might be a option for yourself if your access is limited to the production server.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.