Comparing two arrays : get the one which is not present in another array

[dhathrianoop]

I have the below script :

Compare two arrays 'arrLaIpAddress' and 'arrCmdbIpAddress', if 'arrLaIpAddress' is not present in 'arrCmdbIpAddress', get those IP address in 'arrIpAddress'.

var ipAddress;
var arrLaIpAddress = [];
var arrCmdbIpAddress = [];
var arrIpAddress =[];
var grDiscoveryLogAnalysis = new GlideRecord('x_qune_da_log_analysis'); // UPDATE TABLE
grDiscoveryLogAnalysis.addQuery('troubleshooting.number', 'TRBL0001033');
grDiscoveryLogAnalysis.query();

while (grDiscoveryLogAnalysis.next()) {
//gs.log(grDiscoveryLogAnalysis.device_ip_address);

ipAddress = grDiscoveryLogAnalysis.getValue('device_ip_address');
arrLaIpAddress.push(ipAddress);
}
//gs.log(arrLaIpAddress);

var grCmdb = new GlideRecord('cmdb_ci');
grCmdb.addNotNullQuery('ip_address');
grCmdb.query();
while (grCmdb.next()) {
var cmdbIpaddress = grCmdb.ip_address;
arrCmdbIpAddress.push(cmdbIpaddress+'\n');

}

//gs.log(arrCmdbIpAddress);

for(var y = 0; y < arrLaIpAddress.length; y++){
if(arrCmdbIpAddress.indexOf(arrLaIpAddress[y]) < 0){
arrIpAddress.push(arrLaIpAddress[y]+'\n');
}
}
gs.log(arrIpAddress);

[Ashley Snyder1 · Accepted solution]

Have you tried using the ServiceNow ArrayUtil method?

There's a built in 'diff' function that will compare two arrays. https://docs.servicenow.com/bundle/paris-application-development/page/app-store/dev_portal/API_refer...

[dhathrianoop]

I want only the element of 'arrLaIpAddress' if its not present in 'arrCmdbIpAddress'

[Ankur Bawiskar]

Hi,

As already mentioned you need to use ArrayUtils diff method

https://docs.servicenow.com/bundle/kingston-application-development/page/app-store/dev_portal/API_re...

Regards
Ankur

[dhathrianoop]

a= [1,2,3,4]

b=[2,3,4,5]

by using ArrayUtils am getting [1,5]..but I want only [1]