SSRS Report to get all Pending Changes

Question

Hi

I need to get a report in SSRS to show all Pending Changes in SC from some users, I tried to do this  via SQL Query directly from the Collection Database, but I can get all pending changes and know from wich workpace are, but I need to display the User name too, and I can't find it :S, I see in the table that have ownerID field, but I can't find some realtion with other table to get de Owner name, please help me with this, or maybe there is a way more easly to get this info via Web Services I don't know, but I need to present this info vya Reporting Services.

Thanks!

---

Raymundo Chapa, MCTS http://blogs.inavant.com.mx/ http://projectaserverzone.blogspot.com/

Answer 1

Hi,

I resolved my case, with this query

SELECT     Cs.DisplayPart, P.TargetChildItem, P.TargetParentPath,P.TargetServerItem, W.WorkspaceName, W.Computer
FROM        
 tbl_PendingChange AS P 
    INNER JOIN Constants AS Cs WITH (nolock)
    INNER JOIN tbl_Identity AS I WITH (nolock) ON Cs.TeamFoundationId = I.TeamFoundationId ON P.WorkspaceId = I.IdentityId 
    INNER JOIN tbl_Workspace W ON P.WorkspaceId = W.WorkspaceId

Thanks any way!

---

Raymundo Chapa, MCTS http://blogs.inavant.com.mx/ http://projectaserverzone.blogspot.com/

Answer 2

Hi Raymundo,

I’m glad to hear that you got it working. Thank you for sharing your solution & experience here, it will be very beneficial for other community members having the similar questions.

Welcome you back whenever you need help.

Best Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hey Raymundo -

There is a User Voice feature request to include a report containing pending changes, as well as the age of said pending change (that is, how long changes have been checked out):

http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/2037715-add-a-report-that-shows-the-age-of-pending-changes

If you're interested in seeing this feature baked into the product (or as an extension or Power Tools feature), I encourage you to vote it up.

Thanks!

Answer 4

Thanks Matt,  I did it.

---

Raymundo Chapa, MCTS http://blogs.inavant.com.mx/ http://projectaserverzone.blogspot.com/