We've disabled the UI for our indexers so don't have access to the manager UI for them. The search head UI only shows stats for it's own indexes. How do I list out the stats for my indexer's indexes. I'm interested in current size, last event indexed, and also hotdb/warmdb/colddb counts.
Sure, I could go to the filesystem to look this up but would be nice if there were a search I could run to get this or a splunk command that will list this out from one place for all indexers, if possible.
As confirmed by the gkanapathy, you cannot run dbinspect on other machines from the UI. However, you can use the -uri option via command line.
./splunk dispatch "| dbinspect index=myindex" -uri https://<server>:8089
Please file an ER to request distributed search support for the
dbinspect command. Currently
dbinspect only returns results from the local machine. For now, you would have to run
dbinspect on each indexer an aggregate the results together.
It's basically a perl script that I wrote that parses the indexes.conf and uses the dbinspect command functionality to get the information you're looking for.
Unfortunately, the dbinspect command doesn't allow wildcards, hence the parsing of the indexes.conf file.