Has anyone else installed and used the Upgrade Assessment Tool with SCCM 2012 SP1 and experience problems straight away? As with the Application Compatibility Toolkit Connector for SCCM 2007, this seems to be a half-baked, poorly tested add-on with minimal documentation, thus leading to hours of architecture and administrator time resolving presumably easily fixable details. Specifically, I've had to do the following modifications in order to get the synchronization process and reports to work properly:Allow execute permission on the sp_UATCreateTempTable, sp_UATGetUniqueDevices, sp_UATMergeTable stored procedures.Modify the stored procedure sp_UATCreateTempTable per recommendations in this thread: http://social.technet.microsoft.com/Forums/en-US/80e7f5b5-1893-497a-ac37-3df9e789cf28/upgrade-assessment-tool-sync-issues?forum=configmanagergeneralAllow Insert, Update, Delete, and Select permissions on UAT_Application, UAT_Application_Report, UAT_Deployment_OS, UAT_Machine, UAT_Machine_Installed_App, UAT_MachineS, UAT_MachineS_Installed_App, and UAT_OS_System_Requirement tables.Modify the datasets in the "Application status for computers in a specific collection", "Hardware device status for computers in a specific collection", and "Operating system requirement status for computers in a specific collection" reports to use the original queries which used the correct FCM alias rather than MAM, MDS, or MSR aliases respectively. Thoughts? At least the reporting on column MyRating64 appears to work correctly now, so that's a minor plus over the ACT Connector :) -S
