Because Query requires additional parameters value:
Default SQL Query of report is:
EXEC [dbo].[sp_PMWin_Report_SoftwareUpdateDeliverySummary]
@VendorGuid = '%VendorGuid%',
@FilterCollection = '%FilterCollection%',
@ScopeCollectionGuid = '%ScopeCollectionGuid%',
@TrusteeScope = '%TrusteeScope%'
You can gather required Query pameters, using Altiris Profiler.
1. Open "Windows Software Update Delivery - Details" report and set appropriate "Vendor" or leave "Any"
2. Open "Altiris Profiler" ⇒ Start profiling ⇒ click "Refresh" of report ⇒ Stop profiling:
- Filter profiler output to find EXEC [dbo].[sp_PMWin_Report_SoftwareUpdateDeliverySummary]
- Copy "SQL Trace"
- Copy this SQL trace output to your Automation policy Query, so now SQL query will contains required data for @TrusteeScope.
- Also use "Send automation policy e-mail" task.
Thanks,
IP.