Report of workstations with installed software

Is there a SQL Query report that can list off all workstations that have a certain software loaded on them? It needs to have a wildcard, so we could show all workstations with %visio%.

Thanks