Service Desk Practitioners Forum
cancel

User Usage report

Highlighted
David_999
Respected Contributor.

User Usage report

Hello All

In SD 4.5 the enhanced audit provided a simple report to showing when a user had logged on and off of SD. Is there a similar feature in version 5.1?


Thanks
2 REPLIES
-=R=-
Outstanding Contributor.

Re: User Usage report

Don't know about anyone else, but Enhanced Auditing feature is one of many we were commanded to shut off as it caused performance and stability issues.

Hope you get a better solution than we did.
AndrewB
Super Contributor.

Re: User Usage report

Hi David,

Every time someone logs in (or out) a record is created (or deleted) in the ovsd.rep_sessions table. So as to monitor license usage we set up a sql job that extracts the data usgin the SQL listed below.

I also found info in the on-line help with the heading: Audit Log-in Attempts.

Good luck...Andrew

-------------------------------------------
SELECT
getdate(),
a.acc_nameduser,
a.acc_concurrentuser,
a.acc_showname, -- SD account name
p.per_primaryemailaddress, --SD person email
s.ses_client_ipaddress --logon user computer ip
FROM
ovsd.rep_accounts a, --Table with information about accounts in SD
ovsd.cdm_persons p, --Table with information about persons in SD
ovsd.rep_sessions s --Table with information about current logon users
WHERE
( a.acc_oid=p.per_acc_oid ) --connection between account and person
AND ( a.acc_oid=s.ses_acc_oid ) --connection between account and current logon
order by
a.acc_nameduser desc,
a.acc_concurrentuser asc,
a.acc_showname

-------------------------------------------