I am trying to figure out how to run a report that has ANY application template on it AND a custom property that is blank. For the life of me, I can't figure it out.
Add:
left join APM_ApplicationCustomProperties cp on a.ID=cp.applicationid
WHERE
-- if only want apps/nodes with empty email addr (if want all, just add the above left join line and nothing more.)
cp.EMAddEmail is null or cp.EMAddEmail = ''
here is an example that is backwards but will give you the table correlations...List of Applications and the Nodes assigned to each
I had one for windows that I cleaned up custom properties, etc... this is from the report writer app.
Nodes_and_Apps_assigned.OrionReport
I was afraid this was going to be done with SQL (don't really know SQL).
What we have is a CP (EMAddEmail) that has email addresses for the app dev group responsible for the monitored app. I found that we have some that we do not have addresses for. I am looking for a way to report on nodes that we are monitoring apps and has the CP empty.
