#SolutionArchitect#SCCM Expert#Citrix Expert #Private Cloud Consultant#SQL Expert#Corporate Trainer #Automation Consultant

Software update Synchronization fails ConfigMgr

(0)
April 13, 2018 • Powershell, SCCM

Hi Guys , This is a quick one .Yesterday I faced an issue where the Software update sync started failing with the following error message: SyncBatchMinCreationDate not set, using default 01/01/2001 00:00:00   SMS_WSUS_SYNC_MANAGER  12/04/2018 1:20:48 PM         4892 (0x131C)Sync failed: The operation has timed out. Source: Microsoft.UpdateServices.Internal.DatabaseAccess.ApiRemotingCompressionProxy.GetWebResponse                SMS_WSUS_SYNC_MANAGER    12/04/2018 1:23:49 PM 7676 (0x1DFC)STATMSG: ID=6703 SEV=E LEV=M… Read More ›

SCCM »

Software update Synchronization fails ConfigMgr

(0)

Hi Guys , This is a quick one .Yesterday I faced an issue where the Software update sync started failing with the following error message: SyncBatchMinCreationDate not set, using default 01/01/2001 00:00:00   SMS_WSUS_SYNC_MANAGER  12/04/2018 1:20:48 PM         4892 (0x131C)Sync failed: The operation has timed out. Source: Microsoft.UpdateServices.Internal.DatabaseAccess.ApiRemotingCompressionProxy.GetWebResponse                SMS_WSUS_SYNC_MANAGER    12/04/2018 1:23:49 PM 7676 (0x1DFC)STATMSG: ID=6703 SEV=E LEV=M… Read More ›

Orchestrator »

Installing Orchestrator 2016 on Server 2016

(0)

Hi Everyone, This blog is about is installing System Center Orchestrator 2016 on Server 2016. I know it’s very exciting .Please follow along for step by step guide: Also please find the difference between different Automation tools from Microsoft . I know there s lot of confusion when thinking which product has what function …. Read More ›

Cloud »

Using Update Statement in SQL when using joins

(0)

Hi everyone, Let’s discuss the SQL update statement when using joins in SQL. Many of us try to make this complicated when we try to use update statement when dealing with two tables using joins. Please follow along for this short SQL lesson on UPDATE USING JOINS. For example: Suppose we have 2 tables that… Read More ›

Reporting »

SQL query for SCCM to pull out Hostname, Ip Address , OU location and Operating system

(0)

Hi everyone , A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . Select s.Netbios_Name0,ip.IP_Addresses0, s.Distinguished_Name0,s.operatingSystem0, s.Operating_System_Name_and0 from v_RA_System_IPAddresses AS IP inner join v_R_System AS S on ip.ResourceID=s.ResourceID where operatingSystem0 like ‘%Server%’; My requirement was for servers , but if… Read More ›

SQL »

System Center Orchestrator runbook for removing SCCM records

(0)

Hi Everyone , Hope you are doing great! Today i am writing about an scenario  which talks about automating SCCM record removal through Orchestrator . The runbook once  created will look like the following : You can use the following Powershell script to remove the record from the database : $error.clear() powershell{ cd “D:\Program Files\Microsoft… Read More ›

Software Updates »

Installing Java through SCUP leaves system non-complaint after Move-AV client blocks install

(0)

Hi Everyone , For those of you who are using SCUP to update java need to be careful  for one very important scenario which might leave your client ( Servers in my case ) without any version of Java . We faced an issue last week when we had a patching window and since we… Read More ›

Translate