cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nagendra
Engaged Sweeper II
i need to generate a report with these fields


Hostname
MotherBoard Make
MotherBoard Model
System serial no
Processor
Processor Speed
Processor Core
Installed Memory
Graphics Card
Graphics Card Serial No
HDD 0
HDD 1
HDD 2
HDD 3
HDD 4
Monitor1 Model
Monitor1 Serial No
Monitor2 Model
Monitor2 Serial No
Monitor3 Model
Monitor3 Serial No
Operating System
System serial no
Motherboard Serial NO
3 REPLIES 3
Esben_D
Lansweeper Employee
Lansweeper Employee
Just a general note, but getting help on reports is easier when you give people something to continue with. If you ask for a complete report with a list of items, you won't quickly get a response since it requires more work from the person trying to help.

If you search for hardware reports on the forum (or google) you'll find examples of hardware reports. Additionally, you can use parts from built-in reports.

For your specific report, I'll list the tables you can use in your report to get the information:
  • tblBIOS
  • tblAssets
  • tblAssetCustom
  • tblPrcessor
  • tblVideoController
  • tblDiskdrives
  • tblMonitor
Do note that your report will get multiple lines per device, if a device has multiple monitors or hard drives, SQL will create multiple records for each unique value.
nagendra
Engaged Sweeper II
Team Please help i need this report..
nagendra
Engaged Sweeper II
this report should work on Version 6.0

nagendra wrote:
i need to generate a report with these fields


Hostname
MotherBoard Make
MotherBoard Model
System serial no
Processor
Processor Speed
Processor Core
Installed Memory
Graphics Card
Graphics Card Serial No
HDD 0
HDD 1
HDD 2
HDD 3
HDD 4
Monitor1 Model
Monitor1 Serial No
Monitor2 Model
Monitor2 Serial No
Monitor3 Model
Monitor3 Serial No
Operating System
System serial no
Motherboard Serial NO