What is the best way to create a report or an extract of our Team rosters.
Is there a way to extract that data so I can audit and use those lists for communcations etc?
You will most likely have to go the route of building a SSRS report to aggregate the information.
SELECT StandardUserTeam.Team, Employee.DisplayName
INNER JOIN StandardUserTeam ON FusionLink.sourceID = StandardUserTeam.RecId
Inner join Employee ON FusionLink.targetID = Employee.RecId and targetbase = 'Employee' and SourceBase = 'StandardUserTeam'
WHERE FusionLink.RelationshipName = 'ProfileEmployeeAssociatedByStandardUserTeam'
AND FusionLink.SourceID in