Added jetbrains_plugins table by ksykulev · Pull Request #8623 · osquery/osquery
fleetdm/fleet#20644
fleetdm/fleet#27914
This adds the jetbrains_plugins table. It contains a list of plugins installed on the system under a jetbrains product. Currently supported jetbrains products
CLion, DataGrip, GoLand, IntelliJIdea, IntelliJIdeaCommunityEdition, PhpStorm, PyCharm, PyCharmCommunityEdition, ReSharper, Rider, RubyMine, RustRover, WebStorm
An important thing to note about this table is in order to get some of the details about each plugin we must go through the jar files in the lib directory of the plugin and scan for a "plugin.xml" file. This requires zlib and libarchive.
Here is a sample output
osquery> select product_type, name, version, vendor, path from users cross join jetbrains_plugins using (uid);
+---------------------------------+-------------------+---------------+-----------+-------------------------------------------------------------------------------------------------------------------+
| product_type | name | version | vendor | path |
+---------------------------------+-------------------+---------------+-----------+-------------------------------------------------------------------------------------------------------------------+
| intellij_idea | AWS Toolkit | 3.51-243 | AWS | /Users/ksykulev/Library/Application Support/JetBrains/IntelliJIdea2024.3/plugins/aws-toolkit-jetbrains-standalone |
| intellij_idea | Plugin DevKit | 243.22562.218 | JetBrains | /Users/ksykulev/Library/Application Support/JetBrains/IntelliJIdea2024.3/plugins/devkit |
| intellij_idea | GitHub Copilot | 1.5.30-242 | GitHub | /Users/ksykulev/Library/Application Support/JetBrains/IntelliJIdea2024.3/plugins/github-copilot-intellij |
| intellij_idea | Swing UI Designer | 243.22562.218 | JetBrains | /Users/ksykulev/Library/Application Support/JetBrains/IntelliJIdea2024.3/plugins/uiDesigner |
| intellij_idea | AWS Core | 3.51-243 | AWS | /Users/ksykulev/Library/Application Support/JetBrains/IntelliJIdea2024.3/plugins/plugin-core |
| intellij_idea_community_edition | Docker | 251.26094.133 | JetBrains | /Users/ksykulev/Library/Application Support/JetBrains/IdeaIC2025.1/plugins/clouds-docker-impl |
| intellij_idea_community_edition | AWS Toolkit | 3.74-251 | AWS | /Users/ksykulev/Library/Application Support/JetBrains/IdeaIC2025.1/plugins/aws-toolkit-jetbrains-standalone |
| intellij_idea_community_edition | GitHub Copilot | 1.5.46-243 | GitHub | /Users/ksykulev/Library/Application Support/JetBrains/IdeaIC2025.1/plugins/github-copilot-intellij |
| intellij_idea_community_edition | AWS Core | 3.74.251 | AWS | /Users/ksykulev/Library/Application Support/JetBrains/IdeaIC2025.1/plugins/plugin-core |
+---------------------------------+-------------------+---------------+-----------+-------------------------------------------------------------------------------------------------------------------+