I need to create some custom reports about the SW configuration and I need to know what items/objects I can include in my reports. Are the database tables and item published somewhere?
I need to create some custom reports about the SW configuration and I need to know what items/objects I can include in my reports. Are the database tables and item published somewhere?
What modules are you using in your environment? Do you want a report on only application monitors, all pollers including CPU, Memory, Interfaces, Volumes, Hardware, Topology? i.e.; What specifically are you looking for. (this is almost assuredly possible, but it's always easiest to start with a precise requirement)
Loop1 Systems: SolarWinds Training and Professional Services
Depending on the version of your NPM, table names will differ, although in new version some tables have been migrated to views for backwards compatibility
For the nodes you would almost always need dbo.Nodes view
For components the best one is dbo.APM_AlertsAndReportsData view. There is also dbo.APM_Component table with some additional info and linkage to other properties/tables
For applications - use dbo.APM_Application table
For application custom properties - dbo.APM_ApplicationCustomProperties table
For templates - you have two table dbo.APM_ApplicationTemplate and dbo.APM_ComponentTemplate
This should get you started with your custom reporting
If you need any specific help, as per Zack's suggestion - feel free to post here as well
Alex
There are documented in SDK. Just install SDK and you will get full offline documentation in HTML format with all database names and links. This will not be SQL though, but SWQL format - which is apparently more advisable way of building long-term compatible queries. SQL schema might change, whereas SDK will always (I hope) have backwards compatibility
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.