[FIXED] Bugreport : OS Overview Bar

[Gene_Galaxo]

on the Dashboard in the OS Bar I have 2 Entries "Not Scanned".
Windows 2008 R2 is found as Win 7
and I have a entry "Other". In the Other-list I have Win 2003 R2 and Win 7 entries.

[Hemoco]

Problem fixed in the current build

[AdmJLovejoy]

Fixed after running the updated sql for view web40OScode.

[AdmJLovejoy]

No change. I'm seeing the "ProductType" as "1" on Windows 7. Server 2008 R2 is coming up as "ProductType" "3".

[Hemoco]

AdmJLovejoy wrote:
No change. I'm seeing the "ProductType" as "1" on Windows 7. Server 2008 R2 is coming up as "ProductType" "3".

Did you use the updated sql for view web40OScode?

[Hemoco]

Got it:

Run the following sql script:

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

[AdmJLovejoy]

Here's the output...

[Hemoco]

The updated sql should be:

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

Could you take a look in table "tbloperatingsystem" for the OS that is displayed wrong.
I need fields "OtherTypeDescription","Producttype","Version"

[AdmJLovejoy]

This got me back to where I was... Still shows Server 2008 R2 as Win7.

Alter view web40OScode
AS
SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.ServicePackMajorVersion AS SP, CASE WHEN isnull(dbo.tbloperatingsystem.version, '')
= '' THEN '0' ELSE dbo.tblOperatingsystem.Version + ISNULL(dbo.tblOperatingsystem.OtherTypeDescription, '')
+ CASE WHEN ((version = '5.0.2195' AND domainrole > 1) OR
(version = '6.0.6001' AND domainrole > 1) OR
(version = '6.0.6002' AND domainrole > 1) OR
(version = '5.2.3790' AND domainrole > 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

[AdmJLovejoy]

Downloaded and installed only the website, not seeing the "Overload resolution failed" issue anymore, but the "OS Count Bar" still is incorrect after running the SQL script.