When creating a list with no values but to which users can add values, the user-entered values are sometimes not displayed across all projects. WORKAROUND: Always include at least one list item when creating lists ."
Items are show in the " All Items I Own" report for a user, even though the user is no longer the owner of the items . This can happen if the user was in a group that was secondary owner of items and the user is removed from the group.
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 Agile_ 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
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
