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:
Patch Management 7.1 SP2 MP1.x