Question

LFDS User License Display Limitations

Directory Server Laserfiche

Updated April 24, 2020

asked on April 24, 2020

Hi All,

LFDS only seems to display 15 pages worth of user licenses, this user has more than 1500 licenses and you're unable to see the rest of the users without using the search function.

Basically, the user would like to export a list of all users from LFDS, however it seems you can only do this 100 at a time in LFDS 10.3.1.45. But they have then hit a further problem as the pages stop at 15 (1500 licenses).

Has this been fixed in a later version (this isn't something I can test for obvious reasons), or can you get this list from SQL?

Cheers!

1 0

Answer

SELECTED ANSWER

replied on April 24, 2020 • Show version history

Hi Chris,

You can retrieve this in SQL with the following query:

SELECT UserName = ([directory_objects].[name]),
		Email = (SELECT [str_val]
			FROM [additional_claims]
			WHERE [additional_claims].[claim_id] = 1
			AND [additional_claims].[sid] = [directory_objects].[sid]),
		LicenseType = (CASE [user_licenses].[type]
			WHEN '9bba0d89-9a13-455f-ada9-83cf071d46b9' THEN 'Full'
			WHEN '6e858768-cd5c-4e50-8fbe-aced7f67e25f' THEN 'Retrieval'
			WHEN 'dde75261-70e3-49f5-84bc-d8ef36f1aa56' THEN 'Participant'
			END),
		DisplayName = (SELECT [str_val]
			FROM [additional_claims]
			WHERE [additional_claims].[claim_id] = 12
			AND [additional_claims].[sid] = [directory_objects].[sid])
	FROM [directory_objects]
	INNER JOIN [user_licenses] ON [directory_objects].[sid]=[user_licenses].[sid]

This was modified from the posts in this thread.

1 0

replied on April 24, 2020

Thanks Jim,

That has done the trick.

This still should be fixed in LFDS however.

Cheers!

1 0

Replies

replied on April 24, 2020

Hi Chris, in LFDS 10.4.1 and newer the export user list button exports all users.

3 0

You are not allowed to follow up in this post.

Question

Question

LFDS User License Display Limitations

Answer

Replies

Sign in to reply to this post.