ServiceNow Asset Data Load Pre checks or procedure

 

Pre-Checks

Acquisition method	Asset tag	Assigned	Assigned to
Comments	Manufacturer	Cost	Cost center
Depreciation	Depreciation effective date	Disposal reason	Due
Installed	Retired date	State	Invoice number
Managed by	Model	Model Category	Ordered
Purchased	Quantity	Request line	Resale price
Salvage value	Serial number	Stockroom	Substate
DR Option	Part Number	Room	Shared Workstation Reason
Vendor	Warranty expiration	Building	Support group
Beneficiary	Checked in	Checked out	Supported by
Order received	Department	Name	Workstation Classification
Due in	Expenditure type	GL account	Window
Justification	Lease contract	Location	Wave
Owned by	Parent	PO number	Scheduled retirement
Reserved for

Transform used to load data in LYB ServiceNow

Name: LYB Asset Data Load

Post-Checks

var dupRecords = [];

var gaDupCheck1 = new GlideAggregate('cmdb_ci_hardware');

gaDupCheck1.addAggregate('COUNT', 'serial_number');

gaDupCheck1.groupBy('serial_number');

gaDupCheck1.addHaving('COUNT', '>', 1);

gaDupCheck1.query();

while (gaDupCheck1.next()) {

               

    dupRecords.push(gaDupCheck1.serial_number.toString());

}

gs.print(dupRecords);

var dup = new GlideAggregate(‘alm_hardware’);

dup.groupBy('serial_number');

dup.query();

while(dup.next()) {

                var dup1 = new GlideRecord('alm_ hardware’');

                dup1.addQuery('serial_number', dup.serial_number);

                dup1.query();

                dup1.next();

                while(dup1.next())

                                dup1.deleteRecord();

}

Further Reference for Data load or transform Maps.

https://old.wiki/index.php/Transform_Map_Scripts