Report for hard disk manufacturer

[DunnCarney]

Hi all,

We need a report for drive manufacturer but seem to be struggling with it. The best we can get is a combination of serial number and size. Any pointers re: table?

Secondly, we need a report for a video card manufacturer but again, seems to be eluding us.

[RCorbeil]

You should be able to derive the manufacturer from the model number if you link against tblFloppy.

  ...
  tblFloppy.InterfaceType As Interface,
  Replace(tblFloppy.Name, '\\.\PHYSICALDRIVE', 'Physical Drive ') As Drive,
  Case
    When tblFloppy.Model Like 'ST%' Then 'Seagate'
    When tblFloppy.Model Like 'WDC%' Then 'Western Digital'
    When tblFloppy.Model Like 'WD %' Then 'Western Digital'
    When tblFloppy.Model Like 'TOSHIBA%' Then 'Toshiba'
    When tblFloppy.Model Like 'FUJITSU%' Then 'Fujitsu'
    When tblFloppy.Model Like 'INTEL%' Then 'Intel'
    When tblFloppy.Model Like 'Hitachi%' Then 'Hitachi'
    When tblFloppy.Model Like 'HDT%' Then 'Hitachi'
    When tblFloppy.Model Like 'SAMSUNG%' Then 'Samsung'
    When tblFloppy.Model Like 'Maxtor%' Then 'Maxtor'
    Else ''
  End As [Drive Make],
  tblFloppy.Model As [Drive Model],
  ...

You may need to update the list from time to time, but from what I've seen there is general consistency to the start of model numbers.

[Hemoco · Accepted solution]

Lansweeper does not currently scan drive or video card manufacturer data unfortunately, so you cannot report on this information. For most video cards, you should be able to determine the manufacturer based on the card name. Example: NVIDIA Quadro FX 2700M. The name is stored in tblVideoController.Caption.