I want list of all the forwarders with their first installation date or exactly since when they are sending data to Indexers.
Can someone please provide any details on this. Appreciate your help on this. Thanks !
Use the metadata command:
| metadata type=hosts index=_internal | eval first_connected=strftime(firstTime, "%Y/%m/%d %H:%M:%s") | table host first_connected
This will show you the earliest event from Splunk for your hosts, you can then search with
To add to @nickhillscpl answer:
Set the time range picker to "All Time".
Also note that this search will retrieve the earliest events in the _internal index which are still available in Splunk. Older events might have been discarded due to exceeded retention periods or full indexes.
Thanks @whrg - I should have noted that!
If your _internal retention is shorter than your application/security data, you can always switch to
index=myindex to look at the earliest event from a specific index
yes older events have been discarded. This query is not giving me results i wanted.
Is there any other query which will give me first installation date.