As a TFS admin I sometime wonder how many team projects is in use and maybe when it was last changed. Sometimes I've been forced to find out and I have created some SQL queries to run against the warehouse to figure it out.
Packaged into an custom SSRS Report
Now I have packaged those queries into a custom SSRS report for tfs2008. You download the report at my skydrive http://cid-5d46cae8c0008cf0.skydrive.live.com/self.aspx/.Public/TeamProjectLastChanged.rdl Once downloaded you simply needs to upload it to your own TFS Server and point the data source to the tfs standard TFSReportDs shared data source.
TFS2010 updated version http://cid-5d46cae8c0008cf0.office.live.com/self.aspx/.Public/TeamProjectLastChanged2010.rdl
Subscribe to:
Post Comments (Atom)
Posts
Hi Mattias,
ReplyDeletegood job!
It is possible to upgrade the report for TFS2010?
Best Regards,
Sven
Thanks
ReplyDeleteA quick upload, not realy tested :(
Hi Mattias,
ReplyDeletemany thanks for the quick upload.
The report works fine :)
I just added the collectionname and a filter to identify old projects (reference to last wi, cc and build)
Best Regards,
Sven
The 2010 report looks for a field mapping to "Team Project" that isn't there. You need to update the Select statement to get the project names to show up. Then it works great!
ReplyDeleteSelect
tp.ProjectNodeName as [Team Project],
wih.Date as lastWorkItem,
cc.Date as LastCodeChurn,
build.Date as LastBuild