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,

Just to follow-up further, the Report table contains the following fields (amongst others) which will help you to consider: the relevance of each report (when it was created), the performance impact (is it scheduled) and its originator (who created it):

• Title
• Table
• Type
• Created by
• Created (on)
• Updated (on)
• Is Scheduled

Once you have access to this table, you could create a timeseries trended on 'Created' and set the time interval to month.  That would give you an overall picture of volumetric creation.

It might then be an idea to aggregate by 'Is Scheduled' to differentiate between and highlight those reports which produce a regular overhead on your instance.

Hope that helps?

Thanks,

DJL

[Lucy Chen · Accepted solution]

Solution: Add sys_report to glide.ui.permitted_tables properties