Using the report builder or sql/swql query to find if a server has a specific application template.

How can I configure filters in reports to be able to get a list of specific nodes that contains "prod" in the server name and missing a specific application template being assigned (I just want to occasionally check to ensure these nodes have a particular template assigned for compliance reasons).

For example we have templates assigned to all production server. 

Trying to get a report if a production server does not have the template.