Dynamics CRM FetchXML Example To Retrieve Access Team Members

FetchXML_Retrieve_AccessTeamMembers.xml

<fetch count="50" >
  <entity name="opportunity" >
    <attribute name="name" />
    <link-entity name="principalobjectaccess" from="objectid" to="opportunityid" link-type="inner" alias="poa" >
      <attribute name="objectid" alias="objectid" />
      <link-entity name="team" from="teamid" to="principalid" link-type="inner" >
        <link-entity name="teamtemplate" from="teamtemplateid" to="teamtemplateid" >
          <attribute name="teamtemplatename" />
        </link-entity>
        <link-entity name="teammembership" from="teamid" to="teamid" link-type="inner" intersect="true" >
          <link-entity name="systemuser" from="systemuserid" to="systemuserid" link-type="inner" >
            <attribute name="fullname" />
          </link-entity>
        </link-entity>
      </link-entity>
    </link-entity>
  </entity>
</fetch>