‎09-14-2016 11:46 AM
‎09-16-2016 12:05 PM
‎09-16-2016 08:16 PM
helpdesk_txt wrote:
another question please, I filtered the machine to get out only the VM ,, where Model like '%Virt%.
do you knwo how and what table JOIN to get out their Virtual Host?
many thanks.
‎09-16-2016 11:57 AM
‎09-15-2016 09:36 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1 And tblAssets.LastIPScan Is Null And
tblAssets.LastLsPush Is Null
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now