Recently had a request from one of the admins for list of printers used in the EBS application and how many jobs are directed to a printer. The following SQL provided what the admin needed, thought a good one to share...
select distinct fcr.printer, fu.user_name,
fu.description, count(*) jobs
from apps.fnd_concurrent_requests fcr, apps.fnd_user fu
where fcr.requested_by = fu.user_id
and (fcr.printer is not null and fcr.printer not in ('noprint','LOCAL_PRINT','LOCAL','LOCAL_PRINTTO', 'LOCAL_PREVIEW'))
group by fcr.printer, fu.user_name, fu.description;
The caveat is that if you purge concurrent requests, the information is dependent on the records available in concurrent requests table...
Hope this helps someone, or if there is a better way to find the printer usage, please let me know... have a great day!
