Read data from transaction table, system logs table etc via web services?

[Suggy]

I have a requirement from customer to read the data from tables like transaction table, system logs, audit tables etc, into an external system for some data analytics.

I know that these are very large tables and ServiceNow does not even allow to create reports on them OOB. 

The question now is, can we really READ data in above tables via REST API's or not? Should we allow this or not?

Or

Are there any alternative methods like Export sets etc which we can use to export the data instead of reading via API's?

Please share your inputs. TIA ....

[Suggy]

Hi @REYMECCY I have updated my question with more clarity/details. Looking for an answer for that now 🙂

Thanks!

[Suggy]

Anyone?

[ersureshbe]

Hi, You need very careful when you are reading the transaction and log tables. I believe, you can check 'Log Analytics' capability from ServiceNow. For transaction tables, you can use web services but pulling record limit you should define else it will create performance issue in ServiceNow.