The following example illustrates the use of the utility:
|
|
|
|
|
This job generates information about the report usage for reports with report names beginning with the following string: REPORT.
The output report of this job is shown in the two following figures.
CTDREPUS output report (columns 1 to 10)
Control-D Report Usage |
|||||||||
Report name |
Job name |
Category |
User |
File |
Last Decol. Date |
Last Access Date |
Not Used Days |
Max. Life Days |
Retention Days |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
|
|
|
|
|
|
|
|
|
REPORT1 |
JOB1 |
DAILY |
USER10 |
ACT |
25/12/10 |
25/12/10 |
1 |
8 |
|
|
|
|
|
MIG |
26/11/10 |
26/11/10 |
15 |
120 |
365 |
REPORT1 |
JOB1 |
DAILY |
USER11 |
ACT |
25/12/10 |
|
30 |
0 |
|
|
|
|
|
MIG |
26/11/10 |
26/04/10 |
240 |
30 |
365 |
REPORT2 |
JOB2 |
DAILY |
USER20 |
MIG |
01/12/10 |
06/12/10 |
20 |
700 |
3650 |
REPORT3 |
JOB3 |
DAILY |
USER30 |
MIG |
02/12/10 |
05/12/04 |
1480 |
100 |
3650 |
CTDREPUS output report (columns 11 to 16)
Page 001 26/12/10 12:24 |
|||||
---|---|---|---|---|---|
Number of Report entries |
|||||
Total |
Not Used |
Viewed |
Immed. printed |
Deferr. printed |
Restored |
11 |
12 |
13 |
14 |
15 |
16 |
|
|
|
|
|
|
30 |
1 |
29 |
5 |
0 |
0 |
350 |
2 |
348 |
18 |
0 |
0 |
30 |
30 |
0 |
0 |
0 |
0 |
350 |
300 |
50 |
3 |
0 |
0 |
120 |
0 |
120 |
0 |
120 |
0 |
120 |
72 |
48 |
0 |
0 |
0 |
We see that only reports with names starting with "REPORT" are processed.
REPORT1 is daily decollated for two recipients, USER10 and USER11.
USER10 actively works with this report. The last access date from the Active file was the previous day. From a total of 30 entries in the Active file, 29 entries were viewed. The report entries are in the migrated file during 365 days. Almost all report entries from the migrated file were accessed by USER10.
USER11 works with this report very rarely. The last 30 entries from Active file were not used at all. The last access date of migrated reports was 26/04/10 and the last 240 days USER11 did not work with this report. It is reasonable to check if we need to continue decollating this report for USER11.
REPORT2 is monthly decollated for USER20, then it is migrated and kept in the Migration User file for 10 years. All entries of this report are viewed and deferred printed.
REPORT3 is monthly decollated for USER30, then it is migrated and kept in the Migration User file for 10 Years. But the last access date to this report was 05/12/04 and it was not used 1480 days (about 6 Years). From 120 created report entries the last 72 entries have not been used. It is reasonable to check if we can remove the decollation mission that creates this report.
Parent Topic |