You would be using the API or SQL to generate these reports, or you can use an Extension Attribute and then mass update that EA using the MUT based of a CSV we would export from SQL. Ultimately, the reason sites aren't searchable like this is that sites are not meant to be used for scoping / organization of computers. They are meant to be individual Jamf Pro nodes within the Jamf Pro server. Smart and Static groups as well as EAs and User/Location information should be how we organize and scope things out to our computers.
