You can run this. Be careful if you are running any configurations via the scheduler only since those might show up as unassociated but are still in use.

select os.configurationid, os.configurationname, ms.moduleid, tm.tabid, t.portalid, t.tabname, p.portalname
from OpenWebStudio_Settings os
left join modulesettings ms on ms.settingvalue = os.configurationid and ms.settingname = 'ConfigurationID'
left join tabmodules tm on tm.moduleid = ms.moduleid
left join tabs t on t.tabid = tm.tabid
left join portals p on p.portalid = t.portalid
order by configurationid,portalid