Query to pull number of Actve Users

Matthew_Smith

Hi all,

My LiveReport container (on our LL 9.7.1 instance, running under Oracle 10g) has a number of reports regarding unique logins, active users, etc. The problem is the numbers don't seem consistent.

What I'm really looking for is a query that will pull a list of unique users that have logged in to the system in the past x days.

Does anyone have one available?

 

Thanks!

Matt

Colin_Schmidt

If all you want is their names, you can do that with "select distinct ....blah, blah".  If you want the count, that would be done with something like the following:

select da.performerid, k.name, count(*) 

from dauditnew da

join kuaf k on da.performerid = k.id

where da.auditid = 23 and to_char(da.auditdate, 'yyyy-mm') = '2013-10'

group by da.performerid, k.name

order by k.name

There are variations depending on whether you want the counts per day or month or no counts at all.

Colin J. 

On Wed, Oct 16, 2013 at 10:16 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Query to pull number of Actve Users

Posted bymattsmith@blackberry.com (Smith, Matthew)On 10-16-2013 10:14

Hi all, My LiveReport container (on our LL 9.7.1 instance, running under Oracle 10g) has a number of reports regarding unique logins, active users, etc. The problem is the numbers don't seem consistent. What I'm really looking for is a query that will pull a list of unique users that have logged in to the system in the past x days. Does anyone have one available?   Thanks! Matt

---

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

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.