If you go to Admin mode and try to delete the Block Type I recall it will list the contents it's present on. Inspect the namespace of that ASPX and go hunt using a reflection tool. Maybe you can test that page and catch a SQL call using some Profiler as well.
Thanks for the answer!
I'm a bit new to EPiServer and I think it would work if the blocktype was not from code as in my example.
I can see the remove button for other types but not for my block that is from code.
Will try remove another type in the meanwhile and see if I can't trace the sql.
I know Dejan Caric wrote a blog about that a while back as well if you are looking for some code :)
If you just want the SQL you can always listen to the actual SQL using SQL profiling tools or similar. I would probably have solved it in code but that takes a deploy so...
It doesn't look that hard to solve in code so it's probably the right way to go too :)
If you're interesting finding content of a specific content type - how about this SQL Query?
SELECT c.pkID FROM tblContent c INNER JOIN tblContentType ct ON c.fkContentTypeID = ct.pkID WHERE ct.Name = 'NAME-OF-YOUR-CLASS'
You can take c.pkID and add into the url of the episerver edit interface for example www.mydomain.com/episerver/cms/#context=epi.cms.contentdata:///ADD-ID-HERE
Great! thank you!
That helped me achieve what I wanted.
I combined that with the sp editDeletePageCheck and found the references.
I would like to find which pages that use a specific block type and was wondering if there is a plugin built for this available?
Otherwise if someone has some sql query for it?
I want to search in production so thats why i would like a sql query and not do it in code for the sql query case.
EPiServer 7.5 is used.