topic Re: Anyone know of a way of finding the last modified date/time of a saved search/report in Splunk? in Splunk Search

Anyone know of a way of finding the last modified date/time of a saved search/report in Splunk?

zindain24 — Wed, 30 Mar 2016 20:02:14 GMT

I have an audit request to show the last time a report was modified.

Thanks,
Jeremy

Re: Anyone know of a way of finding the last modified date/time of a saved search/report in Splunk?

MuS — Wed, 30 Mar 2016 20:29:00 GMT

Hi zindain24,

How about this:

index="_internal" (sourcetype=splunkd_access "POST /servicesNS/" "/search/saved/searches") file!="notify"
| table _time clientip user file | rename file AS saved_search

This will create a table containing time, clientip, user and the saved_search name.

Hope this helps ...

cheers, MuS

Re: Anyone know of a way of finding the last modified date/time of a saved search/report in Splunk?

MuS — Wed, 30 Mar 2016 23:14:27 GMT

Just a small update on this, based on some background discussion with @martin_mueller:

the sourcetype could also be splunkd_ui_access
set up processes for modifying production splunk, show processes are followed, done and sprinkle some git, chef, etc around
if someone fiddles with savedsearches.conf any other way you will not get it in _internal because it only covers REST calls

cheers, MuS

Re: Anyone know of a way of finding the last modified date/time of a saved search/report in Splunk?

zindain24 — Tue, 29 Sep 2020 09:14:10 GMT

Thanks MuS! Here is what I ended up with:

index="_internal" NOT 201 NOT 400 (sourcetype=splunkd_access "POST /servicesNS/" "/search/saved/searches") NOT notify| rex "(?enable|disable)\s" | convert ctime(_time) as time |rex "saved/searches/(?\S+?)[\/|\s]" |rex "^(?:[0-9]{1,3}.){3}[0-9]{1,3}\s-\s(?\w+)" |rex "(?\d+)ms" |table time, User, SearchName, Action, MSExecutionTime | fillnull value="modify/save" |rename MSExecutionTime AS ExecutionTime(ms)