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....
 

Edited April 5, 20187 yr by trOmAtism

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

WID

 

Et maintenant, j'ai cela :

Edited April 5, 20187 yr by trOmAtism

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

 

Edited April 5, 20187 yr by CryoGen
source

Résolu :

J'ai tapé ceci :

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

 

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!