These examples are meant to give you a head-start on the basic DQL syntax. For more information on DQL, please refer to Content Server DQL Reference guide. EMC® Documentum® Content Server Version DQL Reference EMC Corporation Corporate Headquarters: Hopkinton, MA This guide is the reference manual for the EMC Documentum object hierarchy. to EMC Documentum Content Server DQL Reference, EMC Documentum.

Author: Vudotilar Mezishakar
Country: Panama
Language: English (Spanish)
Genre: Relationship
Published (Last): 14 April 2016
Pages: 21
PDF File Size: 9.1 Mb
ePub File Size: 12.32 Mb
ISBN: 284-5-23258-255-3
Downloads: 10913
Price: Free* [*Free Regsitration Required]
Uploader: Mukora

April 27, at 10 h 36 min. Note that you have to replace the Indey Agent information in the first line by your Index Agent. Infrastructure at your Service. This query returns your configured index agent information.

July 31, at dmc h 21 min. November 29, at 9 h 51 min.

This means that if a rendition request failed 3 times in a row and succeed the last time, there will be 3 rows in the failed queue, but the rendition did succeed. October 15, at 11 h 11 min.

Documentum: some useful queries (DQL/IAPI)

Be aware that it can take a while depending on the number of entries you have. This one simply puts an fmc request in the queue.

This query flushes caches, it can be used when trying to install ADTS dars and fails due to version mismatch. December 12, at 12 h 39 min.


Documentum: some useful queries (DQL/IAPI) – Blog dbi services

This one folder still has the old group and the new group in the permissions list. It is useful for the IAPI command returning the index agent status see below. Hi Ajith, I have the following query to list all documents and folders in a cabinet. It can be used to check if the dsearch is working fine and if the indexing has been performed correctly. You are commenting using your Facebook account.

In fact, it can happen if someone saved a document, then deleted it right after. These examples are meant to give you a head-start on the basic DQL syntax.

It regroups the rendition queue check and the way to manually ask a rendition through IAPI. You can create a PDF rendition of a Acsii file, for that you need a PDF converter plugin, for searching within the contents of a file you should have full text search enabled on that content server. This query displays the number of failed logons in the docbase per user since 60 minutes.

In Samson, if you forgot to terminate the query with a semicolon ; you will get a prompt like shown below. This query returns all documents present in the rendering queue. First, check if the file is deleted by running the IPAI: This will return object id and name of all the objects that was created between today and Check its log file, it normally contains all these information already.


Sample DQLs

Leave a Reply Cancel reply Enter your comment here Many of you must be using Samson to do your DQL queries. Notify me of new comments via email. This statement purges the audit trail queue by deleting all logon failure entries. It can be useful when scripting or in DFC programs. So you should verify that the rendition did succeed and if so, you can delete the row form of the failed queue.

Index Agent Info select fti. November referenxe, at 9 h 22 min. Note that the parameter can still ne changed.

Sometimes I noticed there are indexing requests on deleted documents. You are commenting using your WordPress. I tried to reassign a group to a new group and the job worked except that rference did not update one folder. Can you please let me know if there is way to convert an ASCII file to pdf and file to Documentum so that a user and search on it.

You can get these information thanks to the DQL query above.

I am a total newbie at this and found your extremely useful blog with related matters and hope you can help.