Splunk Enterprise

How to find the last change or modification on multiple AD groups?

vttrl123
New Member

I have a csv file containing the SAM accounts of 1200 AD groups and I need to find out the proper search query to find the last date of their modification or change.

Labels (1)
0 Karma

Richfez
SplunkTrust
SplunkTrust
| inputlookup <lookup or filename>
| stats max(<field that's the date field>)

or

| inputlookup <lookup or filename>
| stats max(<field that's the date field>) BY displayName

 

And if you were wanting a more useful way

base search here that returns regular data
| lookup <lookupName> <fieldInLookup> AS <fieldInData> OUTPUT lastUpdate

Which assuming you fix up the lookup name, double-check the fieldInLookup vs. fieldInData order (I always get those backwards!) and change the fieldname 'lastUpdate' to whatever it is in your lookup, will output the lastUpdate for each ... "field" you match on.  Perhaps displayName or something, whatever it is that should match.

This might help:

https://docs.splunk.com/Documentation/SplunkCloud/8.2.2107/SearchReference/Lookup

 

0 Karma
Get Updates on the Splunk Community!

Synthetic Monitoring: Not your Grandma’s Polyester! Tech Talk: DevOps Edition

Register today and join TekStream on Tuesday, February 28 at 11am PT/2pm ET for a demonstration of Splunk ...

Instrumenting Java Websocket Messaging

Instrumenting Java Websocket MessagingThis article is a code-based discussion of passing OpenTelemetry trace ...

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...