Complete

chrome_extensions INFO

The chrome_extensions INFO provides details on chrome extensions

We extend the chrome_extensions  results with the common decorations, generic and data lake information available for all scheduled queries.

chrome_extensions Scheduled Query Schema

author string Optional extension author
identifier string Plugin identifier
name string Name of the registry value entry
path string Full path to the value
uid long The local user that owns the plugin
update_url string Extension-supplied update URI
version string Plugin short version

-- chrome_extensions INFO
SELECT 
   -- Device ID DETAILS
   meta_hostname, meta_ip_address, 

   -- Query Details
   query_name, author, identifier, name, path, uid,
   update_url, version,

   -- Decoration 
   meta_boot_time, meta_eid, meta_endpoint_type, 
   meta_ip_mask, meta_mac_address, meta_os_name, meta_os_platform, meta_os_type,
   meta_os_version, meta_public_ip, meta_query_pack_version, meta_username,

   --- Generic
   calendar_time, counter, epoch, host_identifier, numerics
   osquery_action, unix_time,

   -- Data Lake
   customer_id, endpoint_id, upload_size

FROM xdr_data
WHERE query_name = 'chrome_extensions'

RESULTS


+-----------------+-------------------+-------------------+----------+----------------------------------+---------------------------+----------------------------------------------------------------------------------------------------------------------------+-------+-------------------------------------------------+--------------+------------------+--------------------------------------+----------------------+----------------+--------------------+------------------------------+--------------------+----------------+-------------------+------------------+---------------------------+-----------------+----------------------+-----------+------------+-------------------+------------------+----------------------+--------------------------------------+--------------------------------------+---------------+
| meta_hostname   | meta_ip_address   | query_name        | author   | identifier                       | name                      | path                                                                                                                       |   uid | update_url                                      | version      |   meta_boot_time | meta_eid                             | meta_endpoint_type   | meta_ip_mask   | meta_mac_address   | meta_os_name                 | meta_os_platform   | meta_os_type   | meta_os_version   | meta_public_ip   | meta_query_pack_version   | meta_username   | calendar_time        |   counter |      epoch | host_identifier   | osquery_action   | unix_time            | customer_id                          | endpoint_id                          |   upload_size |
|-----------------+-------------------+-------------------+----------+----------------------------------+---------------------------+----------------------------------------------------------------------------------------------------------------------------+-------+-------------------------------------------------+--------------+------------------+--------------------------------------+----------------------+----------------+--------------------+------------------------------+--------------------+----------------+-------------------+------------------+---------------------------+-----------------+----------------------+-----------+------------+-------------------+------------------+----------------------+--------------------------------------+--------------------------------------+---------------|
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | aapocclcgogkmnckokdopfmhonfmgoek | Slides                    | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\aapocclcgogkmnckokdopfmhonfmgoek\0.10_0\            |  1002 | https://clients2.google.com/service/update2/crx | 0.10         |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           936 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | aohghmighlieiainnegkcijnfilokake | Docs                      | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\aohghmighlieiainnegkcijnfilokake\0.10_0\            |  1002 | https://clients2.google.com/service/update2/crx | 0.10         |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           934 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | apdfllckaahabafndbhieahigkjlhalf | Google Drive              | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\apdfllckaahabafndbhieahigkjlhalf\14.1_0\            |  1002 | https://clients2.google.com/service/update2/crx | 14.1         |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           942 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | blpcfgokakmgnkcojhhkbfbldkacnbeo | YouTube                   | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\blpcfgokakmgnkcojhhkbfbldkacnbeo\4.2.8_0\           |  1002 | http://clients2.google.com/service/update2/crx  | 4.2.8        |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           938 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | felcaaldnbdncclmgdcncolpebgiejap | Sheets                    | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\felcaaldnbdncclmgdcncolpebgiejap\1.2_0\             |  1002 | https://clients2.google.com/service/update2/crx | 1.2          |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           934 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | ghbmnnjooekpmoecnnnilnnbdlolhkhi | Google Docs Offline       | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\ghbmnnjooekpmoecnnnilnnbdlolhkhi\1.9.1_0\           |  1002 | https://clients2.google.com/service/update2/crx | 1.9.1        |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           951 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | nmmhkkegccagdldgiimedpiccmgmieda | Chrome Web Store Payments | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\nmmhkkegccagdldgiimedpiccmgmieda\1.0.0.5_0\         |  1002 | https://clients2.google.com/service/update2/crx | 1.0.0.5      |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           961 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | pjkljhegncpnkpknbcohdijeoejaedia | Gmail                     | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\pjkljhegncpnkpknbcohdijeoejaedia\8.2_0\             |  1002 | https://clients2.google.com/service/update2/crx | 8.2          |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           933 |
| Victim3-EDR     | 192.168.100.143   | chrome_extensions |          | pkedcjkdefgpdelpbcmbmeomcjbeemfm | Chrome Media Router       | C:\Users\test\AppData\Local\Google\Chrome\User Data\Default\Extensions\pkedcjkdefgpdelpbcmbmeomcjbeemfm\8220.313.1.1_0\    |  1002 | https://clients2.google.com/service/update2/crx | 8220.313.1.1 |       1601905066 | 07343bcf-3fb4-34bb-58a0-75ea91b4d569 | computer             | 255.255.255.0  | 00:50:56:2a:3a:13  | Microsoft Windows 7 Ultimate | windows            | client         | 6.1.7601          | 73.69.54.187     | 1.1.12                    | test            | 2020-10-10T10:57:17Z |         0 | 1602320453 | Victim3-EDR       | False            | 2020-10-10T10:57:17Z | b288d41b-53bb-64ae-5a67-1bc1507d5198 | 7043b3fc-f34b-43bb-850a-57ae194b5d96 |           965 |