Forum Discussion
- SwoopFrequent ContributorSmartBear support replied: YTou should be able to run the Administrative report for Projects Security:
http://screencast.com/t/7MovZRs0Tr - SwoopFrequent ContributorThe reply from support didnt provide me with what I requested, so I came up with this query, which seemed to do the trick. (22427 was what SecurityAdmin evaluated to in the SecurityGroups table)
SELECT Persons.FirstName + ' ' + Persons.LastName AS SecurityAdmin, Projects.ProjName
FROM PersonSecurityGroups, Projects, Persons
WHERE SecurityGroupId=22427
AND PersonSecurityGroups.ProjId=Projects.ProjId
AND PersonSecurityGroups.UserId=Persons.UserId
ORDER BY ProjName ASC
Related Content
- 12 years ago
- 3 years ago