I just love the CRM community.  Ayaz Ahmad posted a comment on the previous article about finding Shared CRM Accounts and included a C# function written to perform a similar function to the SQL code in the other article. 

Ayaz's version uses the CRM SDK to retrieve all of the accounts for a specified Team instead of performing a SQL query.  This will allow you to add it to an application without having to resort to performing direct SQL Queries. 

This the example will place the Account Names into a ListView and is used like this:

// This is the Guid from the Everyone Team on my development
// system. You will need to substitute a real Guid from
// your system to make this function correctly.
Guid TeamID = new Guid("3146CAE5-B13E-DB11-ADAF-00142A05B544");
ListSharedObjectByTeams(TeamID);

and here is the function that does all of the work.

void ListSharedObjectByTeams(Guid TeamId)
{
    try
    {
	CrmService service = new CrmService();
	service.Credentials = System.Net.CredentialCache.DefaultCredentials;

	// Create the ColumnSet indicating the fields to be retrieved
	ColumnSet cols = new ColumnSet();

	// Sets the ColumnSet's Properties
	cols.Attributes = new string [] {"name", "accountid"};

	// Create the QueryExpression Object
	QueryExpression query = new QueryExpression();

	// Set the QueryExpression Object's Properties
	query.EntityName = EntityName.account.ToString();
	query.ColumnSet = cols;

	// Retrieve the Contacts
	BusinessEntityCollection bus = service.RetrieveMultiple(query);
	for (int i = 0; i<bus.BusinessEntities.Length; i++)
	{
		account acct = (account)bus.BusinessEntities[i];

		TargetOwnedDynamic target = new TargetOwnedDynamic();
		target.EntityId = acct.accountid.Value;
		target.EntityName = EntityName.account.ToString();

		// Get Shared Access Rights
		RetrieveSharedPrincipalsAndAccessRequest access = new
		RetrieveSharedPrincipalsAndAccessRequest();
		access.Target = target;

		RetrieveSharedPrincipalsAndAccessResponse accessResponse =

		(RetrieveSharedPrincipalsAndAccessResponse)

                     service.Execute(access);

		foreach (PrincipalAccess principalAccess in
			accessResponse.PrincipalAccesses)
		{
		     switch (principalAccess.Principal.Type)
		     {
			case SecurityPrincipalType.Team:
			    if (principalAccess.Principal.PrincipalId

                                     == TeamId)
			    {
                                     // Add the Account Name to the ListView

				listAvailable.Items.Add(acct.name);
			    }
			break;
		    }
		}
	}
     }
     catch(Exception ex)
     {
	throw(ex);
     }
}

Thanks for sharing Ayaz.

By the way, Ayaz is a big part of the Microsoft CRM Pakistan User Group.

MSCRMPUG (Microsoft CRM Pakistan User Group) is an INETA chartered user group, a Microsoft Dynamics Related Community, Culminis ALLIANCE and O'Reilly User Group Professional Association. This group is set up in mind of the growing numbers of Microsoft Dynamics CRM (pronounced as Customer Relationship Management) users in Pakistan. It provides members with the base for communicating with each other to share ideas and exchange contacts as well as helping each other in development work and to discuss technical issue regarding implementation, customization, Development and extending MSCRM in small and medium businesses. A group open to all users, administrators, developers and consultants working with Microsoft Dynamics CRM (Customer Relationship Management).