SWSQL Query All Application Monitor Templates

Can someone tell me the query I would need to get the output of this table?

TIA.

FL

Find more posts tagged with

query application monitor

application monitor template

Accepted answers

There may not be a single query used to populate this table.

As a start, the following may have what you need.

SELECT TOP 1000 ApplicationTemplateID, Name, IsMockTemplate, Created, LastModified, ViewID, HasImportedView, ViewXml, CustomApplicationType, UniqueId

FROM Orion.APM.ApplicationTemplate

All comments

There may not be a single query used to populate this table.

As a start, the following may have what you need.

SELECT TOP 1000 ApplicationTemplateID, Name, IsMockTemplate, Created, LastModified, ViewID, HasImportedView, ViewXml, CustomApplicationType, UniqueId

FROM Orion.APM.ApplicationTemplate

Thank you Tony!

Follow up. Is there a query for the Assigned Application Monitors view?

FL

Try this

SELECT TOP 1000 ApplicationID, Name, DisplayName, NodeID, ApplicationTemplateID, UnManaged, UnManageFrom, UnManageUntil, Created, LastModified, ID, DetailsUrl, FullyQualifiedName, ComponentOrderSettingLevel, CustomApplicationType, HasCredentials, Description, Status, StatusDescription, Image, Uri, PrimaryGroupID, InstanceType, InstanceSiteId

FROM Orion.APM.Application

Quick Links