I am a huge fan of the TM cleanup brigade. I want to keep track of which TMs are not getting updated and which ones are active etc. For that, i need to check when was a TM last updated AND in which TM groups is it being used/read? 

To find the last modified date, i am currently using the Freeform SQL option on the TM page and search for Source like '%' order by [Modified On] desc. This is easy if i had only a handful of TMs. Is there a good way for me to use some APIs or some reports that can give me the same data without all the grunt work?

I am on WS 11.1.1 version.