So currently looking to have a Level 1 (NOC view) for applications.
This department will literally just monitor what application is down and then forward this onto the AppOwner team to resolve, no specific information.
SELECT [data].[DisplayName] AS [DisplayName],[data].[InstanceSiteId] AS [InstanceSiteId],[data].[Status] AS [Status]
FROM orion.groups AS data
WHERE
((([data].[Name]) LIKE ('GRP_APP') + '%'))
First of all, how would I rename the individual group names to remove the GRP_APP so it will only just show the Application Name itself instead of GRP_APP_"Application Name".
Next I would like to have a count of application components and nodes assigned to a custom property (called Application that only displays "Application Name"), this would give me a total number of dependencies. With this I can also provide another column to just show the amount of dependencies for this application that currently have an issue, i.e. Status !='1'
Thank you very much in advance
Examples
Group Name = GRP_APP_Office2016
Node Custom Property = (Application = Office2016)
