When you say Critical and Warning, are you looking at APM alerts? Or IPSLA?
We are looking at NPM and APM active alerts such as our critical and warning disk space alerts. We have defined these in the advanced alerts tool to set warning disk space to 90% and critical alerts to 90% of disk space.
These alerts appear in the list as "critical disk space alert <servername> etc" and the same for warnings.
We want to create a report which takes a match for 'critical' or 'warning' and only show these in the report.
Alternatively, is there a property for disk space for servers which we can apply thresholds to rather than just using the alerting tool?
Is acceptable to use Advanced SQL Report for you? If so, it couldn’t be a big problem to create report for your Warning and Critical alerts by appropriate SQL statement like that:
SELECT S.TriggerTimeStamp, D.AlertName, S.ObjectName as MachineName
FROM AlertStatus S
JOIN AlertDefinitions D ON (S.AlertDefID = D.AlertDefID)
WHERE (S.Acknowledged = 0) AND (D.AlertName LIKE '%disk space%') AND ((D.AlertName LIKE '%Critical') OR (D.AlertName LIKE '%Warning'))
Advanced SQL Reports works directly with SQL statement. Field formatting and Report grouping is similar to standard reports.
As a simpler approach, try the following as a recommendation:
- Click Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer.
- Click File > New Report.
- Click Event Log in the list of report types, and then click OK.
- On the Select Fields tab, add the following new fields:
- Events > Event Type Name
- Events > Message
- On the Filter Results tab, add the following new fields, indicating Records where:
- Events > Event Type Name contains critical
- Events > Event Type Name contains warning
- Events > Message contains critical
- Events > Message contains warning
Include additional fields and time frame conditions as required. For more information about reports in Orion NPM, see "Creating Reports" in the SolarWinds Orion Network Performance Monitor Administrator Guide.