—Single system required Patch’s report from SQL SELECT DISTINCT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], CASE WHEN UCS.Status = ‘2’ THEN ‘Applicable’ WHEN UCS.Status = ‘3’ THEN ‘Installed’ ELSE ” END AS ‘Patch Status’, UI.BulletinID, UI.ArticleID, UI.Title FROM v_R_System AS SYS LEFT OUTER JOIN v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID … Read more
run the below script to get the actual system state. this will help to report back actual compliance of patch level to SCCM Server Option ExplicitOn Error Resume Next Call RefreshServerComplianceState ‘ WScript.Echo “Finished” Sub RefreshServerComplianceState() ‘ Initialize the UpdatesStore variable. dim newCCMUpdatesStore ‘ Create the COM object. set newCCMUpdatesStore = CreateObject … Read more
Issue The issue that was reported to me was that the content was not downloading. My datatransferservice.log, my CAS.log, and ContentTransferManager.log all looked good. The client found a local DP to download the content from. However when I looked at my cache folder, I saw that only a couple of MB of data was downloaded … Read more
SMSUtils has a great tool to audit and report on your BITS 2.0 settings for your SMS 2003 Advanced Clients. You can download the tool from here: https://www.smsutils.com/CommunityDownloads/tabid/58/Default.aspx Here is some background information that I wrote up about the tool a few months ago: BITS (binary intelligent transfer service) is the technology that SMS uses … Read more
1) Update distribution points increments the package version, goes to the source location, constructs new package content but only sends the delta between what is already present on the DP and what is currently in the new package source. Also this action is package specific and once you trigger this action all the DPs … Read more
Configuring SCCM and Branch Cache Branch cache is a feature introduced with Windows 2008 R2 that allows systems within the same subnet and separated from a content source (such as a WSUS server) to share downloaded content locally rather than each system having to traverse a latent network link back to the content source. Branch … Read more
How to read the advertisement reports:- Accepted – Software can be installed in few mins, as it will start downloading the software from remote /local system No Status – Systems are not online or has issue with SMS Agent, or not received the policy, if the system is online then this status must change in … Read more
SSMS Tools Pack is an add-in for Microsoft SQL Server Management Studio (SSMS) 2005, 2008, 2008 R2, 2011 (Denali) CTP1 and their respective Express versions.It contains a few upgrades to the SSMS IDE that I thought were missing. To see what’s new and what got fixed in a release check the News page. The current … Read more
Check with these commands BITSADMIN /LIST /ALLUSERS C:>BITSADMIN /geterror {7D46DE5B-3911-40B1-A72B-607737DB06F9} BITSADMIN version 2.0 [ 6.6.3790.3959 ]BITS administration utility.(C) Copyright 2000-2004 Microsoft Corp. ERROR FILE: https://sccmserver.mydomain:80/SMS_DP_SMSPKGD$/SMSPKG/HCC0005F/AdminImage/x86/en-us/acad/Acad/Program Files/Root/HelpHtml/contexthelp/+CONSTRAINTSETTINGS.htm -> C:WINDOWSsystem32CCMCacheHCC0005F.1.SystemAdminImage/x86/en-us/acad/Acad/Program Files/Root/HelpHtml/contexthelp/+CONSTRAINTSETTINGS.htmERROR CODE: 0x80190194 – The requested URL is not found on this server.ERROR CONTEXT: 0x00000005 – When processing the remote file error has occurred … Read more