Dynamic query for multiple group object

Hi All,

i am struggling to create a group in which i want application as 'Appinsight for SQL' and Node custom property Like environment(CP) is production and DBserver(CP) is yes. If anyone has done this please reply back to this thread.

Thanks in Advance!!!

Find more posts tagged with

orion

npm

groups

Comments

monitoringlife

Whats the end result you are trying to accomplish?

salman.khan

i want to create a dashboard based on the group which consist of application and node custom properties like above

monitoringlife

Thinking it would be easier to skip the group entirely and just query the node and application you want (I personally dont like dealing with groups unless I have to, they don't link to other useful tables as well (ex: for Alerts or dashboards).

Orion.APM.Application links directly to the node table, so it should be fairly easy. EX: below just rename the custom property value and where filter.

SELECT TOP 1000 Name, DisplayName, A.Node.NodeName, A.Node.CustomProperties.bla
FROM Orion.APM.Application A
WHERE
    A.Node.CustomProperties.bla like '%x%'
    AND A.DisplayName like '%SQL%'

salman.khan

Thanks for the response but i face issue for one widget that is application health overview which is not customisable and when i create dashboard for applinsight for sql it took both production and non production so i need to segregate it via dashboard