- Post History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 01-12-2021 06:27 AM
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]);
}
}
}