In our environment, users are using same document domain to store reports in repository, send report to other users and it is also used by document agent server to send refreshed reports to users. A number of users do not retrieve the documents even when BO prompts them to do that. As a result we have huge number of documents lying around in the domain for quite sometime. My intention is to clean it up.
Is it possible ? Does anybody has a script to do that ? - I plan to clean up only documents present there as a result of ‘Send to User’ or DAS run.
Is it possible to get a list of documents present in a document domain along-with its creator name,last refresh time etc. by executing some SQL query ?
Any help is appreciated
Abhijit
We have the same issue here. There is a new feature in 5.0 that allows you to see the Properties on the Delete Documents tab under Tools, which I am suspecting gives you useful information such as date and size. Right now all you can see in 4.1.x Supervisor is whether a document was sent to a user, the repository or was processed by the DAS. You can write a report against the security domain if you have a universe created for it. That’s what I have been doing to get the last action dates on the reports and their sizes. We had reports out there from 1997!
Corporate Documents (M_DOC_N_TYPE=1, M_DOC_N_PERSISTENT=1) - Documents processed by BCA and distributed to users. (M_DOC_N_TYPE=4 , M_DOC_N_PERSISTENT=0) - Documents sent from one user to other user (M_DOC_N_TYPE=1, M_DOC_N_PERSISTENT=0) - Documents sent to BCA (M_DOC_N_TYPE=1 , M_DOC_N_PERSISTENT=0)
You can identify documents sent to BCA by joing with DS_PENDING_JOB table.
These tables also have date fields to identify when the document is exported, sent to bca, sent to user and processed by bca.
Vasan
Baton Rouge International Inc
Data Warehousing Division
In our environment, users are using same document domain to store reports in repository, send report to other users and it is also used by document agent server to send refreshed reports to users. A number of users do not retrieve the documents even when BO prompts them to do that. As a result we have huge number of documents lying around in the domain for quite sometime. My intention is to clean it up.
Is it possible ? Does anybody has a script to do that ? - I plan to clean up only documents present there as a result of ‘Send to User’ or DAS run.
Is it possible to get a list of documents present in a document domain along-with its creator name,last refresh time etc. by executing some SQL query ?
Any help is appreciated
Abhijit
******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP