Caller Field Auto-Population Issue

[Community Alums]

Hi, 

Here is a form that users need to fill out. Once the caller field is populated, the machine name and IP address fields should auto-populate, but its not happening. I'm not sure why. Any assistance would be appreciated.

script include: 

    getIPandMachineName: function() {

        var note = "";

        //var machinename = '';

        var req = this.getParameter("sysparm_user");

        var ast = new GlideRecord("cmdb_ci_hardware");

        ast.addQuery("sys_class_name", "6f2bacd8dbd19450655c5bd05b9619f9");

        ast.addQuery("assigned_to", req);

        ast.addQuery("install_status", "1");

        //ast.addQuery("sys_id", srn);

        ast.query();

        if (!ast.hasNext()) {

            gs.addInfoMessage("No Asset assigned to user");

        } else {

            while (ast.next()) {

                var ipandmachinename = {

                    "machine_name": ast.name.getValue(),

                    "ip_address": ast.ip_address.getValue()

                };

            }

            return JSON.stringify(ipandmachinename);

        }

    },

client script: 

Type:OnChange

Variable name: caller

function onChange(control, oldValue, newValue, isLoading) {

    if (isLoading || newValue == '') {

        return;

    }

    var caller = g_form.getValue('caller_id');

  var ga = new GlideAjax("machineDetails");

    ga.addParam("sysparm_name", "getIPandMachineName");

    ga.addParam("sysparm_user",newValue);

    ga.getXML(setalert);

function setalert(response){

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

    alert(answer);

    g_form.setValue('machine_name', answer);

    g_form.setValue('ip_address', answer);

    }

}

[Harish KM]

Hi @Community Alums the below line is wrong in your script include

ast.addQuery("sys_class_name", "sysid");// here your looking for class name of CI, but you have put "sysid"

[Community Alums]

Updated , added the actual class sysid which is  "computer". 

[Harish KM]

Hi @Community Alums here is the updated code

getIPandMachineName: function() {
var assetDetails = {};
var req = this.getParameter("sysparm_user");
var ast = new GlideRecord("cmdb_ci_hardware");
// ast.addQuery("sys_class_name", "sysid"); // invalid query
ast.addQuery("assigned_to", req);
ast.addQuery("install_status", 1);
ast.query();
if (!ast.hasNext()) {
return "No Record Found";
} else {
while (ast.next()) {

assetDetails.machine_name= ast.getValue('name');
assetDetails.ip_address = ast.getValue('ip_address');

}
var answer = JSON.stringify(assetDetails);
return answer;
}
},

client script:

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
var caller = g_form.getValue('caller_id');

var ga = new GlideAjax("machineDetails");
ga.addParam("sysparm_name", "getIPandMachineName");
ga.addParam("sysparm_user",newValue);
ga.getXMLAnswer(setalert);

function setalert(answer){

alert(JSON.stringify(answer,null,4));
g_form.setValue('machine_name', answer.machine_name);
g_form.setValue('ip_address', answer.ip_address);
}
}

[Community Alums]

still doesn't populate the machine name and ip address field. 

Regards 

C