- How to export peoplesoft compare report into an excel sheet.
Execute following SQL Query in Source Database to get the peoplesoft compare report results for the specified project.
----------------------------------------------------------------------SELECT distinct objecttype, objectvalue1, objectvalue2, sourcestatus, targetstatus, upgradeaction
FROM psprojectitem
WHERE projectname = 'Replace COMPARE_PROJECT_NAME here'
AND sourcestatus in (4,5)
ORDER BY objecttype, objectvalue1;
----------------------------------------------------------------------
Results of the above query can be exported into an excel sheet for further analysis.
