Retrieve servicenow incidents and cmdb records for given configuration item | Scripted REST API and PowerShell

[Chendrayan Venk]

Let me show the simple trick to query all incidents and changes for the given configuration item. In my case CAR-3 is a CI which has one incident record and for our demo lets create a Scripted REST API to fetch required information. 

Note: You can think about Database views for your environment. I will cover that in my upcoming blog.

Our goal is to achieve below output (2 incidents [Created for a demo] for given CI [CAR-3] and required CI field information)

System Definitions (Script Includes)

var getconfigurationitemdetails = Class.create();
getconfigurationitemdetails.prototype = {
    getIncidentRecords: function (CIName) {
        try {
            var incidentRecord = [];
            var gr = new GlideRecord('incident');
            var queryString = 'cmdb_ciSTARTSWITH' + CIName;
            gr.addEncodedQuery(queryString);
            gr.query();
            while (gr.next()) {
                incidentRecord.push({
                    'number': gr.number + '',
                    'state': gr.state.getDisplayValue() + '',
                    'opened_at': gr.opened_at
                });
            }
            return incidentRecord;
        }
        catch (e) {
            gs.error('error=', e);
        }
    },

    getCMDBRecords: function (CIName) {
        try {
            var cmdbRecord = [];
            var gr = new GlideRecord('cmdb_ci');
            gr.addQuery('name', CIName);
            gr.query();
            if (gr.next()) {
                cmdbRecord.push({
                    'name': gr.name + '',
                    'asset_tag': gr.asset_tag.getDisplayValue() + '',
                    'managed_by': gr.managed_by.getDisplayValue()
                });
                return cmdbRecord;
            }
        }
        catch (e) {
            gs.error('error=', e);
        }
    }
};

Scripted REST API

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
    var incidentRecord = new getconfigurationitemdetails().getIncidentRecords(request.pathParams.CIName);
    var cmdbRecord = new getconfigurationitemdetails().getCMDBRecords(request.pathParams.CIName);
    return {
        'incidentRecord': incidentRecord,
        'cmdbRecord': cmdbRecord
    };
})(request, response);

Now, comes our PowerShell code!

param(
    $CIName = 'Car-3'
)

try {
    $Uri = "https://dev42835.service-now.com/api/253124/getconfigurationitemdetails/$($CIName)"
    $admin = "admin"
    $password = "admin" | ConvertTo-SecureString -AsPlainText -Force
    $Credential = New-Object pscredential -ArgumentList ($admin , $password)
    $Results = Invoke-RestMethod -Uri $Uri -Method Get -Credential $Credential
    $Results.result.incidentRecord
}
catch {
    $_.Exception
}

Sample Output 

{
    "incidentRecord": [
        {
            "number": "INC0010005",
            "state": "New",
            "opened_at": "2018-07-20 12:29:00"
        },
        {
            "number": "INC0010006",
            "state": "New",
            "opened_at": "2018-07-20 12:29:00"
        }
    ],
    "cmdbRecord": [
        {
            "name": "Car-3",
            "asset_tag": "P1000113",
            "managed_by": "Bow Ruggeri"
        }
    ]
}