Restart Status Report fails to render data and times out with errors in the SMP Log Viewer.
On the Console > Home > Patch Management > Exception Handling > Computers Requiring Restart
Error excerpt from SMP Log Viewer:
Failure running Report 'Restart Status'. Please check the configuration of the query.
Exception Details: Altiris.DataSource.Exceptions.DataSourceRunException: Timeout Expired ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout perior elapsed prior to completion of the operation or the server is not responding.
Bloated database tables, or lack of indexing / maintenance on the database, is most likely the cause; however, research found the scripted Stored Procedure behind this report could be enhanced for better performance.
Work through the following:
Run the attached updated Stored Procedure: 'spPMCore_RebootStatusReport7_0.sql' against the Symantec_SMDB database in the Microsoft SQL Server Management Studio
Advisory: This script is written to 'Create' the Stored Procedure and will throw an error upon running until the old Stored Procedure is renamed for archive purposes.
Example: Go to the Databases > Symantec_CMDB > Programmability > Stored Procedures; locate the Stored Procedure: 'dbo.spPMCore_RebootStatusReport7_0.sql'
Highlight in the left pane; right-click > Rename: add the extension; _old
Best practice: Always ensure a recent backup of the database was performed before updating any database items.
Ensure the Database Maintenance / Health is in order: