- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:03 AM
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
Solved! Go to Solution.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:57 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:18 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:26 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:36 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-07-2016 02:44 AM