how to get IP address from CISCO ACS logs ?

[seetharamanPr]

Hi All,

We have configured ACS in splunk and it is generating reports properly. We have configured ACS in splunk so it can pull out the top 10 failed user logins and have used the below string to achieve the same.

index=acs action=failure signature=Failed_Attempts |top user

everything works fine but I would like 2 modify this string so that it also includes the IP address of the user apart from their username. Is this possible if yes kindly let me know how to achieve the same. Thank you in advance.

Regards
Pradeep

[alemarzu]

Hi @seetharamanPr

Try this.

index=acs action=failure signature=Failed_Attempts | stats values(IP) AS IP, count by user | sort - count | head 10

Hope it helps.