We have a client who wants to know who had licenses applied to them previously. Their Laserfiche administrator left and there have been some difficulties with sorting out licensing. Is there a way to do this in audit trail or SQL?
Discussion
Discussion
When reading your post, are you looking to see who were your named users?
That would be a piece of the puzzle but we also need to know who the licenses were applied to
I am sorry I don't have access to a useful Audit Trail for this. But those things should be logged.
The two fields you will be looking at is the "Accounts/Created Trustee" and "Accounts/Modified Trustee". The columns you need are "Is user?" and "IS Read Only?".
"Is User?" = named only user
"Is Read Only? = read only user
The hard part will be loading everything you need into Audit Trail to go back long enough to be useful (i.e. to the beginning). If your repository has been a busy one you will have quite a few audit logs in your respository. Changing your dates to include a date range that includes all of this could make your db very laaaaaaaaarge.
If this is the case, it might be useful to copy all of the older audit logs over to another machine, install sql server express on that machine along with audit trail and then use the directory you placed the logs in as the config location instead of your repository. It won't have the latest information but you can add that yourself with a normal query on your current system through the date the current audit file was created. This way you won't hammer your production system.
The "Is User?" column actually doesn't have anything to do with whether or not the trustee is a named user (unfortunately); it merely distinguishes users from groups (which both come under the umbrella of "trustee" in the event type).
Ugh. Is there anyway to tell if they were assigned a license (to answer Ben's question?)
I thought that's what it was.
HI Andrew.
Is there a SQL table that would have this information so we could use workflow to query?
To my knowledge, named-user information is not stored in the repository database at all. In Avante systems, the server keeps track of who is currently a named user, but if you wanted that information you could get that through the admin console (and so I assume that it doesn't solve your problem).
Could you get close-enough information by, for example, looking in the audit log for login events and seeing when each user most recently logged in, since they must have had a license somehow at that point?
Sign in to reply to this post.
- Posted April 15, 2016
- Updated April 20, 2016
- 164 views