Report computers with two antivirus software

[about_blank]

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'

[ErikT · Accepted solution]

@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

[about_blank]

Thank you very much gents, that was really helpful!

[Obi_1_Cinobi · Accepted solution]

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 · Accepted solution]

@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