SLR Report - Get stats-dumb

[husetech]

Hello @all,

I would like to get a stats-dumb file which will be later used to generate an SLR report.

Since the timeframe (1 Week) via the PA GUI is not long enough for us, I use CLI with the following command to generate the file:

tftp export stats-dump start-time equal 2018/12/01@10:00:00 end-time equal 2018/12/31@10:00:00 to 10.164.15.27

!info: 10.164.15.27 is one of the AD and seemes to have a working connection to the PA, that's why I am using this server

When firing off this command it first seems to work but the generated file remains zeroed out:

After waiting for the timeout the final Log of PumpKIN looks like this:

What did I try to solve this issue?

1. Used several TFTP software, always getting the same result.

2. deactivated the AV + FW on the windows server

3. edited the security settings on the TFTP folder to allow everybody every access

Help is very much appriciated.

[reaper · Accepted solution]

-have you tried scp?

-or starting the tftpserver as administrator on your system

-or running it on a different system that may not have been locked down

-or allowing write access to the folder for everyone

-or adding a path or path+filename after the 'to'

tftp export stats-dump start-time equal 2018/12/01@10:00:00 end-time equal 2018/12/31@10:00:00 to 192.168.27.5/myexport.tgz

[husetech]

Hey @reaper,

-have you tried scp?

First thing I did after you wrote this was to try the export via scp.

After some trouble regarding the syntax I finally was able to pull the logs with this command:

scp export stats-dump start-time equal 2018/12/01@10:00:00 end-time equal 2018/12/31@10:00:00 to username_on_remote_System@10.164.15.27:/log_dez

!hint: after export, I had to extract the file twice to get the wanted folders + files

I also gave write access to everybody on the SCP destination folder

Thank you very much!

[michael.ang]

@husetech  @reaper 

Guys can you guide me on how to transfer the file to my computer. The report is generated but  i'm having problem with the Destination (username@host:path) part. 

scp export stats-dump start-time equal 2020/04/01@00:00:01 end-time equal 2020/04/30@10:00:00 to default@10.77.18.74:C:/Usersscp export stats-dump start-time equal 2020/04/01@00:00:01 end-time equal 2020/04/30@10:00:00 to default@10.77.18.74:/Desktop

Appreciate your help

[reaper]

You cant scp to a windows machine

You can either collect the file from the web interface, or tftp to a tinyftp on your windows machine

Set up a Linux machine to access scp if you need to use scp