How to inventory and report on installed apps?

[bservet]

I'm trying to get an overview off all installed apps (not programs) on both our company owned IOS devices and our Windows store enabled computers. The SCCM documentation clearly states that this is possible but I can't find any report or query which can produce the results. The resource explorer also doesn't list any installed app.

 

Software & hardware inventory is already enabled for all devices but maybe the device policy should also have a setting for the platform specific file extensions? For example: *.ipa for IOS?

 

Any help in getting this to work would be much appreciated,

 

thanks!

 

[Peter van der Woude]

I just checked my lab and, with default configuration for mobile device inventory, I'm seeing all installed apps on my iPad in the Resource Explorer in the category Mobile Device Installed Application.

[bservet]

Thanks for the reply Peter! I was looking under software instead of the hardware inventory.

 

But is there also a way to query or report the apps?

 

thanks!

[GarthMJ]

Yes, You can do both.. in a nutshell if the data exists within CM database you can do anything with it.

[bservet]

I ended up with these queries who list all apps and the corresponding device names.

select SMS_G_System_DEVICE_INSTALLEDAPPLICATIONS.Name, SMS_R_System.Name from  SMS_R_System inner join SMS_G_System_DEVICE_INSTALLEDAPPLICATIONS on SMS_G_System_DEVICE_INSTALLEDAPPLICATIONS.ResourceID = SMS_R_System.ResourceId

And here's my query for Windows 8 & 10 apps with a lot of filters to skip most of the pre-installed ones:

 

select SMS_G_System_WINDOWS8_APPLICATION.ApplicationName, SMS_R_System.Name 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 not like "%24712m%" and SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%f5.vpn.client%" and SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%checkpoint%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%filemanager%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%junipernetworks%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%bing%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%playreadyclient%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%mocamera%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.net.native%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%onenote%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.reader%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%vclibs.110%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%vclibs.120%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%vclibs.140%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowsalarms%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowscalculator%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowscamera%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowscommunicationsapps%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%kinect%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowsreadinglist%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowsscan%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windowssoundrecorder%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%winjs%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%xboxlivegames%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%zune%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%sonicwall%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%immersivecontrolpanel%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%winstore%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%xeroxcorp%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%helpandtips%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%remotedesktop%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.getstarted%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.skypeapp%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%windows.photos%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.windowsphone%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.windowsstore%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.windows.cortana%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.xbox%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.windowsmaps%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.windowsfeedback%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%contentdeliverymanager%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%cloudexperiencehost%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%assignedaccesslockapp%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%parentalcontrols%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%shellexperiencehost%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.people%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoftofficehub%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoftedge%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.bioenrollment%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.accountscontrol%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.appconnector%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.aad.brokerplugin%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.3dbuilder%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%microsoft.lockapp%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%solitaire%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%purchasedialog%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%printdialog%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%miracastview%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%devicesflow%" and

SMS_G_System_WINDOWS8_APPLICATION.ApplicationName not like "%contactsupport%"

Maybe they are of use for other people as well.

 

 

Thanks!