Hi Everyone,
We are using content server 10 update 13 and using oracle
Can anyone guide me how to get the below info. through query
All the user's deletion date, create date, modify date and who created those user's as login name.
Thanks,
S K Pati
Hi Every one,
Sorry for the wrong info.
We are using sql server 2012
This is done, regardless of the DB brand, out of the DAUDITNEW table.
“Auditid” = 1 is Create.
“Auditid” = 3 is Delete.
There are other AuditIDs for modifying a User Profile and group membership.
In each record is the “Performerid” containing the KUAF ID of who created, deleted, maintained the User.
If the User has been deleted, you’ll have to know of find the KUAF.ID, it won’t show when using the facility to look for a User.
Attached is an LR for ORACLE that will work for you, but I would suggest you also search this forum for LRs that have been attached.
Colin J. Schmidt
Knowledgelink Support
CapitalOne | Collaboration Technology
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, June 15, 2016 4:40 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: User's deletion date
User's deletion date
Posted by Pati, Suchitra Kumar On 06/15/2016 04:35 AM
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.
[Attachments exceeded pre-set size limits. Use the links provided to access] RE User's deletion date Posted bySchmidt, ColinOn 06/15/2016 06:41 AM This is done, regardless of the DB brand, out of the DAUDITNEW table. “Auditid” = 1 is Create.“Auditid” = 3 is Delete.There are other AuditIDs for modifying a User Profile and group membership. In each record is the “Performerid” containing the KUAF ID of who created, deleted, maintained the User.If the User has been deleted, you’ll have to know of find the KUAF.ID, it won’t show when using the facility to look for a User.Attached is an LR for ORACLE that will work for you, but I would suggest you also search this forum for LRs that have been attached. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, June 15, 2016 4:40 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: User's deletion date User's deletion date Posted by Pati, Suchitra Kumar On 06/15/2016 04:35 AM Hi Everyone,We are using content server 10 update 13 and using oracleCan anyone guide me how to get the below info. through queryAll the user's deletion date, create date, modify date and who created those user's as login name.Thanks,S K Pati [To post a comment, use the normal reply function]Forum: Content Server LiveReports ForumContent Server: Knowledge Center
Re RE User's deletion date Posted byeLinkOn 06/15/2016 09:12 AM a deleted user is the one who is found by this query select * from kuaf where deleted=1 and type=0you will notice that LL will affix a name (Delete) 123456789(the original id)conversely a non deleted user is thisselect * from kuaf where deleted=1 and type=0If I wanted to find info on all user who were deleted in my livelink I could do thisselect * from kuaf where deleted=1 and type=0 and lower(name) like '%delete%';I thought some additional info regarding the above Colin query can be useful if you are newI did not look at athat query perhaps he is considering all that in his query.SQL queries are basically different many times between the vendor databases.While I don't really knowmore learned people always say to use ANSI SQL which is supposedly obeyed by all major vendors.Another part which I have used before is when a user gets created he/she gets a PWS of subtype=142 and its dataid is theusers' kuaf.id so in the worst case you can basically get that creation time as the user's creation time
A smart thing would be to put the Creation and Deletion Date in the KUAF record, besides the DAUDITNEW table.
There’s a Champion Toolkit that will provide some of these codes. Though it doesn’t have them all and it doesn’t have enough.
https://knowledge.opentext.com/knowledge/cs.dll/fetch/2001/744073/6848762/19905386/Content_Server_Schema_Companion_Reference_Guide.pdf?nodeid=13682418&vernum=13
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, June 15, 2016 9:24 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Re Re RE User's deletion date
Re Re RE User's deletion date
Posted by eLink On 06/15/2016 09:22 AM
correction on my part a cut and paste mistake
Not a Deleted Alive and Kicking User
select * from kuaf where deleted=0 and type=0
.....appuappnairappunair
Well, if I called the wrong number, why did you answer the phone?James Thurber, New Yorker cartoon caption, June 5, 1937
On Wed, Jun 15, 2016 at 8:13 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:
Re RE User's deletion date Posted by eLink On 06/15/2016 09:12 AM a deleted user is the one who is found by this query select * from kuaf where deleted=1 and type=0you will notice that LL will affix a name (Delete) 123456789(the original id)conversely a non deleted user is thisselect * from kuaf where deleted=1 and type=0 If I wanted to find info on all user who were deleted in my livelink I could do thisselect * from kuaf where deleted=1 and type=0 and lower(name) like '%delete%';I thought some additional info regarding the above Colin query can be useful if you are newI did not look at athat query perhaps he is considering all that in his query. SQL queries are basically different many times between the vendor databases.While I don't really knowmore learned people always say to useANSI SQL which is supposedly obeyed by all major vendors. Another part which I have used before is when a user gets created he/she gets a PWS of subtype=142 and its dataid is theusers' kuaf.id so in the worst case you can basically get that creation time as the user's creation time .....appuappnairappunair Well, if I called the wrong number, why did you answer the phone?James Thurber, New Yorker cartoon caption, June 5, 1937 On Wed, Jun 15, 2016 at 5:42 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:[Attachments exceeded pre-set size limits. Use the links provided to access]RE User's deletion date Posted by Schmidt, Colin On 06/15/2016 06:41 AM This is done, regardless of the DB brand, out of the DAUDITNEW table. “Auditid” = 1 is Create.“Auditid” = 3 is Delete.There are other AuditIDs for modifying a User Profile and group membership. In each record is the “Performerid” containing the KUAF ID of who created, deleted, maintained the User.If the User has been deleted, you’ll have to know of find theKUAF.ID, it won’t show when using the facility to look for a User.Attached is an LR for ORACLE that will work for you, but I would suggest you also search this forum for LRs that have been attached. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, June 15, 2016 4:40 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: User's deletion date User's deletion date Posted by Pati, Suchitra Kumar On 06/15/2016 04:35 AM Hi Everyone,We are using content server 10 update 13 and using oracleCan anyone guide me how to get the below info. through queryAll the user's deletion date, create date, modify date and who created those user's as login name.Thanks,S K Pati [To post a comment, use the normal reply function]Forum:Content Server LiveReports ForumContent Server:Knowledge Center The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer. Attachment Links: UserAuditHistory_LiveReport.rpt (3 KB)[To post a comment, use the normal reply function]Topic: User's deletion dateForum: Content Server LiveReports ForumContent Server: Knowledge Center[To post a comment, use the normal reply function]Topic: User's deletion dateForum: Content Server LiveReports ForumContent Server: Knowledge Center
Re RE User's deletion date
Posted by eLink On 06/15/2016 09:12 AM
a deleted user is the one who is found by this query
select * from kuaf where deleted=1 and type=0
you will notice that LL will affix a name (Delete) 123456789(the original id)
conversely a non deleted user is this
If I wanted to find info on all user who were deleted in my livelink I could do this
select * from kuaf where deleted=1 and type=0 and lower(name) like '%delete%';
I thought some additional info regarding the above Colin query can be useful if you are new
I did not look at athat query perhaps he is considering all that in his query.
SQL queries are basically different many times between the vendor databases.While I don't really know
more learned people always say to useANSI SQL which is supposedly obeyed by all major vendors.
Another part which I have used before is when a user gets created he/she gets a PWS of subtype=142 and its dataid is the
users' kuaf.id so in the worst case you can basically get that creation time as the user's creation time
On Wed, Jun 15, 2016 at 5:42 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:
[Attachments exceeded pre-set size limits. Use the links provided to access]RE User's deletion date Posted by Schmidt, Colin On 06/15/2016 06:41 AM This is done, regardless of the DB brand, out of the DAUDITNEW table. “Auditid” = 1 is Create.“Auditid” = 3 is Delete.There are other AuditIDs for modifying a User Profile and group membership. In each record is the “Performerid” containing the KUAF ID of who created, deleted, maintained the User.If the User has been deleted, you’ll have to know of find theKUAF.ID, it won’t show when using the facility to look for a User.Attached is an LR for ORACLE that will work for you, but I would suggest you also search this forum for LRs that have been attached. Colin J. SchmidtKnowledgelink SupportCapitalOne | Collaboration Technology From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Wednesday, June 15, 2016 4:40 AMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: User's deletion date User's deletion date Posted by Pati, Suchitra Kumar On 06/15/2016 04:35 AM Hi Everyone,We are using content server 10 update 13 and using oracleCan anyone guide me how to get the below info. through queryAll the user's deletion date, create date, modify date and who created those user's as login name.Thanks,S K Pati [To post a comment, use the normal reply function]Forum:Content Server LiveReports ForumContent Server:Knowledge Center The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer. Attachment Links: UserAuditHistory_LiveReport.rpt (3 KB)[To post a comment, use the normal reply function]Topic: User's deletion dateForum: Content Server LiveReports ForumContent Server: Knowledge Center
[Attachments exceeded pre-set size limits. Use the links provided to access]
RE User's deletion date
Posted by Schmidt, Colin On 06/15/2016 06:41 AM
If the User has been deleted, you’ll have to know of find theKUAF.ID, it won’t show when using the facility to look for a User.
Attachment Links:
UserAuditHistory_LiveReport.rpt (3 KB)
Topic:
