topic Re: Scheduled export of csv system log for Global Protect logins in General Topics

Scheduled export of csv system log for Global Protect logins

dpeterson4 — Thu, 27 Dec 2018 19:55:20 GMT

Have been looking around trying to find this and can't find it.

I have a filter for system logs to filter all the successfull Global Protect logins for the last calendar week.

I have been manually exporting this to a csv but wanted to schedule the process to email the csv out.

Is there any way to do this?

Re: Scheduled export of csv system log for Global Protect logins

BPry — Thu, 27 Dec 2018 20:53:45 GMT

@dpeterson4,

Do it through the API. Since you can't query the system logs in a custom job you can't really schedule it.

https://firewall/api/?type=log&log-type=system&query=(eventid eq globalprotectportal-auth-succ)

Obviously replace the query with your own.

https://firewall/api/?type=log&action=get&job-id=id

pull the job-id from the first command by reading <job>value</job> and feed that value into the second command.

Re: Scheduled export of csv system log for Global Protect logins

dpeterson4 — Thu, 27 Dec 2018 21:05:38 GMT

@BPry Thanks for the info! Got that to work but it's only returning 20 log entries and there are over 600. Any idea on how to get it to show all of them?

Thank you,

-Dustin

Re: Scheduled export of csv system log for Global Protect logins

BPry — Thu, 27 Dec 2018 21:42:40 GMT

@dpeterson4,

You need to modify the nlogs value, which defaults to 20 if not included in the request.

https://firewall/api/?type=log&log-type=system&query=(eventid eq globalprotectportal-auth-succ)&nlogs=5000&key=key

Re: Scheduled export of csv system log for Global Protect logins

dpeterson4 — Thu, 27 Dec 2018 21:52:48 GMT

Awesome!! You rock, that did it, thank you!!