Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: philchudley on January 10, 2017, 10:46:05 pm
-
Hi All
I have a need to collect and report on repository usage statistics in a multi-user repository with security enabled. For example, when users have connected, disconnected and their total connect time.
I believe EA does not capture this data within a repository.
One method would be to create an add-in that responds to the File_Open and File_Code broadcast events, and creates a log file which can the processed at some future stage.
Is there any method that does not use an add-in at all?
Cheers
Phil
-
Sure: database triggers
q.
-
Thanks qwerty will explore along those lines.
Phil
-
One method would be to create an add-in that responds to the File_Open and File_Code broadcast events, and creates a log file which can the processed at some future stage.
No. No! That's a BAD engineer! >:(
Uh, sorry. I mean to say: and logs these events in the operating system's logging facilities, for which there are already any number of processing tools which the customer may already have deployed.
Attaboy. MUCH better. :)
Is there any method that does not use an add-in at all?
The only thing I can see would be to hook into the DBMS instead of the client. What you can get out of that of course depends on the specific product you're using, but basic connection logs should be pretty easy to obtain.
/Uffe
-
Hi Phil,
Hope your well; one thing to consider re db triggers is the user account used to connect to a db. Some of my clients have DBA policies that don't allow direct database connection by individual users. In these situations you create a 'service' account which connects to the db. These account details are then imbedded/encrypted in the sparx connection string. In this scenario the db trigger would not be able to tell you/record the actual user connecting. So your first option would be more generally applicable. Although again in a corporate env you may well find access/security issues associated with writing to event logs.
Also as an aside the cloud service can I think be configured to log which users are connecting / disconnecting - so simple solution might be to install it and insist all users connect via the cloud url ?
Regards,
Jon.
-
Hi
In our environment a File keystoreService.config exists. With LOG_LEVEL=INFO EA creates a File with all CheckIns, CheckOuts and available keys.
Rudi
-
The keystore service logfiles only show if licenses have been checke-out, -in etc.
They do not show which models have been opened, closed etc.
So this is not a solution for Phil :(.