• If you've not got an auditing tool that can scan for you, try using this guy's powershell scripts. Have a look at his blog here, they may be what you're looking for.

    https://blogs.technet.microsoft.com/heyscriptingguy/2013/05/07/use-powershell-to-discover-diagnose-and-document-sql-server/

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.