topic Difference between making a report with "Run Now" and making it with the "Scheduled" option. in General Topics

Difference between making a report with "Run Now" and making it with the "Scheduled" option.

bprietoc — Wed, 06 Nov 2019 08:21:13 GMT

Hello,

I have created a custom report with the following settings in Panorama:

set shared reports "Threat Summary-Diario" type panorama-thsum sortby count
set shared reports "Threat Summary-Diario" type panorama-thsum group-by srcloc
set shared reports "Threat Summary-Diario" type panorama-thsum aggregate-by [ category-of-threatid threatid subtype src direction severity action app ]
set shared reports "Threat Summary-Diario" type panorama-thsum values count
set shared reports "Threat Summary-Diario" topn 500
set shared reports "Threat Summary-Diario" topm 50
set shared reports "Threat Summary-Diario" caption "Threat Summary-Diario"
set shared reports "Threat Summary-Diario" period last-calendar-day
set shared reports "Threat Summary-Diario" frequency daily

If you run the report with the "Run Now" option you get 750 lines.
If the same report is executed automatically when you have activated the "Schedule" option, only 30 lines are output.

Why this difference?

Re: Difference between making a report with "Run Now" and making it with the "Schedul

BatD — Wed, 06 Nov 2019 15:41:07 GMT

@sbprietoc It is because you are using the "threat summary" for base of the reports. Panorama tries to aggregate the data at 15 min intervals and you get unpredicatble results. If you use the actual "Threat" database then the "run now" should be identical to the scheduled.

"The firewall aggregates the detailed logs at 15-minute intervals. To enable faster response time when generating reports, the firewall condenses the data"

https://docs.paloaltonetworks.com/pan-os/9-0/pan-os-admin/monitoring/view-and-manage-reports/custom-reports.html

Re: Difference between making a report with "Run Now" and making it with the "Schedul

bprietoc — Thu, 07 Nov 2019 07:23:32 GMT

Hello @BatD ,

I will try it and let you know if it works.

Thank you.

Re: Difference between making a report with "Run Now" and making it with the "Schedul

bprietoc — Fri, 08 Nov 2019 07:03:13 GMT

Hello @BatD

Unfortunately, the result is a little better, but it's still different.