Laptop Report - LanSweeper 4 to LanSweeper 5

[RTedrow]

Hey guys,

Curious is anyone can lend a hand on getting this laptop report working for Lansweeper 5 (I found it in this forum but it looks like it was made for Lansweeper 4). I'd also like help adding a field to it - Last Logged in User .

Ultimately what I'm looking for is a report that pulls down the PCs listed in the Chassis Types: Notebook, Laptop, Portable and then give me the IP and Last Logged in user.

Here is the query below:

Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.Description, TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP, tblComputers.LastknownIP, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblSystemEnclosure On tblComputers.Computername = tblSystemEnclosure.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Where tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes = 10 Order By tblComputers.ComputerUnique

Any help would be appreciated. It looks like tblComputers does not exist anymore.

Thanks!

[Hemoco]

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,
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

[RTedrow]

That did it! I just needed to add chassis type 9 (laptop) to the query and that was exactly what I was looking for. Thanks a lot for the help!

[Hemoco · Accepted solution]

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

[danman]

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

I'm not very familiar with version 5 yet, could you please give me an example of how add found file status to this laptop report?

I have the example:
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblFileVersions.Found,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName,
tblFileVersions.Filesize,
tblFileVersions.CreationDate,
tblFileVersions.LastAccessed,
tblFileVersions.LastModified,
tblFileVersions.Lastchanged
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFileVersions.FilePathfull Like '%iexplore.exe'
Order By tblAssets.AssetUnique,
tblFileVersions.FilePathfull

But can't quite figure out how to combine the two.

Thanks in advance!