Monthly trends (line chart) No. users created vs. actual usage

Kourosh_Entekhabi_(kentekhabi_-_(deleted))

Hi,I need to create an analysis showing several trends.Line 1: users created by monthLine 2: logins >= 1 by monthLine 3: logins >= 10 by monthThis will help us to analyse if money spent on licenses has been well spent, and help us to project into the future should additional licenses be justified.However... I can't seem to find any field that tells me the date a user account was created. Can anyone help?cheers,-jg

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Kourosh,Livelink uses the DAudit table to audit user events on DTree objects.As you have seen, creating User accounts is not audited.I would be tempted to select the createdate for the personal workspaceof the user.That is, something based on the following...Select dataid,name,createdate from dtree where dataid in (select id fromkuaf where type = 0 and deleted = 0);Hope this helps.RegardsLindsayUK-Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 16 June 2005 15:13To: eLink RecipientSubject: Monthly trends (line chart) No. users created vs. actual usageMonthly trends (line chart) No. users created vs. actual usage Posted byEntekhabi, Kourosh on 06/16/2005 10:10 AMHi,I need to create an analysis showing several trends.Line 1: users created by monthLine 2: logins >= 1 by monthLine 3: logins >= 10 by monthThis will help us to analyse if money spent on licenses has been wellspent, and help us to project into the future should additional licensesbe justified.However... I can't seem to find any field that tells me the date a useraccount was created. Can anyone help?cheers,-jg[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe