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?
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
You can report on ANYTHING you can see in SolarWinds. If you need to know exact table and you can't find it - ask here
I am trying to create a report/query that will display all of the monitors assigned to each node sorted by node. Ideally, this would be something I could import into excel for analysis.
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)
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
Thanks for your response and these answers are a help. However, I am a bit surprised that the database elements are not documented/published somewhere for a product that is now as mature as the SolarWinds suite is.
