This is a collection of SQL scripts I've built up since starting to work with Oracle Fusion in 2019. I can't confirm for certain that all of the scripts work ...

select samp.dbid, fu.name, samp.version, detected_usages, total_samples, decode(to_char(last_usage_date, 'MM/DD/YYYY, HH:MI:SS'), NULL, 'FALSE', to_char(last_sample ...