- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2019 04:08 AM
Hi,
I'm still fumbling in the dark with this. This is where I've got to so far...
- I created an Outbound REST Message called “AirWatch”, and a REST message name called “Get” (Test runs are successful)
- I created a new database called, “Mobile Device [u_mobile_device]”, that extends “Hardware [cmdb_ci_hardware]”. I added in a number of the field names that were returned in the test response in step one.
- I then created a staging table called, “Airwatch Import Table [u_airwatch_import_table]”, that extends “'sys_import_set_row” - This makes it accessible by the Transform Map. I added in the same fields from step 2.
- I then created a transform map called “AirWatch”. Selecting the newly created tables, I then paired the fields.
- I created a scheduled job called “AirWatch Import” that runs the following script.
----------------------------------------------
try {
var r = new sn_ws.RESTMessageV2('AirWatch', 'Get');
var response = r.execute();
if(response.getStatusCode() == '200'){
var jsonString = response.getBody();
var parser = new JSONParser();
var parsed = parser.parse(jsonString);
for(i = 0; i < parsed.Devices.length; i++){
var gr = new GlideRecord('u_airwatch_import_table');
gr.initialize();
//create models
var mm = MakeAndModelJS.fromNames(parsed.Devices[i].Platform, parsed.Devices[i].Model, "Mobile Device");
if(mm){
gr.u_model = mm.getModelNameSysID();
}
gr.u_Udid = parsed.Devices[i].Udid;
gr.u_SerialNumber = parsed.Devices[i].SerialNumber;
gr.u_MacAddress = parsed.Devices[i].MacAddress;
gr.u_Imei = parsed.Devices[i].Imei;
gr.u_EasId = parsed.Devices[i].EasId;
gr.u_AssetNumber = parsed.Devices[i].AssetNumber;
gr.u_DeviceFriendlyName = parsed.Devices[i].DeviceFriendlyName;
gr.insert();
}
}
else{
gs.logError("AirWatch import failed with a status code of " + response.getStatusCode());
}
}
catch(ex) {
var message = ex.getMessage();
}
----------------------------------------------
The results... Nothing. Struggling to even find any logs to indication what might be happening. Any ideas anyone?
Thanks,
Mark.