Daily URL Filtering Report within a time frame

cancel
Showing results for 
Search instead for 
Did you mean: 
Palo Alto Networks Approved
Palo Alto Networks Approved
Community Expert Verified
Community Expert Verified

Daily URL Filtering Report within a time frame

L1 Bithead

Hello,

 

I am trying to produce a report for our head of school accommodation that shows the URL filtering of his borders after a set time each day.

 

Producing the list in the URL filtering tab on the Palo Alto and downloading in CSV format is straightforward, but I would like to automate this process with a daily custom report of the night before.

 

Example of filter rule:
(( addr.src in <<IPAddressRange1>> ) and ( addr.src in <<IPAddressRange2>> )) and (user.src in 'boarders') and (receive_time geq '2022/03/03 22:00:00') and (receive_time leq '2022/03/03 23:59:59')

 

I am stuck in setting the time of the filter in the custom report query builder. It appears that I have to specify a date for ‘receive_time’ and can’t see any way around it. I have tried to see if there are any variables I can use, but no luck.

Any suggestions?

 

Thanks in advance,

Scott

Scott Menzies
1 ACCEPTED SOLUTION

Accepted Solutions

Cyber Elite
Cyber Elite

You can't set a timeframe in reports, but you can set a schedule in a security rule

you could create a duplicate rule above your current rule, that is only active from (for example) 7pm-7am, and any other filters you'd want to add.

you can then create a custom report and use the query builder to filter for only that rulename

 

FYI

(( addr.src in <<IPAddressRange1>> ) and ( addr.src in <<IPAddressRange2>> ))  needs to have OR in between the subnets

 

your filter should look something like this:

(( addr.src in <<IPAddressRange1>> ) or ( addr.src in <<IPAddressRange2>> )) and (user.src in 'boarders') and (rule eq MyScheduledRule)

Tom Piens
PANgurus - (co)managed services and consultancy

View solution in original post

2 REPLIES 2

Cyber Elite
Cyber Elite

You can't set a timeframe in reports, but you can set a schedule in a security rule

you could create a duplicate rule above your current rule, that is only active from (for example) 7pm-7am, and any other filters you'd want to add.

you can then create a custom report and use the query builder to filter for only that rulename

 

FYI

(( addr.src in <<IPAddressRange1>> ) and ( addr.src in <<IPAddressRange2>> ))  needs to have OR in between the subnets

 

your filter should look something like this:

(( addr.src in <<IPAddressRange1>> ) or ( addr.src in <<IPAddressRange2>> )) and (user.src in 'boarders') and (rule eq MyScheduledRule)

Tom Piens
PANgurus - (co)managed services and consultancy

L1 Bithead

@reaper Thank you, simple but effective.

 

Cheers,

Scott

Scott Menzies
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!