WSUS 2008 [résolu]

[MeowMeow]

Bonjour,

J'ai un serveur 2008 Datacenter R2. Sur ce serveur, j'ai un wsus. Ce WSUS reconnait les ordinateurs w10 en Vista.

En faisant des recherches, je dois installer un patchs et ré-indexer la base WSUS.  https://gallery.technet.microsoft.com/ScriptCenter/6f8cde49-5c52-4abd-9820-f1d270ddea61/

Pour cela, on lance un script avec sqlcmd. Mais cela ne marche pas....
 

[CryoGen]

Ton WSUS utilise la base interne Windows (WID) ou une instance SQL Server ?

[MeowMeow]

WID

 

Et maintenant, j'ai cela :

[CryoGen]

Ok, mais de ce que je vois tu n'as pas le bon script

Essai ca plutôt (je ne prend aucune responsabilité )

USE [SUSDB]
GO

SET NOCOUNT ON;
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Enterprise'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND NewProductType = 4 
-- 4 = Enterprise
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Pro'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND NewProductType = 48
-- 48 = Pro
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Enterprise 2016 LTSB'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND  NewProductType = 125
-- 125 = Windows 10 Enterprise 2016 LTSB
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2016 Datacenter'
WHERE OSMajorVersion = 10 AND OldProductType = 3 AND NewProductType = 8
-- 8 = Windows Server 2016 Datacenter
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2016 Standard'
WHERE OSMajorVersion = 10 AND OldProductType = 3 AND NewProductType = 7
-- 7 = Windows Server 2016 Standard
GO

source: https://social.technet.microsoft.com/Forums/en-US/a05a872f-9a36-484a-9dfb-59d7320623a7/windows-10-pcs-are-shown-in-wsus-as-windows-vista?forum=winserverwsus

 

[MeowMeow]

Résolu :

J'ai tapé ceci :

sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -i (chemin)\WsusDBMaintenance.sql

 

[MeowMeow]

Il y a 16 minutes, CryoGen a écrit :

Ok, mais de ce que je vois tu n'as pas le bon script

Essai ca plutôt (je ne prend aucune responsabilité )

USE [SUSDB]
GO

SET NOCOUNT ON;
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Enterprise'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND NewProductType = 4 
-- 4 = Enterprise
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Pro'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND NewProductType = 48
-- 48 = Pro
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10 Enterprise 2016 LTSB'
WHERE OSMajorVersion = 10 AND OldProductType = 1 AND  NewProductType = 125
-- 125 = Windows 10 Enterprise 2016 LTSB
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2016 Datacenter'
WHERE OSMajorVersion = 10 AND OldProductType = 3 AND NewProductType = 8
-- 8 = Windows Server 2016 Datacenter
UPDATE [dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2016 Standard'
WHERE OSMajorVersion = 10 AND OldProductType = 3 AND NewProductType = 7
-- 7 = Windows Server 2016 Standard
GO

source: https://social.technet.microsoft.com/Forums/en-US/a05a872f-9a36-484a-9dfb-59d7320623a7/windows-10-pcs-are-shown-in-wsus-as-windows-vista?forum=winserverwsus

 

Beaugoss! Fonctionne!