Splunk Search

Extracting Report from CISCO FW Logs

msamant
New Member

We have installed Splunk recently and forwarding our Cisco FW logs through syslog. We have also installed the Splunk for Cisco Security app from splunkbase. I am getting the logs forwarded to Splunk but somehow not able to extract the search results in a report. I need the extraction to show me:
Date SourceIP Protocol DestinationIP Protocol Action

what i get in my search is all raw data which is not helping me troubleshooting my rules. Can anyone point me on how can i extract the report in csv with only the above needed fields.

Hope to get some help here.

Best Regards
Mangesh

Tags (1)
0 Karma

msamant
New Member

I am pretty new with this tool, can you please upload the extraction you did from my logs. I will check what steps i am missing here. If possible also if you can let me know the steps you did for same.

It will be a great help.

0 Karma

Ayn
Legend

The Cisco Firewall app has support for ASA logs. Did you install this app (not just the Cisco Security app)? If yes, you should read the README.txt contained in the app's root directory and make sure you've installed the app properly per the instructions listed there.

0 Karma

Ayn
Legend

I just tried some extractions from the firewall app on the log sample you supplied and they work properly. So, your log support seems not to be installed correctly.

0 Karma

msamant
New Member

Yes ASA logs support has been installed correctly.

0 Karma

msamant
New Member

Its the CISCO ASA FW. Below is the search result, need to extract only the sourceip protocol destination protocol and action in a csv file for further troubleshooting:

2012-07-01 10:34:42 local6.info 10.X.X.X 10.X.X.X :Jul 01 10:34:40 UTC: %ASA-session-6-302013: Built outbound TCP connection 26867062 for DMZ_OUT:1X.X.X.X/4XX (1X.X.X.X/4XX) to DMZ_IN:1X.X.X.X/25693 (1X.X.X.X/25693)\n

Best Regards
Mangesh

0 Karma

Ayn
Legend

What Cisco firewall is it? Could you please post some sample data (anonymized if needed)?

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...