Notebooks report

[mizquierdo]

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]

Well I added your report to the report editor and added the tblwarranty and tblwarrantydetails. Seems to work just fine.

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