cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

need some help with report filters

Jump to solution

Hi All

I'm looking to edit the Historical - Response Time and Packet Loss report to give me a snapshot of the peak and average response times for the routers at our remote depots

so I want the entries for midnight (00.00) for a selection of our nodes

I think I want to do something like:

select records where all of the following apply

Select records where Hour of Day is equal to 0 (just this part of the query on its own works fine)

select records where any of the following apply

records where Node ID is equal to 147

Records where Node ID is equal to 148

up to line 5 returns node 147 at 00.00

adding line 6 returns nothing

line 6 is not indented in the way that line 5 is

so I'm a bit stuck now and looking for some help

thank you in advance

Laurence

Labels (2)
0 Kudos
1 Solution

As long as you keep adding by selecting the last condition on the list and picking "Add a new elementary condition", you should be able to create a long list.

You can also create ranges for the sequential NodeID's. I'm going to try to attach a screenshot. I am on NPM 11.5, not sure if that matters or not.

Capture.JPG

View solution in original post

0 Kudos
4 Replies
Level 9

I configured the same report. Mine looks like this and works:

Select records where all of the following apply

  Records where Time of Day (24 hour format) is greater than or equal to 00:00:00

  Records where Time of Day (24 hour format) is less than or equal to 00:02:00

  Select records where any of the following apply

    Records where NodeID is equal to 147

    Records where NodeID is equal to 148

The way it is indented is important.

I hope that helps.

0 Kudos

Hi cjarocki

thank you for your reply. I have worked through your suggestion

I want to report on nodes:

147, 148, 149, 150, 151, 152, 153, 155, 156, 157, 158, 159, 160, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 253, 255, 257, 265, 268, 291, 361, 362, 364, 365, 367, 386, 390, 393

but I seem only to able to add three elementary conditions at the required nest level so I'm stuck again

regards

Laurence

0 Kudos

As long as you keep adding by selecting the last condition on the list and picking "Add a new elementary condition", you should be able to create a long list.

You can also create ranges for the sequential NodeID's. I'm going to try to attach a screenshot. I am on NPM 11.5, not sure if that matters or not.

Capture.JPG

View solution in original post

0 Kudos

thats sorted it

thank you

0 Kudos