Show Installed Apps across all Sites from DB - jigneshpshah/greycube_helpmanual GitHub Wiki

to check apps installed in all sites

Run the output from the query below

select concat( 
'select ''', t.table_schema,''' as DB, defvalue as apps from ', t.table_schema,'.tabDefaultValue tdv where defkey = ''installed_apps'' and defvalue like ''%frappe%'' union all') query
from
(
	SELECT table_schema 
	FROM information_schema.TABLES
	where table_schema not in ('mysql','performance_schema','information_schema')
	GROUP BY table_schema   
) t