RMS200203: Known Issue RMS-1951 Operating System is not correctly identified

Product

RayManageSoft

Version/-s

10.4, 10.5

Issue

Operating System is not correctly identified

Jira-Task

RMS-1951

Description

The operating system is not identified for devices gathered by discovery or inventory. In devices snapin and reporting the operating system is not correctly displayed for some devices.
This problem appears when the OperatingSystem table does not have the operating system name. For example when you have a French version such as “Microsoft Windows 7 Professionnel” or when the name identified is incomplete such as “Windows 7 Home”. Such variants are not covered by default and need to be manually added to the OperatingSystem table.

Workaround

Yes

Instructions

Using the following query you can identify the operating system names that have been identified but yet are not taken into the OperatingSystem table:

 

SELECT DISTINCT Name FROM ComputerOperatingSystem

WHERE Name NOT IN

(

                SELECT OperatingSystemName FROM OperatingSystem

)

 

Identify for each of the found operating system its proper parent id by using following sql query:

 

SELECT *

FROM [OperatingSystem]

 

Next update the OperatingSystem table. Here is an example where 'Microsoft Windows 7 Professionnel' is added with the parent id 1062:

 

INSERT INTO [OperatingSystem]([OperatingSystemName],[Category]) VALUES ('Microsoft Windows 7 Professionnel', 1062)

 

Last step is to update the existing devices with the newly added operating system. This can be done by simply executing the following SQL commands:

 

UPDATE Computer SET Computer.OperatingSystemID = OperatingSystem.OperatingSystemID

FROM ComputerOperatingSystem

INNER JOIN OperatingSystem ON ComputerOperatingSystem.Name = OperatingSystem.OperatingSystemName

WHERE Computer.ComputerID = ComputerOperatingSystem.ComputerID

GO

 

UPDATE NetworkDevice

SET NetworkDevice.OperatingSystemID = OperatingSystem.OperatingSystemID

    ,NetworkDevice.OperatingSystem =  OperatingSystem.OperatingSystemName

FROM ComputerOperatingSystem

INNER JOIN OperatingSystem ON ComputerOperatingSystem.Name = OperatingSystem.OperatingSystemName

WHERE NetworkDevice.ComputerID = ComputerOperatingSystem.ComputerID

 

GO

 

Resolved in Version

 

-

 

Have more questions? Submit a request

Comments

Powered by Zendesk