cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
malbanese1
Engaged Sweeper II
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 -
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
Malbanese
Engaged Sweeper III
This is perfect. Thank you!
Daniel_B
Lansweeper Alumni
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