Publicado Wed, 27 Jan 2021 19:36:17 GMT por Mark Massey Cornerstone Building Brands
Is there a 'User Permissions' or 'User Group Membership' report available from the app or admin station? 
Publicado Tue, 02 Mar 2021 13:54:20 GMT por Toby Gilbertson Pacific Solutions International Ltd Customer Services Manager
Hi Mark.

I believe there is not such a report (as yet) in DocuWare from my research into this. The closest you get is in audit reports (provided you have "User Login/Logout" tracked) in the Organization Report which would show active users and their activities but it is not a full user access audit by any means.

Have you searched through https://docuware.uservoice.com/ and added your vote to any submitted features around user reporting? I am currently hunting for similar user audit suggestions.

Otherwise, you could probably put something together using SQL to generate a report out to Excel (I know that doesn't really help unless either you know SQL or have a tame DBA to hand!)

Sorry if any of this is stuff you have already tried / know but thought it worth a mention.

Toby
Publicado Tue, 02 Mar 2021 14:00:29 GMT por Toby Gilbertson Pacific Solutions International Ltd Customer Services Manager
Additionally I found this particular thread:

https://docuware.uservoice.com/forums/230572-configuration-english/suggestions/11615754-creating-reports-in-docuware-administration
Publicado Tue, 09 Mar 2021 15:10:07 GMT por Antoine Wassouf ITEC Image Technologies Technical Project Leader
Unfortunately until now, this feature is not available in DocuWare, anyway you can generate a report to show 'User Group/Role Membership' using SQL query as follows:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT * FROM 
 (
 SELECT dbo.dwuser.name as UserName,dbo.dwroles.name as RoleName,'' as GroupName FROM dwsystem.dbo.DWUser inner join dwsystem.dbo.DWUserToRole on dwuser.uid=dwusertorole.uid inner join dwsystem.dbo.DWRoles on dwroles.rid=dwusertorole.rid
 UNION
 SELECT dbo.DWUser.name as UserName,dbo.DWRoles.name as RoleName,dbo.DWGroup.name as GroupName FROM dwsystem.dbo.DWUser inner join dwsystem.dbo.DWUserToGroup on dwuser.uid=dwusertogroup.uid inner join dwsystem.dbo.DWGroupToRole on dwgrouptorole.gid=dwusertogroup.gid inner join dwsystem.dbo.DWRoles on dwroles.rid=dwgrouptorole.rid inner join dwsystem.dbo.DWGroup on dwgrouptorole.gid= dwgroup.gid
 ) Userroles ORDER BY username,RoleName
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Note: File cabinet profile can also be added to the above query.



 
Publicado Tue, 09 Mar 2021 20:56:29 GMT por Mark Massey Cornerstone Building Brands
Thanks, Guys. I'll ask the DBA to save this query. I know the auditors will want us to provide this data occasionally.
 
Publicado Tue, 09 Mar 2021 21:23:19 GMT por Jon Neff Kelley Imaging Solutions Engineer
StapleWare Audit might be another alternative.
Publicado Thu, 22 Apr 2021 23:10:07 GMT por Jon Weston File IT Solutions Sr Application Developer, RIM specialist
I'm taking on learning SQL Server Reporting Services (SSRS) so I can build custom reports.  Does anyone have any .rdl reports they've built that they wouldn't mind sharing?

You must be signed in to post in this forum.