Ok so im liking the 7.1 console a lot.. in 6 when i created collections you had to use the default sql they give you and add your sql to it to create dynamic collections... i see in 7.1 this is not the case anymore.. really like that..
now back on track...
I have been creating reports in our dev 7.1 to get things rolling. I deleted all the sql code it comes with and it works so my question is...
any reason to use the default sql when you click new sql report?
i delete all of this and put my own in.. example...
DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
[vri2_Resource].[Guid] AS [_ItemGuid],
[vRM_Resource_Item] AS [vri2_Resource]
([vri2_Resource].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
Paste from sql management studio (CompName is a parameter and works)
Select t1.[_ResourceGuid] as _ItemGuid, t1.[Name], t0.[DisplayName], t0.[DisplayVersion], t0.[Publisher]
From [Inv_AddRemoveProgram] t0 INNER JOIN
[Inv_AeX_AC_Identification] t1 on t0.[_ResourceGuid] = t1.[_ResourceGuid]
where t0.[DisplayVersion] is not null and t1.[Name] like '%CompName%'
order by t0.[DisplayName]