Need to create a report on the report table

[Lucy Chen]

I want to create a report on the report table but there doesn't seem to be a report table that I can select from to do so. Is there a way to create a report on the reports table or is this not possible/not practical.

[DJL2]

Hi Lucy,

What kind of report do you want to build against the Report table, so: what is it that you want to show?

Thanks,

DJL

[Lucy Chen]

Hi DJL,

I want to a report to see how many reports have been created in our system aggregated by created date.

Thanks,

Lucy

[DJL2]

Hi Lucy,

In that case, you could run a report against the Report [sys_report] table which contains information about all reports created in your instance.

You would then be able to group them by Created on date.

Thanks,

DJL

[Lucy Chen]

Sys_report does not show up when I search for it. 

[DJL2]

Hi Lucy,

In that case - and like all scenarios where you cannot find a table - you will need to request access to it from your System Administrators.

Thanks,

DJL