07 October 2008
Support   »   Forums  
Forums

Search our forums for the answers to your questions.

Further support options include the FAQs and Knowledge Base.

Note - Please login if you want to post to the forums.
CELCAT Timetabler Forums
Forums > Installation & Configuration > Timetabler Server
Subject: User Access
Prev Next
You are not authorized to post a reply.

AuthorMessages
creilly81User is Offline

Posts:6

16 Jun 2008 9:35 AM  

Good Morning,

Is there any way you can you track user access within Celcat 6.3 from an auditable point of view?

We are going to create multiple user logins, and want to be able to track how regularly each user log's in and for how long.

Is this possible?

Kind Regards

Chris Reilly

 

C.Reilly
ChrisUser is Offline

Posts:4

16 Jun 2008 2:30 PM  
Hi there,

This is certainly possible! You can see who's logged into a timetable using "Current Users" menu via CELCAT Administrator. Also, you can use Log Viewer which is a means of examining user activity in a timetable database (see Timetables menu | Utilities | Log Viewer). As users add, remove & modify records, a log is kept of all such operations indicating what changes were made, who made them and when.

Regards
CELCAT Technical
creilly81User is Offline

Posts:6

16 Jun 2008 3:09 PM  

Hi,

Thanks for getting back to me.

Could you also track user activity if they have only been set view only access?

We want all Curriculum staff to be able to check their timetables/utilisation and also be able to print,  but not actually be able to amend the data. Can we still track them?

Kind Regards

Chris

C.Reilly
SupportUser is Offline

Posts:36

16 Jun 2008 4:17 PM  
Timetabler will log changes or modifications to records/timetables ie updates, deletes, export, verify/backup however these are restricted users anyway, so they cannot affect the database in any great way. Log viewer will track viewer users logging into & out of a database, but it cannot trace or log browsing or simply viewing data. However, users with view access will still be able to print their timetables.

Regards
CELCAT Technical
APCUser is Offline

Posts:9

16 Jun 2008 5:24 PM  
CT_LOG is the table that stores this info. The rows you'll be interested in are those with 'operation' values 103 (for Login) and 104 (for Logout). Also the user_id, agent and date_time_change columns are relevant. Here's some sample SQL that lists all logins and logouts for a timetable database:

select user_id,
case operation
when 103 then 'Login'
when 104 then 'Logout'
end as op,
date_time_change, agent from CT_LOG where (operation = 103 or operation = 104) and name is null
order by date_time_change asc

One thing to note is that sometimes a user will login but never logout (e.g. when the PC crashes or they forget to logout of a web session). In your calculation of stats you'll need to match each login with a logout (and if you can't match it either ignore it or make an estimate of login time). BTW, 'agent' in the above SQL refers to the application that the user logs into (A = Administrator, W = Web, C = Client)

As always let us know if you need more help.

Rgds
CELCAT
creilly81User is Offline

Posts:6

18 Jun 2008 9:32 AM  

Good morning,

I have another question!

We have a current generic login for all staff set-up for view only access for both Windows Client and Web versions of Celcat 6.3.

Can we disable that login for the Windows version, but at the same time keep it active for the Web based version?

Kind Regards

Chris

C.Reilly
APCUser is Offline

Posts:9

19 Jun 2008 8:50 AM  
The only way to do this that I know of is by adding a bespoke trigger to the CT_LOG table, thus:

CREATE TRIGGER [dbo].[MY_SPECIAL_LOG_TRIGGER]
ON [dbo].[CT_LOG] FOR INSERT AS
SET NOCOUNT ON
BEGIN
if exists (select * from inserted where user_id=1 and agent='C')
BEGIN
RAISERROR('Cannot login to Windows Client - please use web', 16, 1)
ROLLBACK TRANSACTION
END
END


You must substitute the id of your generic login above where it reads "user_id=1"

I can't see any difficulties with this, but as always please proceed at your own risk

Rgds
CELCAT
APCUser is Offline

Posts:9

19 Jun 2008 8:53 AM  
Oh, and run in a test environment first
You are not authorized to post a reply.
Forums > Installation & Configuration > Timetabler Server > User Access



ActiveForums 3.7

Privacy Statement  |  Terms Of Use
Copyright © 2008 CELCAT, All Rights Reserved