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; } } }

User login count

Mikel_Aanstoot_(frieslandadmin_-_(deleted))

I know there is some information here about my question but for some reason I can't get it to work. So my question: Has anybody has a working Livereport based on Livelink 9.5 SP1 and MS SQL 2000 that will provide me unique login counts per day between a certain period. I don't want to know the users, only the amount of unique loginIt would be most helpfull if I only need to import the specific livereport.Thanks, appreciate all the helpMike

Find more posts tagged with

Comments

Steve_McDonough

Try this report. It has a selection for starting and ending date and provides only counts of unique logins for each date.Inputs: Date Enter Starting Date Date Enter Ending DateSQL:SELECT convert(char(10),AuditDate,110) "Audit Date",count(DISTINCT(PerformerID)) "Number of Users" FROM DAuditNew WHERE AuditDate <= %2 AND AuditDate >= %1 GROUP BY convert(char(10),AuditDate,110)Params: User Input 1 (%1) User Input 2 (%2)Format: Auto LiveReportLeon

Janusz_Frydecki

And this implies that users login is audited

Mikel_Aanstoot_(frieslandadmin_-_(deleted))

Hi Leon,worked pefect. Thanks very much for thisMike

Mikel_Aanstoot_(frieslandadmin_-_(deleted))

It was bound to happen.... After I gave the user login facts they wanted to know who those persons where. Anyone can help me with that question ? So of those x unique userlogons I like to see who those persons are.Thanks for any help on this !Mike

Steve_McDonough

Try this report. It has a selection for starting and ending date and provides only counts of unique logins for each user within a date period.Inputs: Date Enter Starting DateDate Enter Ending DateSQL:Select a.LastName+', '+a.firstname "User Name", a.name "Login", max(b.auditdate) "Last Login", count(b.auditdate) "Logins This Period" From kuaf a, dauditnew b Where b.auditstr='LOGIN' AND a.id=b.performerid AND a.deleted=0 AND b.auditdate >= %1 and b.auditdate <= %2 Group by a.lastname, a.firstname, a.name Order by "User Name" ascParams: User Input 1 (%1)User Input 2 (%2)Format: Auto LiveReport

Mikel_Aanstoot_(frieslandadmin_-_(deleted))

Perfect ! Thanks very much !Regards,Mike

Amanda_Rose

Your reports are great in that they run quickly and return results... but I have a question about WHAT EXACTLY they are auditing. We have two systems that share a userbase, but each user would have a regional system where they do most of their Livelink work. When I run these reports in one system, some of the greatest number of "logins" come from users who I KNOW use the other system. I don't understand what is being counted as a "login" event. Can anyone clarify this for me?

Lindsay_Davies

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Hi Amanda

By regional system, do you mean you have Remote Cache servers installed?

These all use the same database, which is the single place where the audits are stored.

Therefore you are looking at the system as a whole and will see events across the system as a whole.

Refer to my response to Josephinefor a more robust query.

It could be adjusted to determine the number of distinct users per day and/or report over a given period.

Regards

Lindsay

Lindsay Davies

EU Escalation Team

OpenText UK

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2012 March 30, Fri 00:18
To: eLink Recipient
Subject: RE It was bound to happen - Count of user logins

RE It was bound to happen - Count of user logins

Posted by amanda.rose@res-ltd.com (Rose, Amanda) On 03-29-2012 19:06

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

Colin_Schmidt

This ORACLE SQL tallies the selected Activity per hour per User. It'll give you an idea of the number of times certain activities are performed daily across 24 hours. I found it in the KC last year.

HourlyActivity.sql

Amanda_Rose

Colin - thanks, I will see if we can tweak this for MS SQL and get some useful information.