SOLVED

How to collect software inventory with SCCM CB for deployed MSIX apps?

%3CLINGO-SUB%20id%3D%22lingo-sub-1459710%22%20slang%3D%22en-US%22%3EHow%20to%20collect%20software%20inventory%20with%20SCCM%20CB%20for%20deployed%20MSIX%20apps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459710%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20explore%20MSIX%2C%20the%20concept%20is%20very%20interesting.%20So%20before%20deploying%20MSIX%20using%20SCCM%2C%20I%20have%20this%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnterprise%20wise%2C%20we%20want%20to%20gather%20information%20for%20the%20multitude%20of%20deployed%20applications.%20We%20used%20SCCM%20(Configuration%20Manager)%20for%20Software%20Inventory.%20Does%20anybody%20know%20how%20to%20retreive%20applications%20deployed%20with%20MSIX%20format%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20also%20posted%20this%20question%20in%20the%20Configuration%20Manager%20community%20AKA%20SCCM.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1459710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMSIX%20Inventory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1471766%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20collect%20software%20inventory%20with%20SCCM%20CB%20for%20deployed%20MSIX%20apps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1471766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698002%22%20target%3D%22_blank%22%3E%40Bigair-Mifi%3C%2FA%3EHi%2C%20you%20can%20use%20the%20WMI%20class%20SMS_G_System_WINDOWS8_APPLICATION%20to%20create%20a%20query%20in%20SCCM.%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20an%20example%3A%3CBR%20%2F%3E%3CBR%20%2F%3Eselect%20SMS_R_System.Name%2C%20SMS_R_System.Client%20from%20SMS_R_System%20inner%20join%20SMS_G_System_WINDOWS8_APPLICATION%20on%20SMS_G_System_WINDOWS8_APPLICATION.ResourceID%20%3D%20SMS_R_System.ResourceId%20where%20SMS_G_System_WINDOWS8_APPLICATION.ApplicationName%20%3D%20%22microsoft.windowscommunicationsapps%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20will%20show%20you%20all%20the%20computers%20with%20%22microsoft.windowscommunicationsapps%22.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20get%20all%20MSIX%2FAppx%20apps%20from%20the%20infrastructure%2C%20you%20could%20use%3A%3CBR%20%2F%3E%3CBR%20%2F%3Eselect%20distinct%20SMS_G_System_WINDOWS8_APPLICATION.ApplicationName%2C%20SMS_G_System_WINDOWS8_APPLICATION.FamilyName%2C%20SMS_G_System_WINDOWS8_APPLICATION.FullName%2C%20SMS_G_System_WINDOWS8_APPLICATION.Publisher%2C%20SMS_G_System_WINDOWS8_APPLICATION.Version%2C%20SMS_G_System_WINDOWS8_APPLICATION.Architecture%20from%20SMS_G_System_WINDOWS8_APPLICATION%3CBR%20%2F%3E%3CBR%20%2F%3EAdditionally%20you%20have%20a%20default%20report%20called%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fconfigmgr%2Fcore%2Fservers%2Fmanage%2Flist-of-reports%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%22Installations%20of%20specified%20Windows%20apps%22%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20want%20to%20do%20something%20in%20the%20database%2C%20you%20can%20use%20the%20v_GS_WINDOWS8_APPLICATION%20view.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199320i275D6DC6A4574A9E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1472042%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20collect%20software%20inventory%20with%20SCCM%20CB%20for%20deployed%20MSIX%20apps%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472042%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698002%22%20target%3D%22_blank%22%3E%40Bigair-Mifi%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMicrosoft%20Endpoint%20Configuration%20Manager%20has%20a%20pre-built%20report%20that%20is%20available%20to%20you%20to%20show%20information%20related%20to%20msix%20apps%20that%20have%20been%20installed%20on%20client%20devices.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EReport%20Name%3A%3C%2FSTRONG%3E%20All%20Windows%20Apps%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EReport%20Category%3A%3C%2FSTRONG%3E%20Software%20-%20Companies%20and%20Products%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20report%20will%20provide%20you%20with%20the%20ability%20to%20filter%20to%20your%20preferred%20application%20that%20you%20are%20looking%20to%20monitor%20the%20deployment%20of.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20screen%20capture%20shows%20the%20report%20results%20when%20searching%20for%20a%20specific%20MSIX%20app%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Roy_MacLachlan_0-1592422601808.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199314iE003F3F20FEFA3BC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Roy_MacLachlan_0-1592422601808.png%22%20alt%3D%22Roy_MacLachlan_0-1592422601808.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20that%20you%20found%20this%20information%20useful.%20If%20you%20have%20any%20questions%20or%20concerns%2C%20please%20feel%20free%20to%20ask.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3ERoy%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I want to explore MSIX, the concept is very interesting. So before deploying MSIX using SCCM, I have this question.

 

Enterprise wise, we want to gather information for the multitude of deployed applications. We used SCCM (Configuration Manager) for Software Inventory. Does anybody know how to retreive applications deployed with MSIX format?

 

I have also posted this question in the Configuration Manager community AKA SCCM.

 

Thanks!

 

 

4 Replies

@Bigair-MifiHi, you can use the WMI class SMS_G_System_WINDOWS8_APPLICATION to create a query in SCCM.

As an example:

select SMS_R_System.Name, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_WINDOWS8_APPLICATION on SMS_G_System_WINDOWS8_APPLICATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WINDOWS8_APPLICATION.ApplicationName = "microsoft.windowscommunicationsapps"


This will show you all the computers with "microsoft.windowscommunicationsapps".

To get all MSIX/Appx apps from the infrastructure, you could use:

select distinct SMS_G_System_WINDOWS8_APPLICATION.ApplicationName, SMS_G_System_WINDOWS8_APPLICATION.FamilyName, SMS_G_System_WINDOWS8_APPLICATION.FullName, SMS_G_System_WINDOWS8_APPLICATION.Publisher, SMS_G_System_WINDOWS8_APPLICATION.Version, SMS_G_System_WINDOWS8_APPLICATION.Architecture from SMS_G_System_WINDOWS8_APPLICATION

Additionally you have a default report called "Installations of specified Windows apps"

If you want to do something in the database, you can use the v_GS_WINDOWS8_APPLICATION view.Capture.PNG

best response confirmed by Bigair-Mifi (Occasional Contributor)
Solution

Hi @Bigair-Mifi

 

Microsoft Endpoint Configuration Manager has a pre-built report that is available to you to show information related to msix apps that have been installed on client devices.

 

Report Name: All Windows Apps

Report Category: Software - Companies and Products

 

This report will provide you with the ability to filter to your preferred application that you are looking to monitor the deployment of. 

 

The following screen capture shows the report results when searching for a specific MSIX app:

Roy_MacLachlan_0-1592422601808.png

 

I hope that you found this information useful. If you have any questions or concerns, please feel free to ask.

 

Thanks,

Roy

Great!

 

Thank you for your precious help!

@Bigair-Mifi If the interest is MSI versus MSIX+UWP, the install/exe path would tell you.  This would not help MSIX versus UWP, only looking into the AppXManifest file would do that.