script to auto populate fields!

[SNnewbie2]

I have a reference field called servers. This table contains information ip address and description. I want to be able to autopopulate ip address and decription.

For example, in the hostname field I will select a server name, and after I select the server name it will autopopulate the IP Address and Description.

How do I do that?   Thank you.

Table name : cmdb_ci_server

[SNnewbie2]

Thank you so much. Like I said I am new in SN, and I'm trying to learn as much as possible. I created a client script and a include script but they are not working. It doesn't auto-populate the IP address and the reference field.

Client Script :

function onChange(control, oldValue, newValue, isLoading) {
                               if (isLoading || newValue == '') {
                                                               return;
                               }

                               var user = g_form.getValue('requested_for');

                               var ga = new GlideAjax('PenTestCatalogTaskAjax ');
                               ga.addParam('sysparm_name','getServerInfo');
                               ga.addParam('sysparm_server_id', serverID);
                               ga.getXML(getServerParse);

                               function getServerParse(response) {
                                                               var answer = response.responseXML.documentElement.getAttribute("answer");

                                                               //Split Answer string to array on the commas
                                                               var returnedArray = answer.split(',');
                                                               //IP Address
                                                               var IP = returnedArray[0];
                                                               //Description
                                                               var DES = returnedArray[1];

                                                               //Set Display Values
                                                               g_form.setValue('ip_address_var', IP);
                                                               g_form.setValue('description_var', DES);

                               }                           
}

Script Include :

var PenTestCatalogTaskAjax = Class.create();   
PenTestCatalogTaskAjax.prototype = Object.extendsObject(AbstractAjaxProcessor, {   
       getServerInfo : function() {   

   var serverID = this.getParameter('sysparm_server_id'); //get server ID   
   var gr = new GlideRecord('cmdb_ci_server'); //Go to the server table   
   gr.addQuery('sys_id', serverID);   // 'what you are querying' , ' what the value is'
   gr.query();   
   gr.next(); 

   var description = gr.short_description; //get short description   

   var arrayIP = []; //array that will contain all IP addresses
   var ipAddress = new GlideRecord ('cmdb_ci_network_adapter'); //go to network table   
   ipAddress.addQuery('cmdb_ci', serverID); // 'what you are querying' , ' what the value is'
   ipAddress.query(); 
   while (ipAddress.next()){
     arrayIP.push(ipAddress.ip_adrress.toString()); //push ip addess to my array
   } 
   return description + ','+ arrayIP; 
},   
       type: 'PenTestCatalogTaskAjax'   
});   

[SNnewbie2]

Quick Question! I went to mt cmdb_ci_server table and there is a field called name Name. Why are you passing sys_id and server Id? The problem that I am having is that I do not know what to pass. How do you know is sys_id and serverId?

var serverId = this.getParameter('sysparm_server_id');   
   var gr = new GlideRecord('cmdb_ci_server');   
   gr.addQuery('sys_id', serverId);   
   gr.query();   

[Ivano B]

Hi Claudia

The variable named serverId is populated with the value from the client script.

Check line 10 of your last client script. You are doing exactly the same.

There is only one thing missing. Your variable named hostname_var must be used as well.

The client script is created on change against that variable right ?

On the other hand you need the value stored in that field to execute the script include.

This means that line 10 of your client script must changed as

ga.addParam('sysparm_server_id', g_form.getValue('hostname_var'));

OR

var user = g_form.getValue('requested_for');  

var serverID = g_form.getValue('hostname_var');

var ga = new GlideAjax('PenTestCatalogTaskAjax ');  

ga.addParam('sysparm_name','getServerInfo');  

ga.addParam('sysparm_server_id', serverID);  

ga.getXML(getServerParse);

In theory this should be enough to fix your code.

About your question. How do you know is sys_id and serverId?

Here's the explanation. Locally on the service catalog form each time you populate the field named hostname_var you are referencing a specific server.

Using g_form.getValue('hostname_var') will provide you the unique identifier related with the server record.

When using a reference field in a client script you can't obtain directly any other information of the referenced record other than the SYS_ID.

For this reason we are using this value on the script include to query the server table and have access to all the necessary attributes (e.g. description, name etc)

I hope this help/answer your question and if it does please mark it

Cheers

R0b0