tag:blogger.com,1999:blog-3429687762262424005.comments2019-11-08T23:46:42.286-08:00DM_SRKS R KARTHIKhttp://www.blogger.com/profile/11822180162357158827noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-3429687762262424005.post-66299533220917771102012-11-29T07:19:40.564-08:002012-11-29T07:19:40.564-08:00Please find the DQL Query to get the user_os_name,...Please find the DQL Query to get the user_os_name, user_name and all groups that an user belongs to as follows.<br /><br />SELECT DISTINCT u.user_name,u.user_os_name, g.group_name FROM dm_user u, dm_group g WHERE ANY g.i_all_users_names = u.user_name and r_is_group = 0 and u.user_name ='Karthik Sevugan Ratnam' order by u.user_nameS R KARTHIKhttps://www.blogger.com/profile/11822180162357158827noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-17910598038088239092012-11-29T06:55:38.416-08:002012-11-29T06:55:38.416-08:00You can try with the following query to get the li...You can try with the following query to get the list of users & their groups as shown below.<br /><br />select distinct users_names, group_name from dm_group where any users_names in(select user_name from dm_user where user_state=0 and r_is_group=0) order by users_names<br /><br />S R KARTHIKhttps://www.blogger.com/profile/11822180162357158827noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-82858996076556002302012-11-04T02:56:27.431-08:002012-11-04T02:56:27.431-08:00I want to get the list of all user_os_name, user_n...I want to get the list of all user_os_name, user_name and all group he belongs to<br /><br />Please give me the dql which can display above things.<br /><br />Please send me the dql to vu2major@gmail.com<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-50957277070535161492012-08-07T12:48:18.877-07:002012-08-07T12:48:18.877-07:00Hey KarthiK,
Thanks you so much..blog is useful.
...Hey KarthiK,<br /><br />Thanks you so much..blog is useful.<br /><br />referred multiple time..<br /><br />Regards,<br />AnishAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-11741349798539272682012-07-31T04:53:13.052-07:002012-07-31T04:53:13.052-07:00Hi Karthik,
Your blog is great. I hope you are fr...Hi Karthik,<br /><br />Your blog is great. I hope you are from Tamil Nadu. I m also a Tamilan. I m now planning to get certified. Have you got the certification? Please help me in this. I m have 1 year of experience in Documentum. Mainly FirstDoc, an extension of Webtop.Rakeshhttps://www.blogger.com/profile/17481270893849118679noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-71405830613519057052012-04-13T06:10:51.829-07:002012-04-13T06:10:51.829-07:00Great to see this and more helpfulllGreat to see this and more helpfulllAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-5074839604808839952012-03-22T02:47:02.300-07:002012-03-22T02:47:02.300-07:00Excellent...really helpfulExcellent...really helpfulVinayaknoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-3188373885863660392012-03-15T11:00:50.537-07:002012-03-15T11:00:50.537-07:00Hi SRK,
It is very helpful to the persons who are ...Hi SRK,<br />It is very helpful to the persons who are new to the technology.. keep posting stuff like this and can i get some desc on xCP.nikhileshhttps://www.blogger.com/profile/13790743264633433606noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-73714400317122478012012-03-05T13:30:12.957-08:002012-03-05T13:30:12.957-08:00Hi Karthik,
Thank you very much for th...Hi Karthik,<br /><br /> Thank you very much for the excellent posting. I am looking for a query which finds the top level group ie the supergroup of all the groups in a docbase. Would any body post that query ?Ravinoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-33295270745337584602011-11-01T04:02:50.371-07:002011-11-01T04:02:50.371-07:00really helpful! thank you!really helpful! thank you!Lekshminoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-3781949628673772052010-01-28T23:11:25.285-08:002010-01-28T23:11:25.285-08:00thank u your queries are really helpfulthank u your queries are really helpfulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-59071406297110030022009-11-27T23:26:19.378-08:002009-11-27T23:26:19.378-08:00Thanks buddy for the wiki..its really saves time.....Thanks buddy for the wiki..its really saves time..added in delicious..<br /><br />Bharath<br />HyderabadBharathhttp://yoteam.co.ccnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-26802364642580356102009-11-20T18:24:50.998-08:002009-11-20T18:24:50.998-08:00Need query for getting all the availabel docbases?...Need query for getting all the availabel docbases? <br />Can any one suggest me?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-28223153972030388782009-09-19T07:27:19.185-07:002009-09-19T07:27:19.185-07:00hi...i m new to documentum and find ur stuff on th...hi...i m new to documentum and find ur stuff on this blog,very useful.<br />GUD Work...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-85043887649680838192009-09-13T03:55:46.530-07:002009-09-13T03:55:46.530-07:00Hi Mukhesh,
Yuo can try the following query to ge...Hi Mukhesh,<br /><br />Yuo can try the following query to get the size of the folders.<br /><br /><br />SELECT SUM(content_size/1048576) as FOLDER_SIZE FROM dmr_content WHERE ANY parent_id IN (SELECT r_object_id FROM dm_sysobject(ALL) WHERE FOLDER('/ENPC/HRD',DESCEND))<br /><br />Please let me know if you need any more details.<br /><br />Thanks & Regards,<br /><br />S.R.KarthikS R KARTHIKhttps://www.blogger.com/profile/11822180162357158827noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-69922835428793440672009-08-05T23:11:50.854-07:002009-08-05T23:11:50.854-07:00Hi KARTHIK,
This is the good introduction of docum...Hi KARTHIK,<br />This is the good introduction of documentum. If you can add some thing more about TBO, SBO, XML chunking , and new feature in D6.5 like DAM (documentum Activity manager ) that will be great.<br /><br />Thanks and Regards<br />Lokesh MankerAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-60594380708288872762009-08-04T03:59:00.744-07:002009-08-04T03:59:00.744-07:00Hi SRK,
I am serching for a DQL query where i can...Hi SRK,<br /><br />I am serching for a DQL query where i can get size of all my Folder & its subfolder. please let me know if you have any idea.<br /><br />Regards,<br />MukheshAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-8882869759639506862009-07-28T21:16:15.392-07:002009-07-28T21:16:15.392-07:00gud stuffgud stuffAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-37735215916549480972009-07-11T22:32:52.127-07:002009-07-11T22:32:52.127-07:00Sure Man... Wish We could do more.....
SRKSure Man... Wish We could do more.....<br /><br />SRKS R KARTHIKhttps://www.blogger.com/profile/11822180162357158827noreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-36976213827608446622009-07-01T20:34:57.090-07:002009-07-01T20:34:57.090-07:00Hey Karthik,
Really useful stuff you have given. ...Hey Karthik,<br /><br />Really useful stuff you have given. Nice one. Keep on putting up like this.<br /><br />Regards,<br />PinakeenAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-78003490656434170122009-05-28T03:39:07.909-07:002009-05-28T03:39:07.909-07:00Awesome compilation of various DQLAwesome compilation of various DQLAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-51704604846204700662009-03-11T01:01:00.000-07:002009-03-11T01:01:00.000-07:00Hi Karthik, this kiran here, workin in recruitment...Hi Karthik, this kiran here, workin in recruitment. We have very urgent req for Documentum and documaker for one of our client. Location: Bangalore and mumbai.<BR/>If ur lookin for change pls scrap/mail me back at bestatwork@gmail.com.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-48545936955591392862009-02-24T01:47:00.000-08:002009-02-24T01:47:00.000-08:00Congrats buddy!!!Welcome to the world of documentu...Congrats buddy!!!<BR/>Welcome to the world of documentum bloggers.<BR/>Cheers!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3429687762262424005.post-1793335213338773062009-02-24T00:24:00.000-08:002009-02-24T00:24:00.000-08:00All the Best, my friend! - ParthaAll the Best, my friend! - ParthaAnonymousnoreply@blogger.com