Splunk Search

LDAP group reporting

aoliullah
Path Finder

Hi. Could someone suggest how I could go about creating a report that list all AD users and all the associated LDAP groups they belong to? This is required for audit purposes and tips on any other way of presenting the info would also be appreciated. Ideally I want a list that shows every AD group or may be just the privileged group a user account is part of.

Thanks in advance.

0 Karma
1 Solution

brreeves_splunk
Splunk Employee
Splunk Employee

You could use something like this if you have SA-ldapsearch installed:

| ldapsearch search="(&(objectClass=user)(!(objectClass=computer)))" attrs=* | table sAMAccountName memberOf

https://splunkbase.splunk.com/app/1151/

View solution in original post

brreeves_splunk
Splunk Employee
Splunk Employee

You could use something like this if you have SA-ldapsearch installed:

| ldapsearch search="(&(objectClass=user)(!(objectClass=computer)))" attrs=* | table sAMAccountName memberOf

https://splunkbase.splunk.com/app/1151/

aoliullah
Path Finder

Hi brreeves. Thanks for the answer. I shall try this and get back to you if need be.

0 Karma

aoliullah
Path Finder

Hi Breeves. For this to work will the search head need to be a windows box? Or does any other instance need to be a windows box to query AD?

0 Karma

brreeves_splunk
Splunk Employee
Splunk Employee

No, You'll just load the Splunk Support for Active Directory app and tell it where your AD servers are (it supports linux and windows, as it uses scripts to query AD). Then run the search and Splunk will query AD.

0 Karma
Get Updates on the Splunk Community!

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...