List of Reports with Retention

[JimWilson]

Is their a command to list all the reports in OnDemand along with the retention for each report?

This is a Windows System and OnDemand v8.3

[JimWilson]

I know I can go the Application Group - Summarize for a specific report and get the information I am looking for, but I want all the reports that are in the system.
Is their a command line command for this?

[JimWilson]

Wayne wrote - Highlight all the app grps then summarize.  You'll get every reports attributes in one text file.

This worked just fine. I did not know you could highlight all the Application Groups.

Thank you Wayne,
1830 Application Groups choosing General and Storage Management only took about 4 minutes and gave me a nice report.

Thank you Wayne

[rick]

This information can be easily obtained from the database.

Connect to the database and query

select name, db_exp_date, sid from XXX.arsag

replace XXX with database name

Name - AG name
db_exp_date - Expiration date set for data and indexes
sid - Storage node identifier.

This data can be retrived in single shot

Rick
www.rick.co.in

[yousuf_gani]

Hi Jim,

I have highlighted the Application Group. However i am not seeing the retention period defined for each and every AG. Only Application group has been summarized.

Like this.
  APPLICATION GROUP NAME:  4806c
  APPLICATION GROUP NAME:  4806d
  APPLICATION GROUP NAME:  4806d2
  APPLICATION GROUP NAME:  5050
  APPLICATION GROUP NAME:  5050syn
  APPLICATION GROUP NAME:  5498c01