That's kind of intriguing. I am not all that great with SQL and I am sure you can do it all in a query but I have been playing around with this. Depending on if you have access to SQL or server side stuff or not I tried it through workflow and wrote it to a Word Doc. Of course this assumes that what I say next about the workflow database is correct.
In your Workflow database you have a workflow_history table. This shows the workflow ID's, versions, and modification dates.
When looking through this I noticed that some of the workflows had a NULL version number. Looking through it, that seems to indicate that the workflow was deleted or is not currently published. So what you want is the distinct workflow ID's but not the ones if any of the specific ID rows has a null.
I played around and believe the following custom query should give you that (Workflow is the name of our dev database). Our dev database has 94 published workflows and the below query gave me 94.
use Workflow;
With x as (select * from workflow_history where version is null)
Select distinct workflow_id, workflow_name from workflow_history as t where not exists (select 1 from x where workflow_id = t.workflow_id)
Then for each row of the above, do another custom query.
SELECT TOP 1 *
FROM [Workflow].[dbo].[workflow_history] where workflow_id = ? order by version desc
This will give you the latest version of the of the current distinct workflow ID.
Then you just write those to a multivalue tokens. From there you can write them to a word document or something and get a list.
Results in my token tracker:
Things seemed to line up and makes sense when I checked it out.
Again, this may be way easier in SQL but depending on your access to the back end workflow could kick it out for you.
-Chris