Barcode and Extra Details in Computer: System configuration overview Report

[moss]

Hi Lansweeper Admin,

Is there a way that the report "Computer: System configuration overview" can be edited so that it can also pickup the Below details in addition to the normal specifications:

State:
Bar Code:
Order number:
Location:
Building:
Department:
Last Saved:
and Comments Field:

Many Thanks,
Moss

[moss]

Thanks Lansweeper Admin,

This works perfectly...:)

[Hemoco]

Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, Web40OSName.Compimage As icon,
dbo.tblComputers.Domain, Web40OSName.OSname, dbo.tblComputers.Description,
dbo.tblComputers.Username, dbo.tblComputers.Userdomain,
web40CorrectMemory.Memory As Memory, Cast(Cast(Cast(dbo.tblDiskdrives.Size As
bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [Disk size],
dbo.web40ProcessorCapacity.NrOfProcessors, dbo.web40ProcessorCapacity.CPU,
tblComputerSystemProduct.Name As Model, tblComputerSystemProduct.Vendor As
Manufacturer, tblComputerSystemProduct.IdentifyingNumber As Serial,
dbo.tblComputers.LastknownIP As [IP Address], tblCompCustom.PurchaseDate,
tblCompCustom.Warrantydate, tblstate.Statename, tblCompCustom.BarCode,
tblCompCustom.OrderNumber, tblCompCustom.Location, tblCompCustom.Building,
tblCompCustom.Department, tblCompCustom.Comments, tblCompCustom.Lastsaved
From dbo.tblComputers Inner Join
dbo.tblDiskdrives On dbo.tblComputers.Computername =
dbo.tblDiskdrives.Computername Left Outer Join
dbo.web40ProcessorCapacity On dbo.tblComputers.Computername =
dbo.web40ProcessorCapacity.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
dbo.tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
tblComputerSystemProduct On dbo.tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On dbo.tblComputers.Computername = tblCompCustom.Computername
Left Join
tblstate On tblstate.State = tblCompCustom.State
Where dbo.tblDiskdrives.Caption = 'c:'
Order By dbo.tblComputers.Computername

[moss]

Hi,

Do you have a format please. I am not that good at coding.

[Hemoco]

Hi, sure you can edit it with the report builder.