topic Re: Report issue - incorrect data in General Topics

Report issue - incorrect data

DKanta — Tue, 09 May 2017 11:05:42 GMT

Hi All,

i have a problem: when my customer generates reports there are problem with data, i see that the usage in one week is less than the sum of two random days in the same week.

example:

Week report: 450.5 G bytes

Day X: 588.3 G bytes

Day Y: 262.0 G bytes

Has anyone some hints?

Regards,

Daniele

Re: Report issue - incorrect data

kiwi — Tue, 09 May 2017 11:53:11 GMT

Hi @DKanta,

Your customer might be running into the 100K limit.

The 100K limit is the current limit in report generation. The report generation performs the query in the 'backward" direction (search from the latest to the oldest log entry until hitting the 100K limit) :

https://live.paloaltonetworks.com/t5/Management-Articles/Custom-Report-May-Not-Show-All-Data-Depending-on-Columns/ta-p/52158

Cheers,

-Kiwi

Re: Report issue - incorrect data

BPry — Tue, 09 May 2017 12:59:22 GMT

Yup, always fun to run into. That being said if you can try and limit the query to the point where it wouldn't hit this limit then that is ideal. Worst case scenario you generate the entire report on a day by day basis and then stitch it all together with some pdf merging to create one nice long week report. Hacky way of doing things but it at least presents the information that you need with a little more manual work on your end. 😉