nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query for Group Information

Rocha_Kimi

I'm looking for help with the SQL to display:

Group Name, Create Date

Group Name, Delete Date

Find more posts tagged with

Comments

CBancroft

Can you provide more context around your request please. Create date and delete date of a group? An object?

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, August 24, 2017 2:16 PM
To: eLink Recipient
Subject: Query for Group Information

Query for Group Information

Posted by Rocha, Kimi On 08/24/2017 02:05 PM

I'm looking for help with the SQL to display:

Group Name, Create Date

Group Name, Delete Date

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

Rocha_Kimi

Create and Delete date for the group itself.

I know - way too simple compared to the other questions in this forum but it wasn't obvious to me...

Colin_Schmidt

It looks like the only place is in DAUDITNEW.

You’d look for the KUAF.ID in DAUDITNEW.USERID and DAUDITNEW.AUDITID in (1, 2)

Colin J. Schmidt

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, August 24, 2017 3:07 PM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: RE Query for Group Information

RE Query for Group Information

Posted by Rocha, Kimi On 08/24/2017 03:04 PM

Create and Delete date for the group itself.

I know - way too simple compared to the other questions in this forum but it wasn't obvious to me...

[To post a comment, use the normal reply function]
Topic:	Query for Group Information
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

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.

Nizar Ghazal

Hi Kimi,

Logically, this doesn't seem too bad, provided you have the right auditing interests set.

The KUAF has a Type of 1, for groups, and you can join the ID in KUAF on the UserID in DAuditNew.

Just do a SELECT with these two joined, and filter by looking for an AuditStr of "Create" or "Delete".

Here is a super simplistic example:

SELECT OTCS.KUAF.Name, OTCS.DAuditNew.AuditDate

FROM OTCS.KUAF JOIN OTCS.DAuditNew ON KUAF.ID = DAuditNew.UserID

WHERE Type = 1 AND AuditStr = 'Create'

As always, the samples are provided as is, and aren't fully tested. Hope that gives you some ideas!

Rocha_Kimi

Thanks to all! I'll give it a try tomorrow.