→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DunnCarney
Engaged Sweeper
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.

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

2 REPLIES 2
RCorbeil
Honored Sweeper II
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
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now