Show used processes

Use this query to get a list of IDs of processes that had a ticket started in the last 6 months:

   select distinct OriginalProcessId from processinstance where datediff(month,datestarted,getdate()) > 5

Oracle

  select distinct OriginalProcessId from processinstance where sysdate - datestarted > 180