Splunk Search

ISE unique MAC reporting

redrobish1
Engager

Been testing to get a ISE-Splunk successful authentication report and trying this but the "Calling-Station-ID" is not displaying in table, I can see it exist.

index=network eventtype=cisco-ise CISE_RADIUS_Accounting host=ISEnode1 OR  | eval indextime=strftime(_indextime,"%Y-%m-%d %H:%M:%S") | table indextime Calling-Station-ID

 

Any help out there? I new with this Splunk search

Or anyone got a sample Splunk ISE Authentication report?

 

TIA

Labels (1)
0 Karma
1 Solution

scelikok
SplunkTrust
SplunkTrust

Hi @redrobish1,

Field name should by Calling_Station_ID. Please try below;

index=network eventtype=cisco-ise CISE_RADIUS_Accounting host=ISEnode1 OR  | eval indextime=strftime(_indextime,"%Y-%m-%d %H:%M:%S") | table indextime Calling_Station_ID

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

0 Karma

redrobish1
Engager

thanks scelikok, it does display now but somehow the results are too low. Any chance you got any sample reporting for ISE-Splunk (successful client report)? thanks again?

0 Karma

scelikok
SplunkTrust
SplunkTrust

Hi @redrobish1,

Field name should by Calling_Station_ID. Please try below;

index=network eventtype=cisco-ise CISE_RADIUS_Accounting host=ISEnode1 OR  | eval indextime=strftime(_indextime,"%Y-%m-%d %H:%M:%S") | table indextime Calling_Station_ID

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...