The VMware Carbon Black Tech Zone is live! Checkout this great resource: Mastering Carbon Black Audit & Remediation.

Review Hash Directory

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\%\%%";

 

 

4 Comments
Query_Admin
Community Manager
Community Manager
Status changed to: Approved
 
thinson
Carbon Black Employee

Not able to get it to work when I wrap the LIKE statement with ""

This works for me: WHERE path LIKE "\user\%\%%"; 

mrpeters22
Contributor III

Same for me, but with single quote - worked after i removed the wrapped "" and replaced with '

jnelson
Carbon Black Employee

@mrpeters22  @thinson thanks for letting us know! I have fixed it.