mac.extensionĮxtension_parent_app = Wayback Machine. SELECT * FROM safari_extensions_plist LEFT JOIN app_extension_pivot USING(bundle_identifier) īundle_identifier = archive. SELECT * FROM safari_raw WHERE enabled NOT NULL) WHERE path LIKE '/Users/%/Library/Containers//Data/Library/Safari/AppExtensions/ist ' GROUP BY key, path), REGEX_MATCH(key, ' \((.*?) \) ', 1) AS extension_idįROM plist JOIN human_accounts ha ON directory = '/Users/ ' || SPLIT( path, '/ ', 1) REGEX_SPLIT(key, ' \( ', 0) AS bundle_identifier, MAX(CASE WHEN subkey LIKE '%Has Injected Content ' THEN value END) AS has_injected_content, MAX(CASE WHEN subkey LIKE '%Level ' THEN value END) AS level, MAX(CASE WHEN subkey = 'Enabled ' THEN value END) AS enabled, SELECT username, uid, directory FROM users WHERE SUBSTR(uuid, 0, 8) != 'FFFFEEE '), WHERE path LIKE '/Applications/%.app/Contents/PlugIns/%.appex/Contents/ist '), All rights reserved.Īdditional research should be done to investigate whether additional paths should be considered (eg. PrivacyEssentials.SafariAppExtensionĭescription = DuckDuckGo Privacy Dashboard - track who we caught trying to track you.Ĭopyright = Copyright © 2019 Duck Duck Go, Inc. All rights reserved.Įxtension_parent_app = DuckDuckGo Privacy Essentials. 1PasswordSafariAppExtensionĭescription = Easy Access to Your Logins, Credit Cards and Identities.Ĭopyright = Copyright © 2018 AgileBits Inc. MAX(CASE WHEN key = 'NSHumanReadableCopyright ' THEN value END) AS copyrightīundle_identifier = com. MAX(CASE WHEN key = 'CFBundleVersion ' THEN value END) AS bundle_version, MAX(CASE WHEN key = 'CFBundleShortVersionString ' THEN value END) AS bundle_short_version, MAX(CASE WHEN key = 'NSHumanReadableDescription ' THEN value END) AS description, MAX(CASE WHEN key = 'CFBundleDisplayName ' THEN value END) AS display_name, MAX(CASE WHEN key = 'CFBundleIdentifier ' THEN value END) AS bundle_identifier, SPLIT( path, '/ ', 1) AS extension_parent_app, WITH extensions_flat AS ( SELECT * FROM plist WHERE path LIKE '/Applications/%.app/Contents/PlugIns/%SafariAppExtension.appex/Contents/ist ')
0 Comments
Leave a Reply. |