Exporting a Report results in different data vs to what's visible in the UI

Scorpion81
Mega Expert

Hi All

What is the correct way to export a report to a CSV or Excel file ? I am noticing discrepancies in my data if i Right click on any of the columns in the Report and do a "Export" to save it as a csv or .xls file. The data comes to be different depending on which column i pick and run the export.

Basically, when i generate a Report in SN, the total count of results that i see on the bottom of the report is different than what i get if l right-click on any of the columns in the same report and do a "export" to a .xls or csv file . 

For instance,  I have generated the below report to list all active/open vulnerable items . This total count comes to be 462,010

find_real_file.png

Now, On the same page as in On the same report, if i pick a column and do a Right click >> Export >> Excel , my excel shows the total count as only 6688 ; even though at the time of Exporting, the system generates a pop up saying "Exporting 462,010 rows" . So even though it says it is exporting the same number of rows but the resultant csv/ xls doesn't have that many number of rows. It ends up coming out to be way less.  Also, this result in the csv as in total number of rows varies depending on which column i do a right click on.  How do i then export it to include all the data that i see in the web Ui ?

find_real_file.png

find_real_file.png

 

1 ACCEPTED SOLUTION

Navigate to table list View.

On your left navigator type your table name, which gives you the list of records and RIGHT CLICK on the highlighted empty space of your table and follow the below snippet

find_real_file.png

 

Thanks,

-Vinay.

View solution in original post

6 REPLIES 6

Knight Rider
Mega Guru

Hi,

I would suggest you to do an export from table instead of report, Since you are retrieving all ACTIVE records.

Also please refer to this below for EXPORT LIMITS

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/exporting-data/concept/c_ExportLimits.html

 

-Vinay.

@Vinay.  Thanks. How do i export data from a table? R you referring to "URL Export" option as mentioned here:  https://docs.servicenow.com/bundle/london-platform-administration/page/administer/exporting-data/con...

 

Navigate to table list View.

On your left navigator type your table name, which gives you the list of records and RIGHT CLICK on the highlighted empty space of your table and follow the below snippet

find_real_file.png

 

Thanks,

-Vinay.

Hi,

Glad, my comment helped. Please mark my answer as  correct if it is!!