All Patch Software Updates Legacy Reports Can't Automatically Be Saved in ITMS 7.5
Last Updated October 20, 2014
Opening a 6.0 Legacy Report the information can be viewed, but the report can't be converted to 7.5 format.
"Reports have been upgraded in Notification Server 7.1. Legacy reports will continue to work, however changes cannot be saved. Your must convert this to the new report format if you wish to modify its definition."
6.0 Legacy Reports used a different format to create reports. This can not be converted to the updated format introduced in the ITMS 7.1 release.
Customers will need to create a new report and copy in the following SQL to duplicate the legacy report.
Go to Reports > All Reports > highlight Reports > Right Click > New > SQL Report
Type in the Report Title - "All Patch Software Updates"
Type in the Report Definition - "Lists All Patch Software Updates"
Clear the contents of the 'Parameterize Query' and copy the following SQL:
set rowcount 0;
su._ResourceGuid as [_ResourceGuid],
FROM dbo.vSoftwareUpdate rsu
INNER JOIN dbo.Inv_Software_Update su ON rsu.Guid = su._ResourceGuid
5. Save Changes
ITMS 7.5 Patch Management 7.5 (7.1 SPx)
Imported Document ID: TECH210366
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe