Joe Bussing
08/24/2018, 10:00 PMtime
value. If 0 is the default why would this show as empty?
""
This is causing problems for us because we are receiving alerts on command line events that realistically occurred more than 1 year ago and have already been worked and triaged, but we can't make that determination just by looking at the shell_history table.
We have thought about using file integrity monitoring on shell_history files in order to get access to the file_events table data and combine the two tables to give an idea about the last time the shell_history file actually modified, but this seems like overkill and I was hoping someone might have a more elegant solution.Mike Myers
08/24/2018, 10:18 PMJoe Bussing
08/24/2018, 10:21 PMthor
08/24/2018, 10:23 PMr["time"] = timestamp.empty() ? INTEGER(0) : INTEGER(timestamp);