this Data Lake query finds all Office Documents by file name in a given time frame and on specific host or all hosts (wildcard) and only those, that have not been touched by a specific process (e.g. dropbox.exe)
Unfortunately it does not find office macro files. Aren't they "productivity_documents", too?
I can only find office macros with live query currently but I need to let it run against data lake.
Any Idea how to modify the query to get docm, xlsm and so on from datalake with the same level of information?
meta_hostname AS ep_name,
name AS by_process_name,
path AS full_file_path,
date_format(from_unixtime(time, 'Europe/Berlin'), '%Y-%m-%d %H:%i:%S') as time
query_name = 'access_productivity_documents'
AND from_unixtime(time) BETWEEN from_unixtime($$__start_date$$) AND from_unixtime($$_end_date$$)
AND meta_hostname LIKE '$$hostname$$'
AND NOT name = '$$process_is_not$$'
AND (file_extension = '$$file_extension1$$' OR file_extension = '$$file_extension2$$')
ORDER by time DESC
Were you able to find a solution? I also want to run query on data lake to see all office macros. Thanks.
PM me and I'll grab them from an isolated VM.
cool. just the normal office docm, xlsm, pptm, ... you can create empty files with any MS office tool. I think it's not seen with pleasure if I upload macro files here?
I'll look into this. Do you have any sample files of macros I could populate my lab with?