User permissions report

Is there a 'User Permissions' or 'User Group Membership' report available from the app or admin station? 

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

Additionally I found this particular thread:

https://docuware.uservoice.com/forums/230572-configuration-english/suggestions/11615754-creating-reports-in-docuware-administration

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.



 

Thanks, Guys. I'll ask the DBA to save this query. I know the auditors will want us to provide this data occasionally.
 

StapleWare Audit might be another alternative.

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?