How to Find out who created a Project

[c5thunder]

Im trying to figure out which of our Admins created a project in Fortress and what date it was created. Where can i pull this info out of?

thanks.

[mskrobul]

This information isn't displayed anywhere, but the project creator's user id and the creation time are both stored in the projects table in the sgdragnet database.

I am not one of the SQL experts, but I think this query *should* work to get the basic information you need.

Code: Select all

use sgdragnet
go
select p.name AS projectname, p.created, p.creatoruid, u.login from dbo.projects p 
INNER JOIN  [sgmaster].dbo.users u 
ON p.creatoruid = u.userid

If you want to see specific projects instead of all projects, here's one example:

Code: Select all

use sgdragnet
go
select p.name AS projectname, p.created, p.creatoruid, u.login from dbo.projects p 
INNER JOIN  [sgmaster].dbo.users u 
ON p.creatoruid = u.userid
WHERE p.name IN (comma separated list of single-quoted project names)

[c5thunder]

Great! That's exactly what I needed. Thanks for your help.