In need of report for Premium version

[campch5]

Could someone assist with finding these fields for me, I am new at lansweeper and not familiar with the field names.

Hostname
Last user logged in
Service Tag / Serial Number
Date of manufacture / Purchase date / Ship date (any of them will do)
End of warranty date
Platform (desktop, laptop, server, etc)
Make
Model
OS
CPU
MAC Address
Physical or Virtual?

Filtered by only machines in the itserve domain.

[campch5]

Thanks! This helped a lot, I was able to pull a report with our 3100 computers! It will make finding purchase dates so much easier.

[Hemoco · Accepted solution]

Please try the report below for this.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Serialnumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
TsysChassisTypes.ChassisName As Chassis,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblOperatingsystem.Caption As OS,
tblAssets.Processor,
tblNetwork.Description As NIC,
tblNetwork.MACaddress,
Case When tblAssetCustom.Model Like '%virtual%' Then 'virtual' Else 'physical'
End As VirtualCheck,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
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 tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblAssetCustom.State = 1 And tblNetwork.IPEnabled = 1
Order By tblAssets.Domain,
tblAssets.AssetName

[campch5]

Any ideas guys?