‎09-09-2015 11:12 PM
Select Top 1000000 upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_tblComputers.Domain,
upgrade_Web40OSName.OSname,
upgrade_tblOperatingsystem.Description,
upgrade_tblServices.Lastchanged,
upgrade_Web40OSName.Compimage As icon
From upgrade_tblComputers
Inner Join upgrade_tblServices On upgrade_tblComputers.Computername =
upgrade_tblServices.Computername
Inner Join upgrade_web40ActiveComputers On upgrade_tblComputers.Computername =
upgrade_web40ActiveComputers.Computername
Inner Join upgrade_Web40OSName On upgrade_Web40OSName.Computername =
upgrade_tblComputers.Computername
Inner Join upgrade_tblOperatingsystem On upgrade_tblComputers.Computername =
upgrade_tblOperatingsystem.Computername
Where upgrade_tblServices.Caption Like '%LansweeperRC%' And
upgrade_tblServices.Started = 1
Order By upgrade_tblComputers.Computer
Solved! Go to Solution.
‎09-12-2015 12:09 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tblServicesUni.Caption Like '%LansweeperRC%'
And tblServices.Started = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎09-12-2015 12:09 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1 And tblServicesUni.Caption Like '%LansweeperRC%'
And tblServices.Started = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now