Want to export huge data through report.

[salu]

Hi All,

I want to export a huge date about 4 lakh row of data.I am trying to export in excel,it giving at maximum 50,000 row in excel.Please let is it maximum limit of the service now or is there any way to export it.Please suggest a solution.

[harikrish_v]

I don't think so Saranya. You might have to put filters based on update date or so have to export records in chunks of 40k till you finish off the entire lot.

Thanks & Regards,

Hari

[Community Alums]

My first question when I hear someone would like to export this many rows of data is: Why?

Why do you want to export so many rows of data?

• Is it for reporting? You can get a lot of reports right from ServiceNow, and if you are looking to create a report that you cannot in ServiceNow, there are better ways to do it than exporting.
• Is it to share the data with an external system? If so, there is likely a better way to share the data between ServiceNow and the external systems, whether through Web Services or JDBC.

Those are the common responses I get. What are you trying to do, Saranya?

[salu]

Hi Ben,

Thank you for your response.

We have a requirement like a finance administrator need to audit the all the asset which were the application is being used..

For example: There is CI where there is so many servers are depends on that CI, we need all the value from our relationship table.

Hope you got What I am trying to do?

Thanks

Saranya

[Community Alums]

I am not sure I understand exactly. I think I understand enough, but I am unclear as to why there are so many records and why you could not provide the finance administrator with a real time report right in ServiceNow instead of doing an export.

[salu]

Hi Ben,

I need to get all the data from our CI relation ship table. If the report won't work over there, then what you are suggesting to do?