Query to list all items associated with a site

Query to list all items associated with a site

We have been using ServiceDesk for many years and the database has gotten full old information.
We need to delete existing sites (simply leaving them unused is not an option, too many of them).

Is there a query that would list all the items the SITE is referenced by (Business Rules, Assets, Requests, etc...)

 

                  New to ADSelfService Plus?