Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Access SAM Template Collected Data

Hello,

Is there a DB table that stores SAM template collected data? I have a SAM template that collects the status of server firewall profiles (domain, public, private). It's working fine but I can't find a way to create a report to show the data in the following format.

server name	firewall status (domain)	firewall status (public)	firewall status (private)
server_01	enable	disable	disable

Any help would be very appreciated.

San

Find more posts tagged with

Accepted answers

All comments

neomatrix1217

Can you show us the report that you tried to create it?

san.tran

Thanks, neomatrix.

Here is our SAM template setup and the component type is Windows Script Monitor.

Here is the current report setup.

And the output looks like this.

server name	SAM component Name	firewall status
server_01	Domain Profile	Enable
server_01	Public Profile	Disable
server_01	Private Profile	Disable

As you can see the result has duplication in server name so we're looking for a way to display a report in the format as mentioned in the first post.

--San

sturdyerde

When you create an application monitoring template and assign it to a node, you end up with two key items (no pun intended) in the database. There will be an ApplicationID for each instance of that assigned template (remember that in Orion, template+node=application) and there will be a ComponentID for each monitored component within the application (e.g. a monitored process = one unique component).

There may be a more direct approach, but in my customizations I learned by trial and error. The Orion SWIS Query page (https://OrionServerName/Orion/Admin/Swis.aspx) lets you test queries against your Orion DB. Scrolling through the tables and views, you'll see Orion.APM.Application___ and Orion.APM.Component___ entities. The ComponentStatus one should have the data that you are looking for. That said, it is very possible that somebody who is more familiar with the structure of the Orion DB can point you to an even better construct from which to query your monitor component data.