Answer
There is more than one method and we are only presenting one of them here.
Once you have completed initial report without the collection filter.
Once you have added the collection filter parameter.
where [%Guid%] in (
select ResourceGuid
from CollectionMembership
where CollectionGuid = '%Collection%'
)
Remember that the parameter name will corresponds to the SQL query variable name (Collection).
select [Domain], [Name], [IP Address]
from vComputer
where [Guid] in (
select ResourceGuid
from CollectionMembership
where CollectionGuid = '%Collection%'
)
select [Display Name], [Office Location], [Office Telephone], [Email]
from vUser
where [Guid] in (
select ResourceGuid
from CollectionMembership
where CollectionGuid = '%Collection%'
)
Once you have added the needed changes the SQL query, you will need to:
<default><![CDATA[{a39168f4-59f9-423d-a47b-9f0e2a5d3682}]]></default>
Some possible collection GUIDs:
eb3a1a12-e1c7-4431-b060-f0333e4e488c: All Computers
a39168f4-59f9-423d-a47b-9f0e2a5d3682: All Platforms
4c31e964-d085-42d8-bfb0-d439b4c61e47: All Package Servers
e3a71b08-1612-44a6-9f71-7d359d5475b4: All Windows Computers
<parameter type="custom" assemblyName="Altiris.NS.StandardItems, Version=6.0.6074.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f" typeName="Altiris.NS.StandardItems.Query.ItemPickerParameter" filterClass="a725fb57-09e1-4e9f-bb13-b4600094cf61" excludeDescendents="False" prompt="True" name="Collection" substituted="true"> <prompt><![CDATA[Collection: ]]></prompt>
</parameter>
<parameter type="custom" assemblyName="Altiris.NS.StandardItems, Version=6.0.6074.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f" typeName="Altiris.NS.StandardItems.Query.ItemPickerParameter" filterClass="a725fb57-09e1-4e9f-bb13-b4600094cf61" excludeDescendents="False" prompt="True" name="Collection" substituted="true">
<default><![CDATA[{a39168f4-59f9-423d-a47b-9f0e2a5d3682}]]></default>
<prompt><![CDATA[Collection: ]]></prompt>
</parameter>
Note: At this time there is no users interface to add a default collection using this method.
When you import a report into Notification Server with an item picker, it has a reference to an assembly in it (assemblyName="Altiris.NS.StandardItems, Version=6.0.6074.0, Culture=neutral, PublicKeyToken=d516cb311cfb6e4f" typeName="Altiris.NS.StandardItems.Query.ItemPickerParameter").
If you import a report into a Notification Server with a different assembly build than the report was built on, it will not import. To import a report with a different assembly build, you will need to change the assemblyName section of the file to reflect the change.