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

Question

Question

Query for Forms

asked on June 3, 2022 Show version history

Is there a query in SQL that can pull named users and/or participants users to be used for forms?

0 0

Replies

replied on June 7, 2022

You can use this against the directory server DB

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'
			WHEN '75a3f535-2a75-3f02-e695-3f35178fe8aa' 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]

 

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

Sign in to reply to this post.