supercow · April 22, 2013 23:06
diff --git a/pe_exported_query.sql b/pe_exported_query.sql
 use console_inventory_service;

 select r.restype 'Resource',r.title 'Title',h.name 'Exporting Host'
 from resources as r
 left join hosts as h on h.id = r.host_id
 where r.exported=1
	use console_inventory_service;

	select r.restype 'Resource',r.title 'Title',h.name 'Exporting Host'
	from resources as r
	left join hosts as h on h.id = r.host_id
	where r.exported=1