@ACallisto
Thank you for posting in Microsoft Q&A forum.
These are just some of the commonly used queries that the author has compiled for us, most of them should still be applicable to the current SCCM version, only a few views may have been changed, here is the views of each version of SCCM collected by Eswar koneti:
https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.