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

Where are SAM Template Tags stored?

Management wants a report on application availability pivoted based on an arbitrary "application platform" data point. Easiest done with custom properties at the Template level. Alas, this is not available. My next thought is to use SAM Template Tags, but I can't seem to find where these are stored in the database (assuming AND hoping that they are stored). Anyone have any insights which tables or views I can go diving into?

I've already tried dbo.APM_ApplicationTemplate and dbo.APM_ApplicationTemplateSetting.

Find more posts tagged with

sam template tags

Accepted answers

aLTeReGo

Application Template Tags are located in the [dbo].[APM_Tag] table.

All comments

mrxinu

I'm not quite sure where they are in the database but I only head that direction as a last resort if it's not already exposed via SWQL/API. Here's a SWQL query that'd get you what you need:

SELECT at.ApplicationTemplateID, at.Name, at.Created, t.TagNameFROM Orion.APM.ApplicationTemplate atLEFT JOIN Orion.APM.Tag t ON at.ApplicationTemplateID = t.TemplateID

Sample output:

* Update: I had to flip the tables because SWQL only supports left joins. That way you get templates without tags (instead of tags without templates which makes no sense).

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

aLTeReGo

Application Template Tags are located in the [dbo].[APM_Tag] table.

joe.tran

Ha, totally missed that one. Thanks, aLTeReGo!