I would like to use the Current Application and Component Status built in report but change it to only show node members in a certain group. I am not seeing how to do this by group and looking for some help.
Thanks
You won't be able to add group filtering in the canned reports from report writer. What you would need to do is a custom SQL alert that would look something like this:
SELECT TOP 10000 Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
APM_AlertsAndReportsData.ApplicationName AS Application_Name,
APM_AlertsAndReportsData.ComponentName AS Component_Name,
APM_AlertsAndReportsData.PercentCPU AS Percent_CPU
FROM
Nodes
INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)
INNER JOIN ContainerMemberSnapshots on Nodes.NodeID = ContainerMemberSnapshots.EntityID
INNER JOIN Containers on ContainerMemberSnapshots.ContainerID = Containers.ContainerID
WHERE
(
(APM_AlertsAndReportsData.DisplayType LIKE '%process%') OR
(APM_AlertsAndReportsData.DisplayType = 'windows service')
)
AND
ContainerMemberSnapshots.EntityDisplayName = 'Node'
And Containers.Name = 'Group Name'
ORDER BY 2 ASC, 3 ASC, 4 ASC
Regards,
Matthew Harvey
Loop 1 Systems
Matt Thanks so much for the reply. So doing a custom SQL alert is new to me. I see how to set that up in advanced alerts but how do I actually e-mail the report out several times a day? I am also getting the error below
You wouldn't do a custom SQL alert, you'd do a custom SQL report. You'd need to open the Report Writer and create the report there. Not an alert.
Also can I do this by just statically listing the node names in report writer? I do not seem to be having much luck with that either.
In the filter results yes, but you'd have to have a grouping of any of the following apply.
What is in your group? Just the nodes only, or also the application / component monitors? If it's just the nodes, I think you need to go down the advanced SQL route of report writer. Depending on your setup, you can use one of these routes
- quick win: use Application custom properties to mimic the specific groups you are trying to get a report for now. Application custom properties can be added as a field in the report writ
- holyguacamole's "best practice" way: create relevant node custom properties. Re-define your group definition using dynamic queries based on these node custom properties (i.e. Do not explicitly select the nodes that go into a group. Use dynamic queries to make this selection automatic / dynamic). Node custom properties are available for reports / alerts / filtering dashboard resources.
Also, please move this discussion to the SAM forum
