ServiceNow Azure DevOps Integration Guide

// Transform Map script to sync Azure DevOps work item to Change Request
var changeGR = new GlideRecord('change_request');
changeGR.initialize();
changeGR.short_description = source.title || 'Azure DevOps Work Item: ' + source.id;
changeGR.description = source.description || '';
changeGR.state = source.state == 'Active' ? '2' : '1'; // Map states appropriately
changeGR.assignment_group = 'your_assignment_group_sys_id';
changeGR.u_azure_devops_id = source.id; // Custom field to store work item ID
var changeSysId = changeGR.insert();
target.change_request = changeSysId;

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
    var changeNumber = request.pathParams.change_number;
    var changeGR = new GlideRecord('change_request');
    changeGR.addQuery('number', changeNumber);
    changeGR.query();
    
    var result = {
        approved: false,
        message: 'Change request not found'
    };
    
    if (changeGR.next()) {
        var state = changeGR.getValue('state');
        result.approved = (state == '1' || state == '2'); // Approved states
        result.message = 'Change request ' + changeNumber + ' is in state: ' + changeGR.getDisplayValue('state');
        result.change_sys_id = changeGR.getUniqueValue();
    }
    
    response.setStatus(200);
    response.setHeader('Content-Type', 'application/json');
    response.getStreamWriter().writeString(JSON.stringify(result));
})(request, response);

// Flow Designer script step to process release data
var releaseData = fd_data.lookup('azure_devops_release');
var ciGR = new GlideRecord('cmdb_ci_appl');
ciGR.addQuery('u_release_id', releaseData.id); // Custom field for tracking
ciGR.query();

if (!ciGR.hasNext()) {
    ciGR.initialize();
    ciGR.name = releaseData.name;
    ciGR.u_release_id = releaseData.id;
    ciGR.short_description = 'Azure DevOps Release: ' + releaseData.name;
    ciGR.description = releaseData.description || '';
    ciGR.install_date = new GlideDateTime(releaseData.createdOn);
    ciGR.version = releaseData.releaseDefinition.revision;
    ciGR.operational_status = releaseData.status == 'succeeded' ? '1' : '6';
    ciGR.insert();
    fd_data.setValue('ci_created', true);
}

// Business Rule to parse commits and link to change requests
var commits = JSON.parse(response.body).value; // From Azure DevOps API response
for (var i = 0; i < commits.length; i++) {
    var commit = commits[i];
    var message = commit.comment || '';
    var changePattern = /CHG\d{7}/gi;
    var matches = message.match(changePattern);
    
    if (matches && matches.length > 0) {
        for (var j = 0; j < matches.length; j++) {
            var changeGR = new GlideRecord('change_request');
            changeGR.addQuery('number', matches[j]);
            changeGR.query();
            
            if (changeGR.next()) {
                var linkGR = new GlideRecord('u_devops_commits');
                linkGR.initialize();
                linkGR.u_change_request = changeGR.getUniqueValue();
                linkGR.u_commit_id = commit.commitId;
                linkGR.u_commit_message = commit.comment;
                linkGR.u_author = commit.author.name;
                linkGR.u_commit_date = new GlideDateTime(commit.author.date);
                linkGR.insert();
            }
        }
    }
}

// Flow script to update change request with build status
var buildData = fd_data.lookup('build_result');
var workItems = buildData.work_items || [];

for (var k = 0; k < workItems.length; k++) {
    var workItemId = workItems[k].id;
    var changeGR = new GlideRecord('change_request');
    changeGR.addQuery('u_azure_devops_id', workItemId);
    changeGR.query();
    
    if (changeGR.next()) {
        var statusMsg = 'Build ' + buildData.buildNumber + ' ';
        statusMsg += (buildData.status == 'succeeded') ? 'completed successfully' : 'failed';
        statusMsg += ' on ' + new GlideDateTime().getDisplayValue();
        
        changeGR.work_notes = statusMsg;
        if (buildData.status == 'failed' && changeGR.state == '2') {
            changeGR.state = '4'; // Set to Assess if build fails
        }
        changeGR.update();
    }
}

// Health check script for monitoring integration status
var healthCheck = {
    azure_devops_connection: false,
    last_sync_time: null,
    error_count_24h: 0,
    status: 'unknown'
};

try {
    // Test Azure DevOps connection
    var testConn = new sn_ws.RESTMessageV2('Azure DevOps Test', 'GET');
    var response = testConn.execute();
    healthCheck.azure_devops_connection = (response.getStatusCode() == 200);
    
    // Check recent sync activity
    var syncGR = new GlideRecord('u_devops_commits');
    syncGR.orderByDesc('sys_created_on');
    syncGR.setLimit(1);
    syncGR.query();
    if (syncGR.next()) {
        healthCheck.last_sync_time = syncGR.getValue('sys_created_on');
    }
    
    // Count recent errors
    var errorGR = new GlideAggregate('syslog');
    errorGR.addQuery('source', 'CONTAINS', 'azure_devops');
    errorGR.addQuery('level', 'error');
    errorGR.addQuery('sys_created_on', '>', gs.daysAgoStart(1));
    errorGR.addAggregate('COUNT');
    errorGR.query();
    if (errorGR.next()) {
        healthCheck.error_count_24h = parseInt(errorGR.getAggregate('COUNT'));
    }
    
    healthCheck.status = 'healthy';
} catch (e) {
    healthCheck.status = 'error: ' + e.message;
}

response.setBody(healthCheck);