findCBDetailsSerial.gs

function findCBOUs() {
  var serno = PropertiesService.getUserProperties().getProperty("serialNumberProp");
  var sernoquery = "id:" + serno;
  // Use AdminSDK API to check if the cros device exists. Else the extraction of OU will fail.
  try {
    var chromebooklist = AdminDirectory.Chromeosdevices.list('my_customer', { query: sernoquery }).chromeosdevices;
    if (!chromebooklist) { { var serno = "Wrong serial or outside your school/s" }; }
    else {
      var serial = chromebooklist[0].serialNumber;
      if (chromebooklist[0].orgUnitPath) { var ou = chromebooklist[0].orgUnitPath } else { var ou = "" };
      if (chromebooklist[0].status) { var status = chromebooklist[0].status } else { var status = "" };
      if (chromebooklist[0].lastSync) { var lastsync = new Date(chromebooklist[0].lastSync) } else { var lastsync = "" };
      var LastSyncProper = lastsync.toLocaleString("sv-SE", { year: 'numeric', month: 'numeric', day: 'numeric', hour: 'numeric', minute: 'numeric', second: 'numeric' });
      if (chromebooklist[0].osVersion) { var osversion = chromebooklist[0].osVersion } else { var osversion = "" };
      if (chromebooklist[0].annotatedAssetId) { var asset = chromebooklist[0].annotatedAssetId } else { var asset = "" };
      if (chromebooklist[0].model) { var CBsModel = chromebooklist[0].model } else { var CBsModel = "" };
      if (chromebooklist[0].lastKnownNetwork) { var CBIP3 = chromebooklist[0].lastKnownNetwork } else { var CBIP3 = "" };
      if (chromebooklist[0].macAddress) { var macAddress = chromebooklist[0].macAddress } else { var macAddress = "" };
      if (chromebooklist[0].autoUpdateExpiration) { var autoUpdateExpiration = chromebooklist[0].autoUpdateExpiration } else { var autoUpdateExpiration = "" };
      if (chromebooklist[0].manufactureDate) { var CBManufactureDate = chromebooklist[0].manufactureDate } else { var CBManufactureDate = "" };
      // Swedish SI date format of AUE, YYYY-MM-DD
      // var aue = new Date(parseInt(autoUpdateExpiration)).toLocaleString("sv-SE", {  year: 'numeric', month: 'numeric', day: 'numeric' }) + " (" + autoUpdateExpiration + ")";
      // Simple Swedish date format of AUE, showing only "month year"
      var aue = new Date(parseInt(autoUpdateExpiration)).toLocaleString("sv-SE", { year: 'numeric', month: 'short' }) + " (" + autoUpdateExpiration + ")";
      // If you want US format replace .toLocaleString("en-US", {  year: 'numeric', month: 'short' }) 

      // This one does a double check of recentUsers values, as one can be undefined while the other isn't, giving wrong result.
      if (chromebooklist[0].recentUsers && chromebooklist[0].recentUsers[0].email) {
        var recentUser = chromebooklist[0].recentUsers[0].email
        var recentUsers = chromebooklist[0].recentUsers
      } else {
        var recentUsers = ""
        var recentUser = ""
      };
    }

// Here I request the list of OUs and puts it into an sorted array

    var ouArray = [];
    var page = AdminDirectory.Orgunits.list('my_customer', {
        orgUnitPath: '/',
        type: 'all'
      });
      var orgUnits = page.organizationUnits;
      if (orgUnits) {
        for (var i = 0; i < orgUnits.length; i++) {
          var orgUnit = orgUnits[i];
          if (orgUnits[0].name) { var ouname = orgUnits[0].name } else { var ouname = "" };
          if (orgUnits[0].orgUnitPath) { var OUs = orgUnits[0].orgUnitPath } else { var OUs = "" };
          // Logger.log(orgUnit);
          // Logger.log(orgUnit.orgUnitPath);
          ouArray.push(orgUnit.orgUnitPath);
        }
        ouArray.sort();
      }
    // console.log(serno, serial, CBsModel, status, LastSyncProper, recentUser, ou, asset, osversion, CBManufactureDate, aue, macAddress, CBIP3, recentUsers,ouArray);

    return [serno, serial, CBsModel, status, LastSyncProper, recentUser, ou, asset, osversion, CBManufactureDate, aue, macAddress, CBIP3, recentUsers,ouArray];

    // If the check fails for some reason, log the error
  } catch (err) {
    return [serno, "", "", "", "", "", "", "", "", "", "", "", "", ""];
  }
}