Hello everyone.
Want to display the output only for the time which crosses 18 months (earliest time)
For the PST part, run the search as a user that had <LoginID>
-> Preferences
-> Time zone
to PST.
For the other part, you can add something like this to your search:
... | eval date_wday = strftime(_time, "%a")
| where NOT (date_wday = "Sat" OR date_wday = "Sun")
many answers in this portal, here are couple:
https://answers.splunk.com/answers/426673/how-to-filter-out-weekdays-or-weekends-in-one-sear.html
https://answers.splunk.com/answers/660420/how-to-exclude-weekends-from-last-30-days-search.html
you can address the time in many different ways, depending on your user setting, timestamp, and other.
if data is generated in the West Coast, you can also try and use _indextime
hope it helps