Normalization of Operating System

[jduchock1]

Hi !

I am trying to set up field normalization for operating systems found on servers (and later, workstations). We are using Discovery to create our server attributes using winrunner probes. As a result, the values being returned by the WMI commands vary wildly. When looking at Windows 2003 server operating systems, we get the following:

Windows 2003
Windows 2003 Enterprise
Windows 2003 Enterprise x64
Windows 2003 R2
Windows 2003 R2 Standard
Windows 2003 R2 Enterprise
Windows 2003 R2 Enterprise x64
Windows 2003 Standard
Windows 2003 Standard x64

These need to be rolled up into "Windows 2003 Enterprise" and "Windows 2003 Standard" for various purposes.

Now, note that the value for Operating System (according to the form) is stored on cmdb_ci_computer (see Server Config Item.jpg attached). however, when you attempt to build a normalized array for the field CMDB_CI_COMPUTER.OS, it does not exist in the list of fields available for that table (see Normalize.jpg attached).

So...how does one go about normalizing the operating system value found by discovery?

[#2]

Hi,

On a demo instance (Berlin P0 HF4 & Calgary) the field is available for selection.
I did some comparison and it seems the field type in your instance is 'choice' for the 'os' field.
In a demo instance it is 'string'. The moment I modified the field type in a demo to choice I could no longer choose the field in a normalization record.
So change the field type to 'string' in your instance and you should be fine.
Alternatively you could ask SNC support to assist in this matter.

Regards,

[jduchock1]

Thanks for the feedback. I am having our SN owner update our test instance as you suggested to see if it all works appropriately. I am not sure why OS is a 'choice' field in our environment as the attribute is populated by Discovery...

I will post the result here

Thanks again !

[miltkt011]

Hi Laurens,

i am faced with the same issue trying to do normalization on the OS System.   The difference is that my field type is showing 'string'.   Have you encountered this issue?