‎02-16-2010 08:41 AM
‎02-17-2010 06:25 AM
‎02-16-2010 07:32 PM
‎02-16-2010 07:20 PM
‎02-16-2010 07:22 PM
AdmJLovejoy wrote:
No change. I'm seeing the "ProductType" as "1" on Windows 7. Server 2008 R2 is coming up as "ProductType" "3".
‎02-16-2010 07:02 PM
delete from tsysos
GO
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('0','Not scanned','notscanned.png',99)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.0.2195','Win 2000','win200010.png',1)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.0.2195S','Win 2000 S','win200010.png',2)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.1.2600','Win XP','xp10.png',3)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.2.3790','Win XP','xp10.png',3)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.2.3790R2S','Win 2003 R2','win200310.png',5)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.2.3790S','Win 2003','win200310.png',4)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('5.2.4500S','Win Home','win200810.png',9)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6000','Win Vista','vista10.png',6)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6000S','Win 2008','win200810.png',10)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6001','Win Vista','vista10.png',7)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6001S','Win 2008','win200810.png',10)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6002','Win Vista','vista10.png',7)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6002S','Win 2008','win200810.png',10)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6003','Win Vista','vista10.png',8)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6003S','Win 2008','win200810.png',10)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6004','Win Vista','vista10.png',8)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.0.6004S','Win 2008','win200810.png',10)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7100','Win 7 RC','seven10.png',12)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7600','Win 7','seven10.png',13)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7600S','Win 2008 R2','win200810.png',11)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7601','Win 7','seven10.png',13)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7601S','Win 2008 R2','win200810.png',11)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7602','Win 7','seven10.png',13)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7602S','Win 2008 R2','win200810.png',11)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7603','Win 7','seven10.png',13)
INSERT INTO [tsysos] ([OScode],[OSname],[Image],[Sortorder])VALUES('6.1.7603S','Win 2008 R2','win200810.png',11)
GO
‎02-16-2010 06:45 PM
‎02-16-2010 06:34 PM
Alter view web40OScode
AS
SELECT dbo.tblComputers.Computername, ISNULL(dbo.tblOperatingsystem.ServicePackMajorVersion, '0') AS SP,
CASE WHEN isnull(dbo.tbloperatingsystem.version, '')
= '' THEN '0' ELSE dbo.tblOperatingsystem.Version + ISNULL(dbo.tblOperatingsystem.OtherTypeDescription, '') + CASE WHEN isnull(domainrole, 0)
> 1 THEN 'S' ELSE '' END END AS OScode
FROM dbo.tblComputersystem RIGHT OUTER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
‎02-16-2010 06:09 PM
‎02-16-2010 05:52 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now