I am looking for a LiveReport that would show all current users. Livelink 9.7.1 and Oracle database.
I do not need all current users logged in; I need a list of all users in the system.
Thanks!
If you are looking for a total count of all users who have accounts in Content Server simply run a Lite SysReport. This report gives you a count of total users, those who have login disabled, etc.
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, March 08, 2012 11:07 AMTo: eLink RecipientSubject: LiveReport to list All Users
LiveReport to list All Users
Posted bykaren.morley@goodrich.com (Morley, Karen) On 03-08-2012 10:54
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
select ID, Name, LastName, Firstname, UserPrivileges from kuaf where name not like '%%(delete)%%' AND UserPrivileges not like '%%NULL%%' order by UserPrivileges, LastName
UserPrivileges relates to the check boxes they have check in their accounts in Livelink.
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Thursday, March 08, 2012 11:08 AMTo: eLink RecipientSubject: LiveReport to list All Users
I'm interested in addition to what this query does, would also like for it to be able to filter by date. For example, list WHO the users are (not just the count), for the last month, year, or range of dates options. End goal being to tell me who my current and active users are, for a specified range of dates. CS10 already has the user logon date range capability but it only considers the number, not the who.
Anyone here able to run this? Thanks in advance!
this was already covered here:
https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=7693001&objAction=viewincontainer&ViewTopicsByReply
While some have been able to run it, I'm still trying to get it to work..
