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

[Scorpion81]

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 ?

[Tony Chatfield1]

Hi, in addition to Vinay's comments. A report can show that X rows were returned, yet not show them all when a user scrolls through the result if the user is prevented from seeing individual records by security constraints and this can also result in empty fields within a report.. Your first step would be to validate that you (the report runner/data exporter) has the rights to view all records being returned and this is normally easier to validate from the tabke list view.

[Scorpion81]

I am looking at the option of breaking the data into chunks. 

Since i already have a report created in the UI, do you know of any way to export this report using the URL Export method instead of doing it from the UI ? Can i pass the Report ID or Report Name in the query ? 

My report queries the sn_vul_vulnerable_item table and there is a  group by clause that i have configured. 

Alternatively if i cannot pass the Report ID/name, How can i add a group by clause to the below query and select which columns from the table to export ?

 https://<domain.service-now.com>/sn_vul_vulnerable_item.do?CSV&sysparm_query=active=true