Scheduled export of csv system log for Global Protect logins

[dpeterson4]

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?

[BPry]

@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. 

[dpeterson4]

@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

[BPry · Accepted solution]

@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

[dpeterson4]

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