Add apps installed through Windows app store to software inventory

[zayhanlon]

Goal

User story
As an endpoint engineer on the Software page,
I want to see Windows apps installed via the Windows app store
so that I know which Windows app store apps are installed on my hosts.

Changes

Product

• [ ] UI changes: TODO
• [ ] CLI usage changes: TODO
• [ ] REST API changes: TODO
• [ ] Permissions changes: TODO
• [ ] Outdated documentation changes: TODO
• [ ] Changes to paid features or tiers: TODO
• [ ] Scalability testing: TODO

Engineering

• [ ] Database schema migrations: TODO

ℹ️  Please read this issue carefully and understand it. Pay special attention to UI wireframes, especially "dev notes".

Context

• Requestor(s): _________________________

QA

Risk assessment

• Requires load testing: TODO
• Risk level: Low / High TODO
• Risk description: TODO

Manual testing steps

1. Step 1
2. Step 2
3. Step 3

Testing notes

Confirmation

1. [ ] Engineer (@____): Added comment to user story confirming succesful completion of QA.
2. [ ] QA (@____): Added comment to user story confirming succesful completion of QA.

[noahtalerman]

Feature fest: This is core. I don't think we have to capacity to take it on next sprint. Please bring it back.

[Patagonia121]

customer-knopfia brought this up again today (11/16) asking for a status update - let's discuss!

[noahtalerman]

This is core. Ideally we add this to osquery. Quick win would be to use a script under the hood for this.

[marko-lisica]

@zayhanlon We didn't get to this one in the current design sprint. Adding it to feature fest.

[noahtalerman]

Marcos: FWIW, the list of Windows Store Apps can be retrieving running the following command in powershell: Get-AppxPackage”

[noahtalerman]

Problem

Apps installed through Windows App Store not scanned for software by Fleet/ software inventory, so the Feature Request is to add capability for Fleet to scan for apps in places other than <programs>

Customer threads for context: https://fleetdm.slack.com/archives/C04J21SERJ7/p1695041624733869 https://fleetdm.slack.com/archives/C0548M4T86A/p1694780308735389 https://fleetdm.slack.com/archives/C04JD2Z4M1B/p1695063286200379

Context from Marcos: https://fleetdm.slack.com/archives/C019WG4GH0A/p1694783681077829 The problem here is that only the applications installed through msiexec (windows installer) are listed. That's what the programs table retrieves - see here. This will match the list of apps shown in “Add/Remove Programs”, but will miss the apps installed through the Windows Store

[noahtalerman]

@zayhanlon we brought in too much to the current design sprint.

Removing this one from the current design sprint. This is core to Fleet so we'll get to it.

[noahtalerman]

Heads up @zayhanlon this request was discussed during feature fest last week and didn't make it into the current design sprint.

[noahtalerman]

@nonpunctual: I can help write the osquery query for this.