I want to start by saying that I don't think this is possible, but if anyone has been down this road, I'd appreciate some tips. We have a big Records Management project under way, and we are being tasked with creating an inventory of all CMOD Reports so that they can be categorized and managed for expiration. When a report is defined by an application within an application group, this is fairly simple. However, we have many applications that process report bundles which are broken up into their constituent reports by the ACIF indexer. An index field with BREAK=YES controls this. These reports are all separately viewable via the dropdown within the folder. I cannot think of a way to capture all of these reports within a single application. Any ideas?
I'm not 100% sure what you're trying to achieve, but you should be able to query the database directly with the arsdoc query -i option, and use the same field as the Application ID field to find all the reports from a single Application.
-JD.
Thanks for the reply Justin. We have over 34,000 applications defined. I don't know which ones are single reports and which have bundled reports spiked out. Even then, some of the applications do it via apid, and some just create an index field, rname, rptno, etc. and this field is used in the folder dropdown. With this many, I have to do something programmatically, I can't list each individual application. I don't think this is possible, but if you can think of something, that would be great.
There is a Summarize option in the Admin panels that show the fields in the dropdown. Is there a way to run that for every appgrp in a script?
I'm not sure if the 'Summarize' option will give you exactly what you need, but yes -- you can select a range of Applications / Application Groups by clicking on the first one, then shift-clicking on the last one to select a range. Then right-click on one of the selected items, and choose Summarize.
With 34k Apps defined, I get the feeling that it might take a while. :)
Good luck!
-JD.
Hi Markd,
it's possible but you need a repository (one ore more database tables) where you need to store the information how to identify the Reports and store the retention rules fro these reports. This may be:
- report is identified by application
- report is identified by by a combination of index values
.
.
.
If you know this (this information must be delivered by business), you can generate a retention process.
regards
Egon