Yes, its possible using Postgres DB - you will need to have admin rights access for this.
I have used Toby's version of Subscriptions Timer: New Views for Tableau Server Administrators — BI on BI
Below is another query that you can use:
Hope this helps.
Thanks very much for your response. This looks helpful and I'll take a look.
Thanks Matt - I'll download and take a look.
Actually, we are on 10.1.2 so I'm not going to be able to use the TS Background Tasks data source.
Ah, sorry, should have caught that. Still though--upgrade!