Need to determine all security administrators for all projects
As a Security Administrator, I do not have visibility into several projects. Via the database, what is the query to view all security administrators for all projects?
Forum Discussion
2 Replies
- SmartBear support replied: YTou should be able to run the Administrative report for Projects Security:
http://screencast.com/t/7MovZRs0Tr - The 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
