The following canned reports are known to time out or run very slowly when sifting large database.
All Cost Types
All Purchase Requests
All Purchase Requests WP
Assets by Owner's Department
Count of Computers by Operating System
Count of Logical Disk by File System Type
Count of Software Packages Installed
Incomplete Procurement Items
Primary User by Computer
Primary User on Multiple Computers
Requestors - parameter
Suppliers - parameter
Total User Accounts by Computer
User Profiles Across Multiple Machines
SMP 8.5
The security scoping process in the SQL behind the reports is not optimized. They use inline select statements instead of a more efficient JOIN.
When your refresh the console the “Revised Reports” folder should be empty. Go ahead and delete it.