For 1) Report Name and 4) Usage Details, that information is already available in the built-in Traffic to Views admin view. I'd suggest checking out that view first to see if it meets your needs before doing redundant work.
If you do end up needing access to this information directly, I'm thinking you would need to join the views and views_stats tables together, as the views_stats table has the nviews field to tell you how often it has been accessed, and the views table has the name of the view. Caveat: I have not tested this join myself.
For 2) column names presented to the user - you'll want the views table in postgres (this requires readonly user access). The field you are looking for is called fields. Note that this only shows fields used in views, and not dashboards.
For 3) corresponding table/column name - I'm uncertain how you could go about pulling this information out of postgres. I'm not finding a simple way to tie the fields field from the views table back to the underlying data source, which is what you would need to do. If you are able to find a way to do this, please let me know.
Lakshminarasimhan Santhanam wrote:
1) Report name
2) presentation column names used inside the report(The column names shown to users)
3) corresponding table.column name or formula which is used to display this column...
This may work: What's in your workbooks? The TWB Auditor v2.0
It's not actively supported which is why it may not work.