Deployment Architecture

How ignore certain index types from the dbinspect

satyabhi21
New Member

I'm trying to run the following search and I still get the results from the index even after I mention I NOT to see the results from these particular indexes, need help with correcting this search to ignore the indexes

| dbinspect index=* NOT index=_internals NOT index=_introspection NOT index=collectd NOT index=splunkforwarders NOT index=_audit| search state=hot | eval diff=now()-endEpoch | eval daysAlive=diff/60/60/24 | where daysAlive > 35 | convert ctime(startEpoch) | convert ctime(endEpoch) |  stats sum(sizeOnDiskMB) as diskSpace 
0 Karma

richgalloway
SplunkTrust
SplunkTrust

dbinspect accepts more than one index name, but doesn't accept a search-like expression. Try this alternative:

| dbinspect index=* | search NOT index=_internal NOT index=_introspection NOT index=collectd NOT index=splunkforwarders NOT index=_audit| search state=hot | eval diff=now()-endEpoch | eval daysAlive=diff/60/60/24 | where daysAlive > 35 | convert ctime(startEpoch) | convert ctime(endEpoch) |  stats sum(sizeOnDiskMB) as diskSpace
---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Operationalizing TDIR: Building a More Resilient, Scalable SOC

Optimizing SOC workflows with a unified, risk-based approach to Threat Detection, Investigation, and Response ...

Pro Tips for First-Time .conf Attendees: Advice from SplunkTrust

Heading to your first .Conf? You’re in for an unforgettable ride — learning, networking, swag collecting, ...

Raise Your Skills at the .conf25 Builder Bar: Your Splunk Developer Destination

Calling all Splunk developers, custom SPL builders, dashboarders, and Splunkbase app creators – the Builder ...