Looking for the SQL to develop a liveReport to show all the active users and their last login date. Any help would be much appreciated!
That would involve two tables: KUAF and DAUDITNEW.
select k.id, k.name, k.lastname+', '+k.firstname "Username",MAX(da.auditdate)
from kuaf k
join dauditnew daon k.id= da.useridand da.auditid= 23
where k.type= 0and k.deleted= 0and k.id<> 1000
groupby k.id, k.name, k.lastname+', '+k.firstname
Colin J
From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>Sent: Wednesday, September 12, 2018 12:39 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Live Report for last login of all active users
Live Report for last login of all active users
Posted bynikole.curkan@hrsdc-rhdcc.gc.ca (Curkan, Nikole) On 09/12/2018 01:36 PM
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
My Support
Just a quick note that depending on what you're looking to report on, strict "login" might not be the most accurate. For example, using Enterprise Connect records no login. Also, even through the browser; assuming I'm active enough, I may not need to login for a substantial amount of time.
For KPIs, I've generally noted the last activity of any sort by the users. If they're audited, it means they're using the system.
Cheers,
Ben
eLink : [EXTERNAL] - RE Live Report for last login of all active users On September 12, 2018 at 2:12 PM "eLink Entry: Content Server LiveReports Forum" <livereportsdiscussion@elinkkc.opentext.com> wrote: [EXTERNAL] - RE Live Report for last login of all active users Posted by colin.schmidt@cognizant.com (Schmidt, Colin) On 09/12/2018 02:12 PM That would involve two tables: KUAF and DAUDITNEW. select k.id, k.name, k.lastname+', '+k.firstname "Username", MAX(da.auditdate)from kuaf k join dauditnew da on k.id = da.userid and da.auditid = 23 where k.type = 0 and k.deleted = 0 and k.id <> 1000 group by k.id, k.name, k.lastname+', '+k.firstname Colin J From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> Sent: Wednesday, September 12, 2018 12:39 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Live Report for last login of all active users Live Report for last login of all active users Posted by nikole.curkan@hrsdc-rhdcc.gc.ca (Curkan, Nikole) On 09/12/2018 01:36 PM Looking for the SQL to develop a liveReport to show all the active users and their last login date. Any help would be much appreciated! [To post a comment, use the normal reply function]Forum: Content Server LiveReports Forum Content Server: My Support [To post a comment, use the normal reply function] Topic: Live Report for last login of all active users Forum: Content Server LiveReports Forum Content Server: My Support
select k.id, k.name, k.lastname+', '+k.firstname "Username", MAX(da.auditdate)
join dauditnew da on k.id = da.userid and da.auditid = 23
where k.type = 0 and k.deleted = 0 and k.id <> 1000
group by k.id, k.name, k.lastname+', '+k.firstname
From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> Sent: Wednesday, September 12, 2018 12:39 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Live Report for last login of all active users
Posted by nikole.curkan@hrsdc-rhdcc.gc.ca (Curkan, Nikole) On 09/12/2018 01:36 PM
Here is one(attached) I found in the KC several years ago(a real find!). This records counts of whatever activity you want included in the count by User per hour over a single day. You can have multiples of these to run capturing CREATE-only, FETCH-only, etc…
This one captures only Creates (da.Auditid = 1)
From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>Sent: Wednesday, September 12, 2018 1:27 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Re [EXTERNAL] - RE Live Report for last login of all active users
Re [EXTERNAL] - RE Live Report for last login of all active users
Posted bybshapiro@cassiacm.com (Shapiro, Ben) On 09/12/2018 02:26 PM
eLink : [EXTERNAL] - RE Live Report for last login of all active users On September 12, 2018 at 2:12 PM "eLink Entry: Content Server LiveReports Forum" <livereportsdiscussion@elinkkc.opentext.com> wrote: [EXTERNAL] - RE Live Report for last login of all active users Posted by colin.schmidt@cognizant.com (Schmidt, Colin) On 09/12/2018 02:12 PM That would involve two tables: KUAF and DAUDITNEW. select k.id, k.name, k.lastname+', '+k.firstnam e "Username",MAX(da.auditdate)from kuaf k join dauditnew daon k.id= da.useridand da.auditid= 23where k.type= 0and k.deleted= 0and k.id<> 1000groupby k.id, k.name, k.lastname+', '+k.firstname Colin J From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>Sent: Wednesday, September 12, 2018 12:39 PMTo: eLink Recipient <devnull@elinkkc.opentext.com>Subject: Live Report for last login of all active users Live Report for last login of all active users Posted bynikole.curkan@hrsdc-rhdcc.gc.ca (Curkan, Nikole) On 09/12/2018 01:36 PM Looking for the SQL to develop a liveReport to show all the active users and their last login date. Any help would be much appreciated![To post a comment, use the normal reply function]Forum: Content Server LiveReports ForumContent Server:My Support [To post a comment, use the normal reply function] Topic: Live Report for last login of all active usersForum: Content Server LiveReports ForumContent Server: My Support
eLink : [EXTERNAL] - RE Live Report for last login of all active users On September 12, 2018 at 2:12 PM "eLink Entry: Content Server LiveReports Forum" <livereportsdiscussion@elinkkc.opentext.com> wrote:
[EXTERNAL] - RE Live Report for last login of all active users
Posted by colin.schmidt@cognizant.com (Schmidt, Colin) On 09/12/2018 02:12 PM
select k.id, k.name, k.lastname+', '+k.firstnam e "Username",MAX(da.auditdate)
Topic:
