Hi
You can try using the following SQL query
----------------------------------------------------------
use nolio_db55;
SELECT apps.APP_NAME as Application_Name, comp.COMPONENT_NAME as Shared_Component_Name, comp.VERSION as Shared_Component_Version FROM applications apps
inner join revision_mapping rp on rp.application_id=apps.ID
inner join components comp on comp.ID=rp.component_id
where comp.COMMITTED=1
---------------------------------------------------------
Thanks
Jacky