KACE Product Support

We're having an odd issue with about 40 systems only (out of about 5500) that are triggering some events that we can't seem to get to the bottom of. I'm looking to run a query against the database that will do the following.

If I provide the computer names, the query will list installed applications common to all systems listed.

If anyone could help with this I would greatly appreciate it. I tried running it by our sql team and they wanted me to give them the query to run. I know next to nothing as far as sql code.

Thanks,