Archive for Май 2018

MAC-адреса физических серверов из определённой коллекции

SELECT DISTINCT 
 TOP (100) PERCENT v_R_SYSTEM.Name0 AS 'Physical Servers', dbo.v_RA_System_MACAddresses.MAC_Addresses0 AS [MAC address], 
 V_GS_COMPUTER_SYSTEM.Model0 AS Model, V_GS_OPERATING_SYSTEM.Caption0 AS [Operating System]
FROM dbo.v_R_System INNER JOIN
 dbo.v_GS_COMPUTER_SYSTEM ON V_GS_COMPUTER_SYSTEM.ResourceID = v_R_SYSTEM.ResourceId INNER JOIN
 dbo.v_FullCollectionMembership ON dbo.v_R_System.ResourceID = dbo.v_FullCollectionMembership.ResourceID INNER JOIN
 dbo.v_GS_OPERATING_SYSTEM ON V_GS_OPERATING_SYSTEM.ResourceId = v_R_SYSTEM.ResourceId INNER JOIN
 dbo.v_RA_System_MACAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_MACAddresses.ResourceID
WHERE (V_GS_OPERATING_SYSTEM.Caption0 LIKE '%Server%') AND (v_R_System.Client0 = 1) AND (NOT (V_GS_COMPUTER_SYSTEM.Model0 LIKE '%Virtual%')) 
 AND (dbo.v_FullCollectionMembership.CollectionID = N'FRA00475')
ORDER BY 'Physical Servers'

ошибки синхронизации обновлений 0x80072ee2 и 0x80244022

WSUSCtrl.log:

System.Net.WebException: The request failed with HTTP status 503: Service Unavailable.~~ at Microsoft.UpdateServices.Administration.AdminProxy.CreateUpdateServer(Object[] args)~~ at Microsoft.UpdateServices.Administration.AdminProxy.GetUpdateServer()~~ at Microsoft.SystemsManagementServer.WSUS.WSUSServer.ConnectToWSUSServer(String ServerName, Boolean UseSSL, Int32 PortNumber)

Failed to set WSUS Local Configuration. Will retry configuration in 1 minutes

WCM.log:

System.Net.WebException: The request failed with HTTP status 503: Service Unavailable.~~ at Microsoft.UpdateServices.Administration.AdminProxy.CreateUpdateServer(Object[] args)~~ at Microsoft.SystemsManagementServer.WSUS.WSUSServer.ConnectToWSUSServer(String ServerName, Boolean UseSSL, Int32 PortNumber)

ScanAgent.log:

CScanJob::OnScanComplete -Scan Failed with Error=0x80072ee2

CScanJobManager::OnScanComplete- failed at CScanJob::OnScanComplete with error=0x80072ee2

ScanAgent.log:

CScanJob::OnScanComplete -Scan Failed with Error=0x80244022

CScanJobManager::OnScanComplete- failed at CScanJob::OnScanComplete with error=0x80244022

WindowsUpdate.log:

GetAuthorizationCookie failure, error = 0x80244022, soap client error = 10, soap error code = 0, HTTP status code = 503

Failed to initialize Simple Targeting Cookie: 0x80244022

PopulateAuthCookies failed: 0x80244022

RefreshCookie failed: 0x80244022

RefreshPTState failed: 0x80244022

Sync of Updates: 0x80244022

SyncServerUpdatesInternal failed: 0x80244022

Failed to synchronize, error = 0x80244022

Exit code = 0x80244022

WUAHandler.log:

OnSearchComplete — Failed to end search job. Error = 0x80244022.

Scan failed with error = 0x80244022.

Проверьте статус пула приложений и прокси. В моём случае WsusPool был остановлен, что совпало со сбоем корпоративного прокси-сервера: