Is it possible to query the Laserfiche databases and determine the number of licenses we own? I don't mean the number assigned, or the number in use. I need to know how many we've bought. For reporting purposes, it needs to come from a SQL query of the database.
If you ever need to know this, this is availble on the Laserfiche support site under your LSAP card details page.
You could probably get this information from the SQL database somewhere, but this will only be relevant/correct to the last activation.
In a nutshell, go to support.laserfiche.com, sign in (if you don't already have an account) or register if you need to. To find your serial number go to Help>About in the Laserfiche client, and you'll see it there. Then go to the top right and select company profile.
Hope this helps!
Assuming your current license info is loaded, you can access it from the Laserfiche Admin console. But I don't believe that this info is stored in the database.
You can run a query like this to find any column across all the tables/views in the database. This example is looking for any column with admin in the name.
SELECT COLUMN_NAME AS 'ColumnName' ,TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%admin%' ORDER BY TableName ,ColumnName;
I ran this query looking for admin, license, lic, named, and a few others - I'm not having any luck. Unless it is fairly cryptic in the naming of the column, I don't think it is there.
If you are using the Laserfiche Directory Server you can query the database for that information. One example is shown.
,'Total Users' = (Select Count(*)
From [Database_Name].[dbo].[directory_objects] DO
WHERE DO.type = 0
AND DO.container_id = [directory_objects].[id])
'Allocated Full User' = (Select Case
-- to account for seperate Master license
When [directory_objects].[name] = 'xxxxxx' Then 60
WHERE [container_limits].[resource_uuid]= '9bba0d89-9a13-455f-ada9-83cf071d46b9'
AND [container_limits].[id] = [directory_objects].[id]),0)