Mark94
Kilo Expert

Hi,

I'm still fumbling in the dark with this. This is where I've got to so far...

 

  1. I created an Outbound REST Message called “AirWatch”, and a REST message name called “Get” (Test runs are successful)

  2. 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.

  3. 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.

  4. I then created a transform map called “AirWatch”. Selecting the newly created tables, I then paired the fields.

  5. 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.