Trend and Usage Reporting

Hello,I would appreciate any information related to User statistic reports. Specifically, I would like to be able to run separate reports to show concurrent logins, peak usage hours, disk space usage (overall, not necessarily by user), etc... Does anyone have any documentation or advice for this type of LiveReport? Please note that I am looking for something within LL rather than at the server level if possible. Thanks in advance for your feedback.Regards!

Find more posts tagged with

Comments

Pfizer_Developers

Contact your Sales Rep and inquire about the Performance Analyzer. Quite a nice product and can get you what your looking for.

OSHA_ICT_team_member_1_(oshauser1_-_(deleted))

But Livelink Performance Analyzer only covers system performance, not usage statistics. I guess and I'm afraid livelink usage stats can be obtained through livereports only ... I've also tried it with Webtrend but it has some limits. Susann, attached a few livereports, check also KC discussion forum on Livereports. I'm also interested by such facilities, and still look forward a truly more professionnal solution than individual, basic livereport to get usage info. Opentext, please make an effort, how do you want us/customers to monitor the usage of our livelink system without basic and out-of-the-box statistics tools ?

Susan_Nare_(sglcuser16a_-_(deleted))

Thank you both for your feedback. I checked out both the Performance Analyzer as well as the reports provided by Lila, but neither one seem to fulfill my requirement to report on the number of concurrent logins. Can anyone provide any guidance on a report specific to the number of people logged into active sessions of LiveLink at any given time? That is the primary data I am in need of, but would also appreciate anything related to peak usage times and/or usage trends in addition.Thanks again.

volvostephen

Message from via eLinkTo be able to do this, you will first need to define what 'concurrentlogins' is. Livelink doesn't keep track of this - it only audits. Your webserver might be able to track this if you wanted to look there...not sure.In any case, I would suggest something like - Count of distinct userID's indaudit over the last 20 minutes... So take the current time and do a selectcount (userID) from daudit where (auditdate minus 20 minutes (not sure ofthe SQL for this)) group by userID.Make sense? There is no logout. There is nothing to say that all usersreturned in this query are actively on the system. In truth, a session onlylasts for the duration of the livelink call (2 seconds). To know if usersare on the system I use the admin.threadstatus. I refresh that page severaltimes over a few minutes to see if any users show up for the LastApplication Context row. If not, I know no users are on the system.I hope this helps. Post back what you think a session should be defined asand I can try to help further.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: October 8, 2004 5:07 PMTo: eLink RecipientSubject: Trend and Usage ReportingTrend and Usage ReportingPosted by Nare, Susan on 10/08/2004 04:58 PMThank you both for your feedback. I checked out both the Performance Analyzer as well as the reports providedby Lila, but neither one seem to fulfill my requirement to report on thenumber of concurrent logins. Can anyone provide any guidance on a reportspecific to the number of people logged into active sessions of LiveLink atany given time? That is the primary data I am in need of, but would alsoappreciate anything related to peak usage times and/or usage trends inaddition.Thanks again.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Trend and Usage Reportinghttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3700159&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

volvostephen

aberztest1_-_(deleted)

Concurrent Logins could be approximated by querying the audit log over a period of time. For best results the time should be consistent with your web server¿s timeout. While some users may have dropped off it should be close. This example uses 10 min. All examples were written for Oracle.SELECT count(distinct(userid))FROM daudit WHERE auditdate > sysdate ¿ .0069You could also list the active users by running the following:SELECT distinct(name), lastname, firstnameFROM kuaf, daudit WHERE userid = id and auditdate > sysdate - .0069To determine the peak hour usage I use the following sql statement. This however does not capture any browsing, only functions captured in the audit log. But it gives a good baseline. This sample is for the previous 30 days. I generally like to convert the results to percentages of the total.SELECT to_char(auditdate,'HH24'), Count(event) FROM daudit WHERE daudit.AUDITDATE> sysdate -30 GROUP BY to_char(auditdate,'HH24') ORDER BY to_char(auditdate,'HH24')There are many ways to display disk space usage. If you want storage usage results you could try the following, results are in MB:select to_char(vermdate,'MON-YYYY'), Sum(datasize/1024000), to_char(vermdate,'YYYY-MM') FROM dversdata WHERE vercdate > sysdate - 365GROUP BY to_char(vermdate,'MON-YYYY'), to_char(vermdate,'YYYY-MM') ORDER BY to_char(vermdate,'YYYY-MM')Hope these help.

Nicole_Bride

Does anyone know what these statements would be in SQL? I am not very familiar with Oracle or SQL...Thank you in advance.