Getting different number of records in Service-Now and the Exported Excel for the same table

vaibhav000
Kilo Contributor

Hi All,

I have been exporting the data of one of the table into Excel and found that it gave me 95 number of records whereas in the service-now instance it shows only 34 records.

From where these extra records are coming from?

Need Suggestions please.

Regards

Vaibhav

1 ACCEPTED SOLUTION

It is happening because of query business rule 'Hide admin homepage categories'


If you deactivate that and open the table you will get all 95 records.



The query br is stopping the records from being displayed on the list but for some reason it is not being applied to the export function.


-Anurag

View solution in original post

15 REPLIES 15

syedfarhan
Kilo Sage

Hi Vaibhav,



I think the 34   records will be an active records which you are seeing in Servicenow instance , Where while exporting you would export the data by using example:


www.instancename.service-now.com/incident_list.do?CSV . This URL pulls all the active and false records.



May be of due to this. Kindly check it.



Thanks


Hi Syed,


I have tried your URL for the Category table but the excel sheet is being downloaded and its blank.


I have already exported the Excel of the Category Table and it has 95 records while the service-now is showing 34 records only.


How to bring the whole 95 records in service-now?


And what is the reason its being showing differently??



Thanks


Vaibhav


Hey Vaibhav,,



Sorry that is www.instancename.service-now.com/sc_category_list.do?CSV



Can you pls provide the screenshot . Let me check it



Thanks


Yes Syed,


Please find the screenshot of the instance where i am getting 34 records for Category Table.


SN_1_2016.png



Regards


Vaibhav