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

Chrome Extensions exclude Google

Description: Looks for all installed extensions that are not made by Google.

What The Data Shows: Reduces the noise by excluding all Google extensions.

SQL:

SELECT username, directory, shell, type, name, version, locale, update_url, author, persistent, path 
FROM users JOIN chrome_extensions USING (uid)
WHERE name != 'Chrome Media Router' and name != 'Chrome Web Store Payments' and name != 'Docs' and name != 'Gmail' and name != 'Google Docs Offline' and name != 'Google Drive' and name != 'Sheets' and name != 'Slides' and name != 'YouTube';

 

 

4 Comments
jnelson
Carbon Black Employee
Status changed to: Under Review

@ksnihur There is a space in front of Docs so the query does not filter that extension out. Can you please edit it?

ksnihur
Contributor II

Fixed thanks @jnelson 

jnelson
Carbon Black Employee
Status changed to: Approved
 
mgoodacre
Contributor III

Which DB would I run this query against? 

I get this error. We dont have a DB admin for this app, i mostly use the Web UI for administration. 

Msg 321, Level 15, State 1, Line 2
"uid" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.