Retrieve Firefox Addons that are installed and not set to auto update

[ksnihur]

Description: Query looks for installed Firefox add-ons that are active and not set to auto update.

What The Data Shows: This is useful to determine what machines have Firefox add-ons that are not set to auto-update, having all software updated to the latest version is necessary and best practice and #1 on the NSA's top 10 Cyber Security mitigations. 

SQL: 

SELECT u.username,fa.name,fa.type,fa.version,fa.description,fa.source_url
FROM users AS u
JOIN firefox_addons AS fa USING(uid)
WHERE active=1 and autoupdate=0;

[jnelson]

@ksnihur this table will not return results for other users without a JOIN with the users table. Please consider the following change:

SELECT u.username,fa.name,fa.type,fa.version,fa.description,fa.source_url
FROM users AS u
JOIN firefox_addons AS fa USING(uid)
WHERE active=1 and autoupdate=0;

[ksnihur]

Thanks @jnelson updated as requested so all users results are obtained.