bservet

Out of my 300 Windows 10 clients about 100 still haven't upgraded to 1709 despite a servicing plan which targets all of them. The old Windows versions are mostly running 1703 and some are still on 1607. The problem seems to be that no matter which criteria I use in the plan, the number client requiring the upgrade remain much to low: It's not clear to me why this is happening or how I can fix this. I guess that if the upgrade packages aren't detected as required any servicing plan is bound to fail. The upgrade has worked for the other clients and WSUS is syncing successfully so I'm currently out of ideas on how to fix this. Any help on solving this is much appreciated, thanks! EDIT: ok, I've checked the updates list in SCCM and I couldn't find the Enterprise 1709 nl-nl update so I guess that it isn't synced by WSUS EDIT2: Found the upgrade in WSUS, still not clear why it's not showing up in SCCM: EDIT3: Although (almost) all installations are using Enterprise edition, WSUS isn't showing a 1709 Enterprise upgrade package? EDIT4: Possible cause found EDIT5: Ok, it seems that the upgrades are working now. It turned out that the hardware inventory wasn't always up to date on about 30% of our clients. I increased the MIF size limit to 15MB and the upgrades are being installed right now. For more info see: https://www.enhansoft.com/blog/change-the-maximum-file-size-of-management-information-files-mif-in-sccm-2012

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!

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!

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!