Is there an easy way to determine who created a Project?

I've searched through the DXL help files for "Project" and "Created" and several other possible keywords, and also searched the DXL forum here, but I can't seem to find a solution to this. Basically, I have a couple of projects in DOORS that have the same name, but are in different locations. One is at the level of the rest of the projects in our database and the other is tucked in a folder inside another project. I just want to be able to email the person who created this "duplicate" project and make sure it's OK to delete it - or at least introduce him to the other project.
I can't find any list of attributes associated with a project, such that I could write a DXL script to locate "Project...CreatedBy" (I know this attribute doesn't exist, but I'm wondering how this might be done otherwise using DXL).

Chris AnnalSW Test Engineer / DOORS Database AdministratorSensis Corporation, East Syracuse, New Yorkchrisa@sensis.com
ChrisAnnal - Wed Mar 09 16:10:14 EST 2011

Re: Is there an easy way to determine who created a Project?
llandale - Wed Mar 09 17:21:09 EST 2011

There is no History for Projects and Folders and the only psuedo-attributes are Name and Description; so no you cannot look at a Project to determine who created it.

Surely the person who created the project also created or edited modules inside it, and you can get a clue by looking at them. I suspect perhaps they thought they were creating a folder, and you will end up "converting" their project into a folder.

No, you cannot have two projects in the same database with the same name. If they look identical then one has extra white space in it, perhaps at the end. "NameProj" and "NameProj " look alike.

  • Louie

Re: Is there an easy way to determine who created a Project?
SystemAdmin - Wed Mar 09 17:35:17 EST 2011

Firstly - I'm surprised to hear that you have two Project folders with the same name - DOORS requires all Project folder names to be unique, so are you sure that they are exactly the same or is two standard yellow folders that have the same name?

AKAIK the only type of info that DOORS can provide that may give you some idea as to who the owner(s) of a project might be are the access rights assigned to the Project folder or assigned to folders below the Project folder, and maybe looking at the change history\baseline history of modules withing the project to see who were the most recent users to make changes or to create a recent module baseline - each module has a "Last Modified By" attribute so that might provide some leads as to who knows something about the project (see code below that will report on "Last Modified By" for each formal module in the current project).
  

Module m
Item i
string itemType
string modName, fullModName, modLastModBy
 
for i in current Project do
    {
 
        itemType = type i
 
        if( itemType == "Formal")
                {
 
                fullModName = fullName(i)
                modName = name(i)
                
                m = read(fullModName,false)
                modLastModBy = m."Last Modified By"
                print modName ":\t" modLastModBy "\n"
                close(m)
                }
        }

 

 

Paul Miller
Melbourne, Australia

 

 

Re: Is there an easy way to determine who created a Project?
Mathias Mamsch - Thu Mar 10 07:00:47 EST 2011

And there is alway the BOFH way of doing things: Just lock down all access to the project (including read) and see if anyone complains ;-) Regards, Mathias
Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS

Re: Is there an easy way to determine who created a Project?
ChrisAnnal - Thu Mar 10 09:17:54 EST 2011

Thanks guys. As mentioned, one user had put an extra white space at the end of the project name when they created it. Also, the good-old-fashioned detective work suggested provided help, too. Since none of the modules inside the project had any activity, I soft-deleted the "duplicate" project and will see if anyone complains. We use a project template at our company that is restored from an project archive, so it's possible to have a project created and have a number of folders and modules in it, but nobody has really done any work in it.

Re: Is there an easy way to determine who created a Project?
llandale - Thu Mar 10 14:25:39 EST 2011

Mathias Mamsch - Thu Mar 10 07:00:47 EST 2011
And there is alway the BOFH way of doing things: Just lock down all access to the project (including read) and see if anyone complains ;-) Regards, Mathias

Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS

This is so out of character for you. Are you sure you are not Tony?

Perhaps install post-module-open triggers in the modules that update some Config file with who and when, then consult the config file from time to time.

  • Louie