We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

how to fetch Sys ID of name field

Deepa12
Tera Contributor

Hi,

please assist me to get sys_id of name field instead of string.

var configurationitem;

var gr1 = new GlideRecord('cmdb_ci_win_server');
gr1.addEncodedQuery('fqdn=' + hostname);
gr1.query();
if (gr1.next()) {
configurationitem = gr1.name;

}

2 ACCEPTED SOLUTIONS

Sandeep Rajput
Tera Patron

@Deepa12 Please update your script as follows.

 

 

var configurationitem;
var gr1 = new GlideRecord('cmdb_ci_win_server');
gr1.addEncodedQuery('fqdn=' + hostname);
gr1.query();
if (gr1.next()) {
configurationitem = gr1.getValue('sys_id');
}

 

Hope this helps.

View solution in original post

shubhamdubey
Mega Sage

@Deepa12 

 

Tried this code as well 

 

var configurationitem;

var gr1 = new GlideRecord('cmdb_ci_win_server');
gr1.addEncodedQuery('host_name=P1SAP');
gr1.query();
if (gr1.next()) {
configurationitem = gr1.sys_id;


}
gs.print(configurationitem);

 

it will give you sys_id.sys_id_record.PNG

View solution in original post

2 REPLIES 2

Sandeep Rajput
Tera Patron

@Deepa12 Please update your script as follows.

 

 

var configurationitem;
var gr1 = new GlideRecord('cmdb_ci_win_server');
gr1.addEncodedQuery('fqdn=' + hostname);
gr1.query();
if (gr1.next()) {
configurationitem = gr1.getValue('sys_id');
}

 

Hope this helps.

shubhamdubey
Mega Sage

@Deepa12 

 

Tried this code as well 

 

var configurationitem;

var gr1 = new GlideRecord('cmdb_ci_win_server');
gr1.addEncodedQuery('host_name=P1SAP');
gr1.query();
if (gr1.next()) {
configurationitem = gr1.sys_id;


}
gs.print(configurationitem);

 

it will give you sys_id.sys_id_record.PNG