The MS Designation table displays <NULL> after specifying IP Address instead of the host name (NETIQKB41117)

The MS Designation table displays after specifying IP Address instead of the host name in the AMADMIN_SetPrimaryMS Knowledge Script.

To resolve this issue:

• Ensure name resolution is working correctly in the environment and the domain name resolves correctly to the IP address from the client machines.

1. Use a host file on the client machines to resolve domain names to IP addresses.
2. Browse to the directory:
   
             c:\windows\system32\drivers\etc 

   then open the Hosts file.

3. In the Hosts file, enter a new line for the IP address, press the Tab key, and then enter the name of the Management Server.

• Next, manually set the MS Designation using SQL Query Analyzer.

1. Find the OBJ id of the primary management server.
2. Click on the Management Server and press ALT+F8.
3. Write down the number listed under objid = <machine number>.
4. Open the SQL Query Analyzer.
5. Execute the following query:
   
   

   SELECT * FROM MSDesignation WHERE PrimaryMSID is NULL

6. This will bring up a list of systems whose primary MS has not been set. The machine number is contained in the field MachineObjID.
7. Execute the following query:

Update msdesignation set PrimaryMSID = <management server ID number> where machineObjID = < machine number>

The MS Designation holding the field names PrimaryMSID and SecondaryMSID only changes if SetPrimaryMS KS holds a name that corresponds to an object in the MSStatus table which in turn corresponds to an object in the MSDesignation table with the same name.  If using the IP address, it does not match any valid Objects listed in the MSDesignation table.  Therefore it does not change the Primary MS designation in the MSDesignation table.

Formerly known as NETIQKB41117