SQL Query to Generate Teamwork Project Access Report

General Questions/Discussions
1

Hi everybody,

I need to create an Excel/CSV report of all users’ access(Read only/Read and Commit) to all Teamwork projects. I could not find any option for this in the VP admin console or the application, so I think the only way is to retrieve it from the SQL Server database. I would appreciate it if you could provide me with a proper SQL query for this.

The template of the required report is as follows:

Project Name | User Name | User Email | Access Level

Thanks in advance.

2

Thank you for your inquiry and I’m sorry that at the moment we do not support report user access permission on projects. In fact we do not recommend user manually access to server database. We will not able to provide support to user in case they mess up the database. Feel free to contact me for nay questions.