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,933  
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 Hyper-V guests dissapeared and reappeared
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:30:47 PM(UTC)
Lansweeper DB cleanup script
by  William382  
Go to last post Go to first unread
Last post: Yesterday at 4:23:43 PM(UTC)
Lansweeper Installing MS KB with Deploy
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 4:01:45 PM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls  
Go to last post Go to first unread
Last post: Yesterday at 3:27:44 PM(UTC)
Lansweeper Asset Checkboxes in reports
by  ufficioced   Go to last post Go to first unread
Last post: Yesterday at 1:22:17 PM(UTC)
Lansweeper Silent "Run as logged in user" option
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 3:45:25 AM(UTC)
Lansweeper New ticket creation not emailing the user
by  MVMIC IT LANSWEEPER   Go to last post Go to first unread
Last post: 11/15/2019 5:36:23 PM(UTC)