SWSQL Query All Application Monitor Templates

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