Custom reports problem

Radmin_85 — Tue, 24 Apr 2018 06:49:47 GMT

We have problems with creating custom reports

We configured custom reports as we need pointing the time interval for one month but the report shows us only two last days of the previous month.

i can also show you

admin@PA-3020> show system logdb-quota
Quotas:
              system: 4.00%, 3.231 GB Expiration-period: 0 days
              config: 4.00%, 3.231 GB Expiration-period: 0 days
               alarm: 3.00%, 2.423 GB Expiration-period: 0 days
             appstat: 4.00%, 3.231 GB Expiration-period: 0 days
         hip-reports: 1.00%, 0.808 GB Expiration-period: 0 days
             traffic: 30.00%, 24.231 GB Expiration-period: 0 days
              threat: 16.00%, 12.923 GB Expiration-period: 0 days
               trsum: 7.00%, 5.654 GB Expiration-period: 0 days
         hourlytrsum: 3.00%, 2.423 GB Expiration-period: 0 days
          dailytrsum: 1.00%, 0.808 GB Expiration-period: 0 days
         weeklytrsum: 1.00%, 0.808 GB Expiration-period: 0 days
              urlsum: 2.00%, 1.615 GB Expiration-period: 0 days
        hourlyurlsum: 1.00%, 0.808 GB Expiration-period: 0 days
         dailyurlsum: 1.00%, 0.808 GB Expiration-period: 0 days
        weeklyurlsum: 1.00%, 0.808 GB Expiration-period: 0 days
               thsum: 2.00%, 1.615 GB Expiration-period: 0 days
         hourlythsum: 1.00%, 0.808 GB Expiration-period: 0 days
          dailythsum: 1.00%, 0.808 GB Expiration-period: 0 days
         weeklythsum: 1.00%, 0.808 GB Expiration-period: 0 days
              userid: 1.00%, 0.808 GB Expiration-period: 0 days
   application-pcaps: 1.00%, 0.808 GB Expiration-period: 0 days
             extpcap: 1.00%, 0.808 GB Expiration-period: 0 days
debug-filter-pcaps: 1.00%, 0.808 GB Expiration-period: 0 days
            dlp-logs: 1.00%, 0.808 GB Expiration-period: 0 days
            hipmatch: 3.00%, 2.423 GB Expiration-period: 0 days
                 gtp: 2.00%, 1.615 GB Expiration-period: 0 days
              gtpsum: 1.00%, 0.808 GB Expiration-period: 0 days
        hourlygtpsum: 0.75%, 0.606 GB Expiration-period: 0 days
         dailygtpsum: 0.75%, 0.606 GB Expiration-period: 0 days
        weeklygtpsum: 0.75%, 0.606 GB Expiration-period: 0 days

auth: 1.00%, 0.808 GB Expiration-period: 0 days
                sctp: 0.00%, 0.000 GB Expiration-period: 0 days
             sctpsum: 0.00%, 0.000 GB Expiration-period: 0 days
       hourlysctpsum: 0.00%, 0.000 GB Expiration-period: 0 days
        dailysctpsum: 0.00%, 0.000 GB Expiration-period: 0 days
       weeklysctpsum: 0.00%, 0.000 GB Expiration-period: 0 days
Disk usage:
traffic: Logs and Indexes: 25G Current Retention: 22 days
threat: Logs and Indexes: 13G Current Retention: 35 days
system: Logs and Indexes: 72M Current Retention: 161 days
config: Logs and Indexes: 177M Current Retention: 67 days
alarm: Logs and Indexes: 32K Current Retention: 0 days
trsum: Logs and Indexes: 5.7G Current Retention: 48 days
hourlytrsum: Logs and Indexes: 2.4G Current Retention: 15 days
dailytrsum: Logs and Indexes: 779M Current Retention: 11 days
weeklytrsum: Logs and Indexes: 736M Current Retention: 62 days
thsum: Logs and Indexes: 788M Current Retention: 65 days
hourlythsum: Logs and Indexes: 807M Current Retention: 42 days
dailythsum: Logs and Indexes: 818M Current Retention: 65 days
weeklythsum: Logs and Indexes: 475M Current Retention: 62 days
appstatdb: Logs and Indexes: 147M Current Retention: 67 days
userid: Logs and Indexes: 837M Current Retention: 10 days
hipmatch: Logs and Indexes: 32K Current Retention: 0 days
extpcap: Logs and Indexes: 28K Current Retention: 0 days
urlsum: Logs and Indexes: 1.7G Current Retention: 49 days
hourlyurlsum: Logs and Indexes: 819M Current Retention: 32 days
dailyurlsum: Logs and Indexes: 794M Current Retention: 46 days
weeklyurlsum: Logs and Indexes: 773M Current Retention: 62 days
gtp: Logs and Indexes: 24K Current Retention: 0 days
gtpsum: Logs and Indexes: 560K Current Retention: 0 days
hourlygtpsum: Logs and Indexes: 544K Current Retention: 0 days
dailygtpsum: Logs and Indexes: 536K Current Retention: 0 days
weeklygtpsum: Logs and Indexes: 80K Current Retention: 0 days
auth: Logs and Indexes: 24K Current Retention: 0 days
sctp: Logs and Indexes: 16K Current Retention: 0 days
sctpsum: Logs and Indexes: 296K Current Retention: 0 days
hourlysctpsum: Logs and Indexes: 8.0K Current Retention: 0 days
dailysctpsum: Logs and Indexes: 8.0K Current Retention: 0 days
weeklysctpsum: Logs and Indexes: 8.0K Current Retention: 0 days
application: Logs and Indexes: 383M Current Retention: 67 days
filters: Logs and Indexes: 4.0K Current Retention: 0 days
dlp: Logs and Indexes: 4.0K Current Retention: 0 days
hip_report_base: Logs and Indexes: 1.1M Current Retention: N/A
wildfire: Logs and Indexes: 120K Current Retention: N/A

Space reserved for cores:       0MB

Re: Custom reports problem

Radmin_85 — Tue, 24 Apr 2018 07:11:14 GMT

we can not see in the reports more than 10000 lines

Re: Custom reports problem

kiwi — Tue, 24 Apr 2018 07:51:16 GMT

Hi @Radmin_85,

The GUI view is more restricted in the number of lines it can display.

Try exporting to a CSV report ... default max rows is 65535 but you can increase it to max value of 1048576 :

https://live.paloaltonetworks.com/t5/Management-Articles/How-to-Increase-the-Max-Rows-in-CSV-Export/ta-p/65727

Cheers !

-Kiwi.

Re: Custom reports problem

Radmin_85 — Tue, 24 Apr 2018 08:53:07 GMT

Did not help

Re: Custom reports problem

kiwi — Tue, 24 Apr 2018 09:24:27 GMT

Hi @Radmin_85,

Sorry I missed this in your first post but ... custom reports do have a max of top 10000.

The limit I was referring to is when you pull a report from the traffic logs directly. Add your filter to the traffic logs view and add a timeframe :

Your filter + ( receive_time leq '2018/04/13 13:45:12' ) and ( receive_time geq '2018/04/13 13:40:12' ) for example.

I just tested this and was able to pull out a report with 30.000+ lines.

Cheers !

-Kiwi

Re: Custom reports problem

JeanPaul222 — Mon, 21 Oct 2024 13:48:58 GMT

Hello. So, is there no way to display more than 10,000 rows while generating a custom report?

topic Re: Custom reports problem in General Topics

Custom reports problem

Re: Custom reports problem

Re: Custom reports problem

Re: Custom reports problem

Re: Custom reports problem

Re: Custom reports problem