With each configuration wizard, the websites table creates new records for each website in the environment, but still keeping old records as well as not updating the WebsiteID column in the ReportJobs table, causing that any scheduled report fails indicating "Unable to retrieve url: https://<Websites.ServerName>:443/Orion/Report.aspx?ReportID=### using HTML type.".
To fix this I run this script once a week to make sure I keep it straight, but it will be nice to have it fixed while running the configuration wizard.
update [NetPerfMon].[dbo].[ReportJobs] set [NetPerfMon].[dbo].[ReportJobs].[WebsiteID] = (select WebsiteID from [NetPerfMon].[dbo].[Websites] where Type='primary')
update [NetPerfMon].[dbo].[Websites] set ServerName = '<ServerName.FQDN>' where Type = 'primary'
update [NetPerfMon].[dbo].[Websites] set FQDN = '<ServerName.FQDN>' where Type = 'primary'
update [NetPerfMon].[dbo].[Websites] set FQDN = '<ServerName.FQDN>' where Type = 'additional'
@jblankjblank @aLTeReGo
