-- Skin Info
select * from dbo.Skins
select * from dbo.SkinPackages
-- Skin Usage
select 'Host' ,SettingValue, count(*) from dbo.HostSettings where SettingName like 'Default%Skin'
group by SettingValue
select 'Portal', SettingValue, count(*) from dbo.PortalSettings where SettingName like 'Default%Skin'
group by SettingValue
select 'Page', SkinSrc, count(*) from dbo.Tabs
group by SkinSrc
-- Container Usage
select 'Host', SettingValue, count(*) from dbo.HostSettings where SettingName like 'Default%Container'
group by SettingValue
select 'Portal', SettingValue, count(*) from dbo.PortalSettings where SettingName like 'Default%Container'
group by SettingValue
select 'Page', ContainerSrc, count(*) from dbo.Tabs
group by ContainerSrc
select 'Module', ContainerSrc, count(*) from dbo.TabModules
group by ContainerSrc