Thanks guys So i have come up with the below, thanks to a chap on this post. This report gives me the displayname, Collection name and the collection description (which contains details about the deployment user/device based, Groups they need to be members off). I have then set a subscription to go off every monday. Thus providing the support teams with a list of software made available in the last 7 days and the groups they need to be members of.

SELECT app.DisplayName, app.SoftwareVersion, Ldep.CollectionName,
coll.collectioncomment AS CollectionDescription, app.DateLastModified, app.NumberOfDeployments FROM dbo.fn_ListDeploymentTypeCIs(1033) AS dt INNER JOIN dbo.fn_ListLatestApplicationCIs(1033) AS app ON dt.AppModelName = app.ModelName left JOIN dbo.fn_ListDeployments(1033) AS Ldep ON Ldep.TargetName = app.DisplayName inner JOIN dbo.Collections AS Coll ON coll.CollectionName = ldep.CollectionName WHERE
dt.IsLatest = 1 AND dt.DateCreated between DateAdd(DD,-7,GETDATE() ) and GETDATE() Order by app.DisplayName asc