Question

In Progress Forms Tasks

Forms License Manager Administration Ideas How To

Updated September 5, 2023

asked on September 1, 2023

Is it possible to run some sort of report or get from SQL, to know who all "in progress" Forms tasks are assigned to? We're trying to clean up some dated Laserfiche User licenses, and wondering if there is an easy way to know if they are still in use without having to remove licenses and see if we hear from anyone.

Any guidance would be greatly appreciated.

Thanks!

0 0

Answer

SELECTED ANSWER

replied on September 3, 2023

Hi Bill,

You can create a custom report with following steps:

Add all business process that you want to include
Add "Status" and "Assigned to" variable to report
In filters, set "Status" equal to In progress

Then you will be able to see all in progress tasks and the user assigned to.

Hope it helps :)

0 0

replied on September 5, 2023

@████████

I appreciate your response!

Are you saying that I would need to do this for each process, or am I missing something where you could use reports to run this for all?

Thanks

1 0

replied on September 5, 2023

On the initial 'Edit Report' screen, at the top you can click a '+ Add' link to add additional processes that will pull into the report. That's what Yuxuan meant by the first bullet point.

1 0

replied on September 5, 2023

Awesome!! Thanks so much!

1 0

Replies

replied on September 5, 2023

I use this SQL query in a Stored Procedure to show me when a user last logged in a their license type.

	SELECT UserName = ([directory_objects].[name])
,[directory_objects].[sid]
	,eMail = (SELECT [str_val]
				FROM [additional_claims]
				WHERE [additional_claims].[claim_id] = 1
				AND [additional_claims].[sid] = [directory_objects].[sid])
  	,LicType = (CASE [user_licenses].[type]
				WHEN '9bba0d89-9a13-455f-ada9-83cf071d46b9' THEN 'Full'
				WHEN '6e858768-cd5c-4e50-8fbe-aced7f67e25f' THEN 'Retrieval'
				WHEN '510aa16b-1b84-4572-776a-0bea0bdee170' THEN 'Participant'
				END)
    ,DisplayName = (SELECT [str_val]
					FROM [additional_claims]
					WHERE [additional_claims].[claim_id] = 12
					AND [additional_claims].[sid] = [directory_objects].[sid])
	,LastLogin = (Select last_login FROM user_logins
  
  Where [user_logins].sid = [directory_objects].sid)
FROM [directory_objects]
INNER JOIN [user_licenses] ON [directory_objects].[sid]=[user_licenses].[sid]
Order by LastLogin asc

Run the query from your LF Directory Server database.

2 0

You are not allowed to follow up in this post.

Question

Question

In Progress Forms Tasks

Answer

Replies

Sign in to reply to this post.