Question

Named users list

Laserfiche

Updated June 13, 2017

asked on June 12, 2017 • Show version history

I need to retrieve from the database the list of trustees that have a named user license assigned to them.

I cant find that column in any table on the database.

Any help is appreciated.

0 0

Replies

replied on June 12, 2017 • Show version history

I don't think information is stored in the repository database. In this post they reference a "named user database" found on the app server specifically for named user licenses.

However, I think there are better ways to get a list of named users. In Rio, The "accounts" section of the LFDS page allows you to filter based on the type of license, and there is an "export list" button.

The admin console for the repository (or repositories) also includes a column for license type, list export options, and a custom view/filter so you can look for specific license types.

Depending on whether you're using Rio or Avante, and if you're dealing with Directory Named Users or Repository Named users, you might have to look in a few places.

This help page might be useful too.

0 0

replied on June 13, 2017

We pull this information from our Forms db, in the cf_users table.
You can also use the directory server database ( we are on avante so not avaliable to us )

See this post: https://answers.laserfiche.com/questions/117487/Directory-Server-database

SELECT TOP 1000 [username]
      ,[email]     
      ,LicType =(CASE user_type
	  when 0 then 'repository user' 
	  when 1 then 'named user'
	  when 2 then 'unknown'
	  when 3 then 'partcipant'
	  when 4 then 'participant'
	  ELSE NULL
	  END)
      ,[is_lfadmin]
      ,[user_id]
      ,[displayname]
      ,[is_activated]
  FROM [LFForms].[dbo].[cf_users]
  where is_activated = 1

0 0

You are not allowed to follow up in this post.

Question

Question

Named users list

Replies

Sign in to reply to this post.