‎01-22-2015 03:43 PM
Solved! Go to Solution.
‎01-23-2015 08:45 AM
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
‎01-23-2015 02:51 PM
‎01-23-2015 08:45 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now