Hello @akash_mehta
This is w.r.t the script you provided in one of the community posts on SCCM Lenovo manufacturer data population issue in the computer table.
For the SQL statement you can add the following:
v_GS_COMPUTER_SYSTEM_PRODUCT.Version0 as Version - I updated the SQL statement
That will get you the friendly name for Lenovo models.
For the Transform Map - there is a pre-script that handles mapping the model value, you can change it to look like this: - In which RTE Entity operation or transformation this script has to be updated. Please help on the same.
function setMakeAndModel() {
//updated for lenovo changes
var realModel = '';
if(source.u_manufacturer == 'LENOVO'){
realModel = source.u_version;
}else{
realModel = source.u_model;
}
var mm = MakeAndModelJS.fromNames(source.u_manufacturer, realModel, "hardware");
target.model_id = mm.getModelNameSysID();
target.manufacturer = mm.getManufacturerSysID();
}
Thanks,
