How to retrieve all list/library which uses custom content type in a site collection?

Question

How to retrieve all list/library which uses custom content type or a custom column in a site collection?

It would be really helpful if you post your answers in C# code or SQL query. Please let me know if you have any clarification on the question. Thanks

Answer 1

SharePoint API has class and function SPContentTypeUsage.GetUsages that returns all content type usages in site collection. Is MSDN article there is an C# sample too.

Also look at the accepted answer in this question . The answer is in PowerShell.