Esport PIX firewall data to excel file.

[al.avramenko]

Hi everyone. I have a ticket at work. I have to do a report about remote access VPN in XLS file. VPN server is based at the PIX firewall ( PIX Security Appliance Software Version 7.0) and ASDM 5.0. Report should be look like table bellow. May be it wouldn't be a problem if i had not 500 user accounts. How can I simplify this task. Thanks in advance.

#

username

group name

resourses allowed

end time

locked/unlocked

[Marvin Rhoads]

You cannot do that directly from either the PIX command line or ASDM. Even if you weren't running 10 year old software on a product that's been long-discontinued you'd need some external resources.

Typically we use either Cisco Security Manager (CSM) or an external syslog server if we need this sort of data.

The Pix can generate the syslog messages of VPN user logon and logoff but local storage is very limited so you cannot get the historical data from looking at the local syslog messages.