Lansweeper Software Report: Identifying Assets with Desired Software

In the ever-evolving world of cybersecurity, it's essential to stay vigilant about patch updates and vulnerabilities in software applications. Recently, Sophos released a critical code injection vulnerability patch update for its Firewall products, affecting all versions 19.0 MR1 (19.0.1) or older. This report highlights the importance of monitoring and reporting on software installations across your IT estate.

Lansweeper, a powerful IT asset management solution, allows you to easily identify assets with desired software installed. By leveraging its advanced querying capabilities, you can generate detailed reports on software installations across your network.

To create a Lansweeper software report, follow these steps:

1. Log in to your Lansweeper account and navigate to the 'Software' module.

2. Click on the 'Assets without Software' tab to identify assets that do not have the desired software installed.

3. In the search bar, enter the software name you're looking for, followed by a wildcard character (%). For example, if you're searching for assets with Sophos Endpoint Protection installed, enter 'Sophos%'.

4. Use the 'Inner Join' feature to combine data from multiple tables. This allows you to filter results based on specific asset types, custom attributes, and more.

5. Create two separate data selections: one for assets with the desired software installed and another for those without.

Here's an example query:

```

SELECT

tblSoftware.AssetID,

tblSoftwareUni.softwareName,

tblSoftware.softwareVersion

FROM

tblAssets

INNER JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID

INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype

INNER Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID

WHERE

(tblSoftwareUni.softwareName Like 'software_name%' And tblSoftware.softwareVersion = 'wanted_software_version')

UNION ALL

SELECT

tblSoftware.AssetID,

tblSoftwareUni.softwareName,

tblSoftware.softwareVersion

FROM

tblAssets

LEFT JOIN tblSoftware ON tblAssets.AssetID = tblSoftware.AssetID

WHERE

Not Exists(Select tblSoftware.AssetID And tblSoftwareUni.softwareName Like 'software_name%')

```

This query combines two data selections: one for assets with the desired software installed (matched by name and version) and another for those without. The results will display in a table format, allowing you to easily identify assets that need attention.

By regularly running this Lansweeper software report, you'll be able to:

* Monitor software installations across your IT estate

* Identify assets with outdated or incorrect software versions

* Take corrective action to ensure compliance and security

Remember to substitute the desired software name and version in the query to tailor it to your specific needs. With Lansweeper's advanced reporting capabilities, you can streamline your software management processes and stay ahead of potential vulnerabilities.