Thanks Sundareshr, but it only gives me times between 5am and 11pm, so basically the same results I was getting before. I am trying to find any logins between 11pm -5am (i.e. midnight, 1 am, 2 am, etc... not 6am, 7 am, 1pm, 2pm, etc...) I ended up resolving it by changing the < > to the below:
tag=vpn earliest=-7d@d |eval HoD=strftime(_time, "%H") | where HoD<5 AND HoD<22 |sort user _time | table user _time vendor_action legal_time | top limit=1000 vendor_action
That gave me the results I was looking for. Thank you for helping still as it caused me to take a look again and also learn some new search syntax.
... View more