SQL Report Help - All Windows Assets - If Software Is Installed - True/False Column

[ts2340]

I'm looking to create a sort of "Master" Windows asset report that uses a query to show basically if all of our security tools are installed.. So I want to have *all* Windows assets listed regardless if they have the applications I provide installed or not.. So like this:

AssetName	Antivirus	ConnectWise	Rapid7	Etc	Etc
PC1	Yes	Yes	No	No	Yes
PC2	No	Yes	Yes	Yes	Yes

All the data is in the DB so I know it's possible, just unsure how to pull it off.. 

Thanks!

[Mister_Nobody]

You can use LS Reports Library to learn how to create report

https://www.lansweeper.com/report/

This report is suitable for your task

https://www.lansweeper.com/report/installed-web-browsers/