Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Get the details of ignored records in transform maps.

kushi1
Tera Contributor

Hi all,

I was having 1083 records with me in excel,i want to update the data in alm_hardware table and don't wanted to create any new records.From the script

if(action=='insert')

ignore=true;

i updated some records (like asset tag,acquistion method)and some are ignored.

Now i want the details of those ignored records(like asset tag)may i know how to fetch these details.However from the i symbol i can see the details but i am unable to export those ignored records.

1 ACCEPTED SOLUTION

Harsh Vardhan
Giga Patron
2 REPLIES 2

sb1186
Kilo Guru

Hi Pooja,



You can go to the Import Set Row (sys_import_set_row) table, from the Navigation Menu, and filter the required Ignored imported data.


Here, you have a column, Target record, which would point out that an update on this record was ignored.


find_real_file.png


You can also export this data by right clicking on the header of the list layout and select Export > Excel, etc.


find_real_file.png



Let me know if this is what you were looking for.



PS: Mark this answer as Correct if it solved your query or hit Like/Helpful depending upon the usefulness of the response.



Regards


Supriya Bisht


Harsh Vardhan
Giga Patron

Hi Pooja,



Please check the thread below.



Import Sets: How to check ignored records?