we have some new hosts added in our instance. we need to built a search to check for newly added hosts.
We have used the below search but that is giving all the hosts that have communicated in the past 7 days rather than the ones that are newly added.
| metadata type=hosts |eval SevenDaysBack = relative_time(now(), "-7d@d") | where firstTime > SevenDaysBack | eval hostAdded=strftime(firstTime, "%d-%m-%Y %H:%M") | table host, hostAdded | sort hostAdded
Also metadata does not go well with timerange picker. the above search is not taking the time range as well.
Is there any other way that we can find a solution to this?
i think you should take a look at this answer post. Its a smart solution for your problem by creating a little lookup file.
i was checking this metadata, metasearch and dbinspect, plain search queries.. but still no luck.
one thought - you want to find out all hosts recently(last 7 days) added
do you have a host name or list of hosts, and you want to find out their date added to splunk?