Number of total logins

Birger_Jacobsen_(danskadmin_-_(deleted))

HelpI´m trying to make a report for statistik use I need to now how many logins has been logged in for a given periodFollowing show me that Admin only has logged in 23 timefor the last 2 yearsselect COUNT (b.event) from kuaf a, daudit b where b.event = 'LOGIN' AND a.id = b.userid AND deleted = 0 AND group by a.nameThanks for help

Find more posts tagged with

Comments

eLink User

Message from Sean M Alderman via eLinkThis is the report we use, as far as we can tell it's accurate. %1 and%2 are user inputted dates.SELECT Count(a.USERID) "Logins", b.firstname || ' ' || b.lastname "Name", b.mailaddress "eMail", b.name "Username", Max(a.auditdate) "Last Acess" FROM DAUDIT a, KUAF b WHERE a.EVENT = 'LOGIN' AND a.USERID = b.ID AND to_char(a.AUDITDATE,'yyyy mm dd') Between to_char(%1,'yyyy mm dd') and to_char(%2,'yyyy mm dd') GROUP BY a.USERID, b.firstname, b.lastname, b.mailaddress, b.name ORDER BY Count(a.USERID) DESC, b.lastname, b.firstnameOn Wed, 2002-11-13 at 10:15, eLink Discussion: Livelink LiveReportsDiscussion wrote:> Number of total logins> Posted by DanskAdmin on 11/13/2002 10:06 AM> > Help> > I´m trying to make a report for statistik use I need to now > how many logins has been logged in for a given period> Following show me that Admin only has logged in 23 time> for the last 2 years> > select COUNT (b.event) from kuaf a, daudit b where b.event = 'LOGIN' AND a.id = b.userid AND deleted = 0 AND group by a.name> > Thanks for help> > [To reply to this thread, use your normal e-mail reply function.]> > ============================================================> > Discussion: Livelink LiveReports Discussion> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view> > Livelink Server:> https://knowledge.opentext.com/knowledge/livelink.exe> > -- Sean M. AldermanITRACK Systems AnalystPACE/NCI - NASA Glenn Research Center(216) 433-2795Calling a windowed operating system "Windows" is like naming anautomobile "Wheels."

Jeff_Morris

I'm finding that I need to limit the timeframe for this because it is so large. I would really like to keep a longer history on who is viewing what and who is logging in but realistically the DAudit table grows drastically. Am I missing something here? How are you accomplishing keeping 2 years worth of history/audit?I would like to have Auditing based on areas within the Livelink workspace versus system wide and then another option when purging to just keep the 'latest' view for example. This is something I know can be developed but I haven't gotten that far. I've asked for feature enhancement on the Auditing.Thanks for your input.

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

My understanding is that you need to purge the file ??Why ??Performance reason ?Space reason ?When you say to large ? How large is it 10 Mbyte , 100 Mbyte , 1 Gbyte, 10 Gbyte Regardsmagnus@ids.seID Application

Jeff_Morris

I don't have the size off hand. We export the database nightly for back up and the larger this table the longer it takes to export. During this export process, we turn off the LL services; our goal is to limit the down time.

Magnus_Salgo_(IDNordicAdmin_(Delete)_2300172)

Just some small thoughtsCheck size of the db and the tables. Depends of databaseit can maybe be "compressed"Don't export the audit table everynight ??Move the Daudit to a Daudit history db and purge the "active Daudit" --> when you report you use the Daudit histor db to get the historical usageof your site ..See also threadhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2275671&objAction=view