Inventory report for percent software deployed

[malbanese1]

My organization uses a power management software called Verdiem and i need to report on the percent of our computers that have it versus not. I was trying to list all active computers with a yes or no (Boolean)result if the software is installed. It would be great if i could identify laptops versus desktops but that is not a requirement.

I did search the reports forum but could not customize any of the published reports for this result.

Thank you -

[Malbanese]

This is perfect. Thank you!

[Daniel_B · Accepted solution]

The following report will list all workstations in your database with information if they are laptop or desktop and if they have Verdiem installed or not.

If you need further data or modification, we recommend having a look at our database dictionary which is accessible from within the ReportBuilder in Lansweeper 5.2.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  Case When tblAssets.AssetID In (Select tblPortableBattery.AssetID
    From tblPortableBattery) Then 'Laptop' Else 'Desktop' End As [machine type],
  Case When tblAssets.AssetID In (Select tblSoftware.AssetID
    From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
        tblSoftware.softID
    Where tblSoftwareUni.softwareName Like '%Verdiem%') Then 'y' Else 'n'
  End As [Verdiem installed]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputersystem On tblComputersystem.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole < 2