Notification

Icon
Error

Notebooks report - Report on Notebooks/laptops with added info

Posted: Thursday, October 17, 2019 4:08:32 PM(UTC)
Martin Izquierdo

Martin Izquierdo

Member Original PosterPosts: 1
0
Like
Hello!

Id like to get a report of all the notebooks and laptops on our company with the following info:

AssetName
Manufacter
Model
Processor
Ram Installed
Windows Version
Shipment date / Warranty status
Last Logon User
is it on Warranty?

i have the following report that i have tried to modify , but i cannot get the "Warranty" part to work , it always says that the "tblWarranty.ShipDate" or anything on that table doesnt exists , when it clearly exists because i can harvest the data from other reports.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName,
tblAssets.IPAddress As IP,
tblAssets.Lastseen,
tblProcessor.Name
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSystemEnclosure On
tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where (tblSoftwareUni.softwareName Like '%Sophos%' Or
tblSoftwareUni.softwareName Like '%Guardian Edge%' Or
tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%'))
And tblAssets.Lastseen <> '' And (TsysChassisTypes.Chassistype = 8 Or
TsysChassisTypes.Chassistype = 9 Or TsysChassisTypes.Chassistype = 10) And
tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

kind regards.
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 10/18/2019 12:40:31 PM(UTC)
Well I added your report to the report editor and added the tblwarranty and tblwarrantydetails. Seems to work just fine.

Code:
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.AssetName,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  TsysChassisTypes.ChassisName,
  tblAssets.IPAddress As IP,
  tblAssets.Lastseen,
  tblProcessor.Name,
  tblWarranty.ShipDate,
  tblWarrantyDetails.WarrantyStartDate,
  tblWarrantyDetails.WarrantyEndDate,
  tblWarrantyDetails.ServiceType,
  tblWarranty.LastWarrantySuccess
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblSystemEnclosure On
    tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Inner Join tblWarranty On tblAssets.AssetID = tblWarranty.AssetId
  Inner Join tblWarrantyDetails On tblWarranty.WarrantyId =
    tblWarrantyDetails.WarrantyId
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
      From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
      Where (tblSoftwareUni.softwareName Like '%Sophos%' Or
          tblSoftwareUni.softwareName Like '%Guardian Edge%' Or
          tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%'))
  And tblAssets.Lastseen <> '' And (TsysChassisTypes.Chassistype = 8 Or
    TsysChassisTypes.Chassistype = 9 Or TsysChassisTypes.Chassistype = 10) And
  tblAssets.Assettype = -1
Order By tblAssets.AssetUnique

Active Discussions

Lansweeper NOT doesn't work as expected
by  KevinA-REJIS   Go to last post Go to first unread
Last post: Yesterday at 5:49:29 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Leslie Stroobant  
Go to last post Go to first unread
Last post: Yesterday at 3:27:42 PM(UTC)
Lansweeper All Devices with WINS Service Running on the Network
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 2:44:56 PM(UTC)
Lansweeper Physical Laptops and Desktops Only
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 1:51:56 PM(UTC)
Lansweeper Assistance With AV & Bitlocker Report
by  Andy.S   Go to last post Go to first unread
Last post: Yesterday at 12:50:47 PM(UTC)
Lansweeper Count of completed KB installation Report
by  jamie21  
Go to last post Go to first unread
Last post: 6/4/2020 11:49:57 AM(UTC)
Lansweeper local admin users of a specific device
by  Andy.S   Go to last post Go to first unread
Last post: 6/4/2020 10:42:23 AM(UTC)
Lansweeper Bitlocker Report not contain all computers
by  Andy.S  
Go to last post Go to first unread
Last post: 6/3/2020 6:20:53 PM(UTC)