About Me

My photo
System Analyst,Collaboration Servers Integrate,Enterprise setup planner.

Friday, 8 November 2013

Generic Local and Unassigned Resource GUID in project server.


Query


select ResourceUID,ResourceName  from MSP_EpmResource_UserView where ResourceUID='8847397E-B724-4EBA-949A-DBE03842CF2A'

select ResourceUID,ResourceName  from MSP_EpmResource_UserView where ResourceUID='B067CE64-9588-4B18-BF54-3491F76419C9'


Result:

8847397E-B724-4EBA-949A-DBE03842CF2A Generic Local Resource

B067CE64-9588-4B18-BF54-3491F76419C9 Unassigned Resource
Posted by at
Labels:

1 comment:

  1. Unknown22 February 2016 at 21:47

    Thank you for sharing, I recently did a blog post on the unassigned resource and shared this information with my readers. Here is the link to the page if you are interested: http://bit.ly/TPC_Unassigned

    ReplyDelete

Subscribe to: Post Comments (Atom)