cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
about_blank
Engaged Sweeper

Hello,

I noticed that I have computers with two antivirus installed.

I've checked the previous report but looks like it doesnt work for me:

https://community.lansweeper.com/t5/general-discussions/report-computers-with-two-antivirus-software...

Is there a way to combine 2 different tables with Specific softwarename?

Lets say I want to check if Crowdstrike is installed on Windows and Linux:

for these I need to look for:

tblsoftwareuni.Softwarename = 'Crowdstrike Windows Sensor'

tsysLinuxsoftwaretype.name = 'falcon-sensor'

 

 

2 ACCEPTED SOLUTIONS
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@about_blank 

 

To edit a report, I would recommend:

  • Opening the report you want to edit. 
  • Save it under a different name. 
  • Use the report builder to make the changes. 

You can refer to the database documentation for an overview of database tables. This can be found in the Reports tab > Database documentation. 
 

If you are proficient in SQL language, you can also edit the report directly in SQL Server Management Studio (SSMS)

 

Note: check out our Report library, the report you are looking for, or close to it, might already be available

 

 

 

 

 

 

 

 

 

View solution in original post

Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

You will need to use a Union statement to check for specific software across OS systems. The report below provides an overview of your Windows, Linux, and Mac computers that have certain software installed. This should get you started!

https://www.lansweeper.com/report/specific-windows-linux-or-mac-software-installed/

View solution in original post

3 REPLIES 3
about_blank
Engaged Sweeper

Thank you very much gents, that was really helpful!

Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

You will need to use a Union statement to check for specific software across OS systems. The report below provides an overview of your Windows, Linux, and Mac computers that have certain software installed. This should get you started!

https://www.lansweeper.com/report/specific-windows-linux-or-mac-software-installed/

ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@about_blank 

 

To edit a report, I would recommend:

  • Opening the report you want to edit. 
  • Save it under a different name. 
  • Use the report builder to make the changes. 

You can refer to the database documentation for an overview of database tables. This can be found in the Reports tab > Database documentation. 
 

If you are proficient in SQL language, you can also edit the report directly in SQL Server Management Studio (SSMS)

 

Note: check out our Report library, the report you are looking for, or close to it, might already be available