Splunk Search

How do you use the join command in an LDAP search?

solarboyz1
Builder

I am trying to create a search against our LDAP strategy to show the capabilities, indexes, and users assigned to each role.

Capabilities and indexes are easy enough to get, however, I'm stuck on the last part, which is to get ALL users in the AD group assigned to each role.

| rest /servicesNS/nobody/system/admin/LDAP-groups splunk_server=local
| mvexpand roles
| join roles
[
 | rest /servicesNS/nobody/system/admin/roles splunk_server=local
 | rename title as roles
 | eval ucaps=mvjoin(capabilities, ", ")
 | eval icaps=mvjoin(imported_capabilities, ", ")
 | eval uidx=mvjoin(srchIndexesAllowed,",")
 | eval iidx=mvjoin(imported_srchIndexesAllowed, ",")
 | eval idx=mvappend(iidx,uidx)
 | eval caps=mvappend(icaps,ucaps)
 | table roles caps idx
]
| eval roles=mvjoin(roles, " ")
| stats values(roles) as roles, values(caps) as capabilities, values(idx) as indexes, by  title 
| rename title as group
| foreach group
[ | ldapsearch search="(&(objectCategory=group)(cn="<<FIELD>>*"))" attrs="distinguishedName,member" | rex field=distinguishedName "CN=(?<group>[^,]+)," | stats values(member) as members by group | table members group ]
0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...