‎08-05-2015 08:46 AM
Solved! Go to Solution.
‎08-10-2015 09:34 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
Case When tblAssetCustom.Custom1 = 'yes' Then 'yes' Else 'no'
End As [MS Project install allowed]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssetCustom.AssetID In (Select
tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Microsoft project %')
Order By tblAssets.AssetName
‎08-11-2015 04:18 AM
‎08-10-2015 09:34 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
Case When tblAssetCustom.Custom1 = 'yes' Then 'yes' Else 'no'
End As [MS Project install allowed]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssetCustom.AssetID In (Select
tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftware.softID =
tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Microsoft project %')
Order By tblAssets.AssetName
‎08-10-2015 03:06 AM
‎08-06-2015 11:52 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
Case When tblAssetCustom.Custom1 = 'yes' Then 'yes' Else 'no'
End As [MS Project install allowed]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1 And tblAssets.Assettype = -1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now