create record from client script in workflow

[daniellethomson]

Scripting isn't my strong suit and I'm sure it's an easy fix but I can't get it. I need to crate a record on the cmdb_ci_server table from within a workflow. I can get the record to create but it's not inputting the values from the variables. Instead it is just inputting what is between the ' ' or for the value of sys_class_name is is just inputting 'server' instead of ESX Server.

Any help would be great! Thanks!

var server = new GlideRecord("cmdb_ci_server");

server.initialize();

server.setValue('ip_address','current.variables.ip_address');

server.setValue('name', 'current.variables.server_name');

server.setValue('sys_class_name', 'current.variables.class');

server.insert();

[daniellethomson]

The field sys_class_name is an oob field that references the cmdb classes. What I'm needing to accomplish with this field is for the record to create in the correct CI class (i.e. ESX Server, Windows Server, Linux Server).

For testing my code is simply:

var server = new GlideRecord("cmdb_ci_server");

server.initialize();

server.setValue('ip_address',current.variables.ip_address);

server.setValue('name', current.variables.server_name);

server.setValue('sys_class_name', current.variables.class);

server.insert();

screenshot of error in workflow:

[daniellethomson]

Should the code include logic instead that says if variable class is ESX Server then create record in cmdb_ci_esx_server instead?? That is a little advanced for me.

[amlanpal]

Hi Danielle,

Yes, you can incorporate this logic also. I've modified your code a bit incorporating the above. Could you please give it a try?

if(current.variables.class == 'ESX Server') { //This will check whether the provided Class is 'ESX Server' or not

var server = new GlideRecord("cmdb_ci_esx_server");

server.initialize();

server.ip_address = current.variables.ip_address;

server.name = current.variables.server_name;

server.sys_class_name = current.variables.class;

server.insert();

}

I hope this helps. Please mark correct/helpful based on impact

[daniellethomson]

unfortunately that did not work. I now receive the following error:

SyntaxError: missing name after . operator (#0(eval); line 1)

[amlanpal]

Hi Danielle,

My bad, in order noticing the issue earlier. The error is coming because of the 'class', which is a reserved word. You can find the list of reserved words here: JavaScript Reserved Words . To my best knowledge, as part of solution, you need to change the variable name to something else which is not reserved word. Once you are done with this, please modify the script accordingly and try again.

For reference you can refer this helpful thread: missing name after . operator

I hope this helps. Please mark correct/helpful based on impact