Hello Everyone,
Need some help
I have an requirement to create a inbound email action to update and alm_hardware record for which ib have written the scipt and its working fine
ISSUE - Sometimes its working and soemtimes its not working , i tried to change the execution order also but still the same issue.
Below is the code and screenshot for the condition:
(function runAction( /*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*Optional EmailLogger*/ logger, /*EmailClassifier*/ classifier) {
var emailBody = email.body_text.toLowerCase();
// Regex pattern to capture multiple asset records
// Expected format:
// Asset serial number - 123, State - in stock, Centre number - 134
var pattern = /Asset serial number\s*-\s*(\S+).*?State\s*-\s*([\w\s]+).*?Centre number\s*-\s*(\d+)/gi;
var match;
while ((match = pattern.exec(emailBody)) !== null) {
var serialNumber = match[1].trim();
var stateText = match[2].trim();
var centreNumber = match[3].trim();
var installStatus = '';
var subStatus = null; // null means don't touch it
// Map state to install_status (+substatus only for in stock)
if (stateText.toLowerCase() == 'in stock') {
installStatus = '6'; // In Stock
subStatus = 'available';
} else if (stateText.toLowerCase() == 'retired') {
installStatus = '7'; // Retired
subStatus = ''; // Do not update substatus
}
// Lookup location sys_id
var locationSysId = '';
if (centreNumber) {
var locGR = new GlideRecord('cmn_location');
locGR.addQuery('u_centre_number', parseInt(centreNumber, 10));
locGR.query();
if (locGR.next()) {
locationSysId = locGR.sys_id.toString();
}
}
// Update asset record
if (serialNumber) {
var hwGR = new GlideRecord('alm_hardware');
hwGR.addQuery('serial_number', serialNumber);
hwGR.query();
if (hwGR.next()) {
if (installStatus) hwGR.install_status = installStatus;
if (subStatus !== null) hwGR.substatus = subStatus; // update only if defined
if (locationSysId) hwGR.location = locationSysId;
hwGR.update();
logger.info('Updated asset: ' + serialNumber + ' | State: ' + stateText + ' | Centre: ' + centreNumber);
} else {
logger.warn('No hardware found for serial number: ' + serialNumber);
}
}
}
})(current, event, email, logger, classifier);
Regards,
Suhail
