- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 08:35 AM
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.
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 ?
Solved! Go to Solution.
- Labels:
-
Vulnerability Response

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 11:17 AM
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
Thanks,
-Vinay.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 09:05 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 10:20 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-03-2020 11:17 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-05-2020 10:12 AM
Hi,
Glad, my comment helped. Please mark my answer as correct if it is!!