SQL Query to find the detailed Enforcement Status of a Software Update Deployment for Patching.

-

Please find the query below.

select
vrs.name0,
a.Assignment_UniqueID as DeploymentID,
a.AssignmentName as DeploymentName,
sn.StateName as LastEnforcementState,
assc.StateTime ,
a.CollectionName,
assc.Lasterrorcode
from v_CIAssignment a
join v_AssignmentState_Combined assc on a.AssignmentID=assc.AssignmentID
join v_StateNames sn on assc.StateType = sn.TopicType and sn.StateID=isnull(assc.StateID,0)
join v_R_System vrs on vrs.ResourceID=assc.ResourceID
where a.AssignmentID="Put the Assignment ID of the deployment"

Comments

Post a Comment

Popular posts from this blog

Windows Update prompts for installing an update that has already been installed on the user machine.

-
Causes:-- Normally windows update center will download available updates and have them installed and maintain a record for the same so that the same update is not repeated again, however if there is some issue with the Windows Update Center itself, it would either fail to download the updates or would fail to maintain a record of the installed updates. Generally on a user’s computer, the Windows Update center is being disabled. Due to lack of permissions to download files from the internet, it’s the SCCM Windows Update service that executes and installs these updates on the machines and if for any reason a user’s computer is having any issue with corrupted files or any other, these updates status may not be reaching to SCCM Compliance and as a result shows up as a required update in the machine. Even if the update is installed, the SCCM Compliance wouldn’t have a record for its installation which is why it would constantly popup and repeat the same update as a required upd...
Read more

Uninstall/Remove/Decommission Secondary Site in SCCM 2012.

-
Image
This is the post where we can find some useful details about removal or uninstallation or deletion of Site server (s) rather Decommission of sites and Hierarchies. Also, we’re going to discuss about the difference between the options  Uninstall  and  Delete  (Secondary site/s). We will be able to   REUSE the site code of secondary server/s   if is  no longer in use in your Configuration Manager hierarchy or in the Active Directory forest . However, Site codes cannot be used more than one time in a   ConfigMgr   hierarchy for a CAS or primary sites. If you reuse a site code, you run the risk of having   object ID conflicts   in your ConfigMgr hierarchy. When we want to remove entire SCCM/ConfigMgr hierarchy with lot of site servers (primary and secondary etc..), we’ve to follow   bottom up   approach. That means, Remove secondary sites attached to primary sites, primary sites from the central administration sit...
Read more

Configmgr OnSearchComplete – Failed to end search job Error 0x80244022 WUAHandler.log

-
WSUS POOL in IIS getting stopped frequently, causing scan  failures from client end     So why does the WSUS App pool crash and how to fix it? The WSUS App pool “private memory limit” setting is by default configured to 1.7 GB, the pool crashed because it couldn’t keep up. In order to fix that, people increase the memory on the Software Update Point and also configure the WSUS App pool memory limit with 8-12 GB. After that App pool should be started and let the clients flood the network for a couple of hours and everything was back to normal. So why couldn’t the WSUS App pool keep up? This is due to the larger number of updates in the catalog which continues to grow over time.  After the Patch Tuesday sync from Microsoft, clients started scanning successfully at first, but the Update catalog reached a size that increased the load on the Software Update Point. Due to the default memory limit of the app pool the server ran out of memory caus...
Read more