You are viewing limited content. For full access, please sign in.

Question

Question

Licence allocation date in SQL

asked on January 27, 2022

I have a request from a customer that wants to know how to identify Laserfiche accounts that have been assigned a licence but never logged onto Laserfiche after 90 days.

I am able to determine the accounts which never logged on by doing a SQL query and finding the accounts not in the user_logins table, however I am not able to find a creation date to determine when the licence was allocated to identifies those accounts that never logged on but was assigned a licence more than 90 days ago.

0 0

Replies

replied on January 27, 2022

Hi David,

What is the actual end goal of having this information? Do they want to reclaim licenses from users who haven't accessed Laserfiche in the last 90 days?

As phrased, this sounds like a potential X Y Problem.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.