This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

ts2340
Engaged Sweeper

‎10-27-2023 05:25 PM

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:

 

AssetNameAntivirusConnectWiseRapid7EtcEtc
PC1YesYesNoNoYes
PC2NoYesYesYesYes

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

Thanks!

Labels:
0 Kudos
1 REPLY 1
Mister_Nobody
Honored Sweeper II

‎10-30-2023 05:02 AM - edited ‎10-30-2023 05:03 AM

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/

 

0 Kudos

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now