Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Monitor Logon information in Hp-openview serice desk

Highlighted
jeeno
Acclaimed Contributor

Monitor Logon information in Hp-openview serice desk


Monitor Logon information in Hp-openview serice desk

can get a daily report of how many of sessions for eash each account in service desk

version 4.5
3 REPLIES
The Pike
Honored Contributor

Re: Monitor Logon information in Hp-openview serice desk

Enhanced Auditing can be configured to record session login/logout.

To create a daily report, I would use an external application -such as Crystal Reports- and retrieve the information from the Views for Reporting in the SD database.

Do not forget to assign points for the guidance. Here's how:

http://forums11.itrc.hp.com/service/forums/helptips.do?#33

The Pike
Meine de Vries
Regular Collector

Re: Monitor Logon information in Hp-openview serice desk

Yes I would believe so.

First you would have to log every logon/logoff to the service desk application which can be done by:

Tools â System â Security â Enhanced Auditing â Configuration â (Expand) Security â Check 'Logged on Users'.

This will create entries in the enhanced log 'file' every time a user logs on/off from the system.

Next you will have to query the database view SERVICEDESKREPO.V1033_AUDIT_LOG table with some query tool like Crystal reports to extract the info you need.

Note: The 'V1033' part of the view name may be different on your system depending on the language code(s) used in your environment.

Meine

Oleg Shilovskiy
Super Collector

Re: Monitor Logon information in Hp-openview serice desk

I hava table
USE [ServiceDesk]
GO
/****** Object: Table [dbo].[sys_session_account] Script Date: 02/03/2010 10:10:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_session_account](
[SSA_OID] [decimal](18, 0) IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[SSA_SES_OID] [decimal](18, 0) NOT NULL,
[SSA_ACC_OID] [decimal](18, 0) NOT NULL,
[SSA_CREATED] [datetime] NOT NULL,
[SSA_CLIENT_IPADDRESS] [nvarchar](255) NULL,
[SSA_CLIENT_IPPORT] [decimal](9, 0) NULL,
[SSA_THREADNAME] [nvarchar](255) NULL,
[SSA_DELETED] [datetime] NULL,
CONSTRAINT [PK_sys_session_account] PRIMARY KEY CLUSTERED
(
[SSA_OID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 85) ON [PRIMARY]
) ON [PRIMARY]


AND trigger on table
CREATE TRIGGER SSA_DELETE ON [dbo].[REP_SESSIONS]
AFTER DELETE
AS
declare
@oid decimal(18, 0)
,@created datetime

declare c cursor for
select SES_OID, SES_CREATED from deleted
open c

fetch next from c into @oid, @created
while (@@fetch_status<>-1)
begin
IF (@@fetch_status <> -2)
begin
update sys_session_account set SSA_DELETED=GETUTCDATE()
where (sys_session_account.SSA_SES_OID=@oid and sys_session_account.SSA_CREATED=@created)
end
fetch next from c into @oid, @created
end

close c
deallocate c

CREATE TRIGGER SSA_INSERT ON [dbo].[REP_SESSIONS]
AFTER INSERT
AS
declare
@oid decimal(18, 0)
,@created datetime
,@acc_oid decimal (18, 0)
,@ipaddress nvarchar (225)
,@ipport decimal (9,0)
,@threadname nvarchar (225)

declare c cursor for
select SES_OID, SES_CREATED, SES_ACC_OID,
ses_client_ipaddress, ses_client_ipport, ses_threadname
from inserted
open c

fetch next from c into @oid, @created, @acc_oid, @ipaddress, @ipport, @threadname
while (@@fetch_status<>-1)
begin
IF (@@fetch_status <> -2)
begin
if (@acc_oid<>281481121761338)
insert sys_session_account values(@oid, @acc_oid, @created, @ipaddress, @ipport, @threadname, null)
end
fetch next from c into @oid, @created, @acc_oid, @ipaddress, @ipport, @threadname
end

close c
deallocate c

GO

WHERE acc_oid<>281481121761338 - system user

//Add this to "OnDomLoad" event