By altering the following sql to match your database names it will show all the items in the docstore as well as the corresponding file system path. SELECT obj_UID as Item _ID ,obj_Name as PPM_ Item _Name ,'root_'+ Cast(doc_RootFolderID as nvarchar(100)) as Doc_Root, Cast(doc_GUID as nvarchar(100)) + doc_FileName as SubFolder, doc_FileName as Original_Filename
Unfortunately the Reports section in Agile will only report on actual items like stories, tasks etc and won't report on Teams and Team Members. The following sql can be run against the Agile database to give a listing of all teams and their members.
A user reported that many of the files in a project did not show up in the project folder. She was certain she had created the archives, and checked the files in already. Selecting the menu item : Folder/Update Project Folder in the Version Manager GUI did not make any difference.
This is usually a problem with the project meta data , edit the Project PVCSPROJ.PUB (located by editing the ISLV.INI file's PVCSPROJ= setting) make sure that the DIR= setting for the project that is causing the problem is correct. If the setting is correct, make sure that the PVCSFOLD.PUB exists or if you are under UNIX, that you have sufficient rights to read and write to this file.
Reported on a ZMF 8.2 Patch 3 system. However, can recreate the problem on 8.2 Patch 4 and back to least 8.1.4.01, too. It affects all XML Service user interfaces (e.g. SERXMLBC, SERXMLRC, etc.).
1) an initial data import is performed 2) for whatever reason, those imported records are deleted by the customer 3) a new import set is created to re-import those same items into TT
