Inactive Resource Data Clean up – SQL

The Inactive Resource Data Cleanup portlet displays information for inactive resources that still have pending items on active objects:

• Inactive User is the Project Manager
• Inactive User is the Idea Manager
• Inactive User is the Resource Manager
• Tasks assigned to the user
• Action items assigned to the user
• Risks assigned to the user
• Issues assigned to the user
• Change requests assigned to the user
• Incidents assigned to the user