‎01-30-2013 09:27 PM
Solved! Go to Solution.
‎01-31-2013 10:24 PM
Select Top 1000000 tsysOS.Image as Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPaddress,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS on tblAssets.OScode = tsysOS.OScode
Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
Where tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes = 10
Order By tblAssets.AssetUnique
‎03-01-2013 12:16 PM
Select Top 1000000 tsysOS.Image As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPAddress,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where (tblFileVersions.FilePathfull Like '%iexplore.exe' And
tblSystemEnclosure.ChassisTypes = 😎 Or
(tblFileVersions.FilePathfull Like '%iexplore.exe' And
tblSystemEnclosure.ChassisTypes = 10)
Order By tblAssets.AssetUnique
‎01-31-2013 10:41 PM
‎01-31-2013 10:24 PM
Select Top 1000000 tsysOS.Image as Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPaddress,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS on tblAssets.OScode = tsysOS.OScode
Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
Where tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes = 10
Order By tblAssets.AssetUnique
‎02-27-2013 12:42 AM
Lansweeper wrote:
Please try the report below.Select Top 1000000 tsysOS.Image as Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
TsysChassisTypes.ChassisName,
tsysOS.OSname,
tblAssets.SP,
tblAssets.IPaddress,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS on tblAssets.OScode = tsysOS.OScode
Inner Join tblSystemEnclosure On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes
Where tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes = 10
Order By tblAssets.AssetUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now