Authorized Software by Version

[joel_marquis]

Hi,

I use the authorized software section of Lansweeper for some InfoSec reporting and have run into an issue when it comes down to software versions.

I want to set all Adobe Reader DC versions to unauthorized except for the latest version, 2019.010.20069. From what I can see, I am only able to mark 'Adobe Reader DC' as a whole as authorized or unauthorized.

Hopefully someone can point me in the right direction for this!.

Cheers
Joel

[Esben_D · Accepted solution]

Unfortunately, this is not possible in the software authorization menu.

The best solution is to create a custom report which mimics the software authorization.

Something like:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.Lastchanged,
  Case
    When tblSoftware.softwareVersion = '2019.010.20069' Then 'Authorized'
    Else 'Unauthorized'
  End As [Authorized/Unautherized],
  Case
    When tblSoftware.softwareVersion = '2019.010.20069' Then 'red'
    Else 'green'
  End As backgroundcolor
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.softwareName Like 'Adobe Reader DC%' And
  tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software

Only downside is that you'll have to manually update this, but it's not much more work then changing the authorization anyway.