I have four top-level managers all wanting to know "How many people are using SalesLogix?". I can give them a count of all the CREATEUSER and MODIFYUSER fields, but that just shows who is adding or modifying. Some people just use SLX for reference and (claim that they) don't really add or change things. So I'd like to log how many times each user logs into SLX. I have a feeling that half of the people who have licenses assigned to them, don't open it for months.
I have full access to the Oracle database. So if there is DML that happens when they log in, I can write a db table trigger to insert into my logging table.
If there is already logging for that event, I don't know the table.
We have SLX LAN 8.0 and we're on an 11g Oracle db. |