Orion Report Writer is a tool within Orion Network Performance Monitor (NPM) that allows users to format data and preview reports before displaying them. When running reports, sometimes it is not necessary or desirable to retrieve all the available information from a device. One question that has popped up is how to create a report that filters for certain days of the week. For example, rather than pulling a report that provides all information (24x7), to instead pull information that has been collected during normal business hours. This article concentrates on how to filter reports for specific times and days of the week. For more information on configuring reports in their entirety see Understanding Orion Report Writer.
The procedure for filtering is fairly simple and only involves making a few changes to the “Filter Results” section of the report. The following example shows a filter that returns information collected Monday thru Friday from 7 AM to 6 PM.
The report consist of two complex conditions. The first complex condition listed below consist of three statements grouped within an “all” condition. The first two filters within the “all” condition filter for the time of day. The filter spans from 7 AM to 6 PM. The 3rd statement filters for a device with the IP address of 10.110.68.115. Please note, rather than using an IP address in the filter, we can also customize it to use custom properties or other filtering techniques.
The second complex condition listed below consist of 5 statements grouped with an “any” condition. This condition states that if the report fall on any day of a normal work week (Monday thru Friday) to include it in the report. We can also convert the report to display weekends by changing the report to Saturday or Sunday.