Built off the open source project Osquery
Description: Hash a directory.
What The Data Shows: This query can assist in compliance audits.
SQL:
SELECT path,sha256 FROM hash WHERE path LIKE "\users\%\%%";
never-displayed
Not able to get it to work when I wrap the LIKE statement with ""
This works for me: WHERE path LIKE "\user\%\%%";
Same for me, but with single quote - worked after i removed the wrapped "" and replaced with '
@mrpeters22 @thinson thanks for letting us know! I have fixed it.