topic Re: SLR Report - Get stats-dumb in General Topics

SLR Report - Get stats-dumb

husetech — Wed, 27 Feb 2019 07:08:15 GMT

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.

Re: SLR Report - Get stats-dumb

reaper — Wed, 27 Feb 2019 15:39:50 GMT

-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

Re: SLR Report - Get stats-dumb

husetech — Thu, 28 Feb 2019 08:34:08 GMT

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!

Re: SLR Report - Get stats-dumb

michael.ang — Mon, 18 May 2020 18:58:54 GMT

@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

Re: SLR Report - Get stats-dumb

reaper — Mon, 18 May 2020 19:48:54 GMT

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