Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

VaranAwesomenow
Mega Sage

Below script gives unique list of vendor and manufacturer names

var vendorHash = {};
var ManufacturerHash = {};
var grCi = new GlideRecord('cmdb_ci');
grCi.query();
while(grCi.next()) {
ManufacturerHash[grCi.getDisplayValue('manufacturer')] = 1;
vendorHash[grCi.getDisplayValue('vendor')] = 1;
}
printHash(ManufacturerHash, 'Manufacturer');
printHash(vendorHash, 'Vendor');

function printHash(hashArray, Name) {
for (var k in hashArray) {
// use hasOwnProperty to filter out keys from the Object.prototype
if (hashArray.hasOwnProperty(k)) {
gs.print( Name + "|"+ k + "|"+ hashArray[k]);
}
}
}

var vendorHash = {};
var ManufacturerHash = {};
var grCi = new GlideRecord('cmdb_ci');
grCi.query();
while(grCi.next()) {
ManufacturerHash[grCi.getDisplayValue('manufacturer')] = 1;
vendorHash[grCi.getDisplayValue('vendor')] = 1;
}
printHash(ManufacturerHash, 'Manufacturer');
printHash(vendorHash, 'Vendor');

function printHash(hashArray, Name) {
for (var k in hashArray) {
// use hasOwnProperty to filter out keys from the Object.prototype
if (hashArray.hasOwnProperty(k)) {
gs.print( Name + "|"+ k + "|"+ hashArray[k]);
}
}
}

 

Version history
Last update:
‎01-12-2021 06:27 AM
Updated by: