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.
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
You will get this error if you try to move an SBM item with the report mover with a Sprint selected on the Right side of the screen as the target in the drop down. The purpose of the report mover tool is to move items into Product Backlogs, Release Backlogs or Backlogs under a Product and not straight into a Sprint. After moving the items to one of these backlogs you would then use Agile to put the items into Sprints.
One example of a time you might want to override this setting is if you are using the Embedded Report Widget on a form and you want all the items returned by the report to show in the widget by default. Sometimes in the Embedded Report Widget it might not be as obvious that there are multiple pages of results to look at. The following article will describe how to show all the items the report returns regardless of what the users profile is set to.
Login to the Classic SBM shell by removing "shell=srp" from the SBM url. Click on the Reports section in the navigation tree. Click on the "Browse Multi-Table Reports" link in the Advanced Tasks area.
In the example above for SBM the value for "Enhancement Request" can be found using either the SBM Administrator or Composer. Look for the field listing for one called "Type" and the values in the "Selections" section in the Administrator tool or "Value" section in Composer.
For each line containing "<img>" HTML tag, replace "src" attribute with the name of a more appropriate image from "...\SBM\Application Engine\bin\images\". The defaults below are the same ones an item uses as it's default.
1. Select a baseline from Find Baselines results 2. Select all the items in the baseline from the Related Items pane 3. Right click on the items and select Get.
