I need to find ICM scripts which are not referenced by any other scripts nor scheduled by any call types. Please help with the SQL query Regards,Arjun Raju

I need to have a query to get the inactive or unreferenced scripts.Can anyone please help on this. When I query t_Master_Script , i even get the inactive or unreferenced scripts. Also, I want to get the call types that used inside the scripts 

I was working on finding the Call-Types that are referenced or used in the scripts. Can any one help providing the SQL query to find the call types that are used in scripts and or the nodes used in the script.   Regards, Arjun Raju