SCCM

Patching Collections

by

All computers that are in a state of pending restart: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from sms_r_system AS sms_r_system inner join SMS_UpdateComplianceStatus as c on c.machineid=sms_r_system.resourceid where c.LastEnforcementMessageID = 9 All computers that failed to install an update: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from sms_r_system inner join SMS_UpdateComplianceStatus on SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid where … Read more

SCCM Advertisement Status Failed systems Collection

by

To create a collection based on failed advertisement systems.   SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceIDWHERE AdvertisementID = ‘CEN12345′ and LastStateName = “Failed”

Who is installed Software's ?

by

Collection for computers that failed to run an advertisement  https://blog.coretech.dk/confmgr07/collection-for-computers-that-failed-to-run-an-advertisement/   Who is installed Software’s ? https://blog.coretech.dk/confmgr07/config-mgr-inventory-and-reporting/audit-software-installations/ Troubleshooting SCCM Software Updates   https://www.myitforum.com/myITToolbar/frame-click.asp? https://blogs.technet.com/b/sudheesn/archive/2010/11/10/troubleshooting-sccm-part-iii-software-updates.aspx   VB Script to Clear SCCM Client Cache (C:WindowsSystem32CCMCache) ——- on error resume next dim oUIResManagerdim oCachedim oCacheElementdim oCacheElements set oUIResManager = createobject(“UIResource.UIResourceMgr”) if oUIResManager is nothing then      wscript.echo “Couldn’t create … Read more

Hydration – Microsoft Free Test Lab for POC (Proof of Concepts)

by

Source:- https://blog.coretech.dk/mip/set-up-a-sccm-test-environment-in-no-time/ Source:- https://www.deploymentresearch.com/Blog/tabid/62/EntryId/13/Hydration-Automating-builds-in-your-datacenter.aspx   You can download it from Microsoft Connect here https://connect.microsoft.com/pocjumpstart, just scroll down to the bottom and look for PoC – Jumpstart 10 Day – Hydration Kit. And be aware that license terms of the different software is still in effect..   Here is a download for deploying a few different … Read more

A consolidated Report for Patch Deployments

by

to get the consolidated Report for all your deployments / instead of depending on dashboard you can view this PVT Report   Source:- https://blog.coretech.dk/kea/status-report-for-software-update-deployments/ Select Deploymentname, Available, Deadline, cast(cast(((cast([Compliant] as float) / (ISNULL([Compliant], 0) + ISNULL([Enforcement state unknown], 0) + ISNULL([Successfully installed update(s)], 0) + ISNULL([Failed to install update(s)], 0) + ISNULL([Installing update(s)], 0) + … Read more

Software Updates Status messages

by

Software Updates Status messages are three major types and these are   States for deployments States for software updates Scan states for an update source     and each of these are again sub categorized as below.. we can see these message when we ran the software updates reports in SCCM.   States for Deployments … Read more

POC New released from MS

by

    https://www.microsoft.com/downloads/en/details.aspx?FamilyID=26301cd1-cc72-4dd8-819e-12ef48322743 The PoC Jumpstart provides resources to deploy a desktop PoC with Windows 7, Office 2010, Internet Explorer 8, and Application Virtualization with Microsoft Desktop Optimization Pack technology.   Overview This self-contained, self-service kit will help you complete a Proof-of -Concept (PoC) at your organization, allowing you to quickly evaluate the new Microsoft … Read more