Query for Maxtor hard drive

I'm a newbe & most of what I've learned was coppied from forums. I need
to query for Maxtor hard drives due to their high failure rate so I can
turn on Smart. I found it in Resource Explorer under
hardware/manufacture & also under PNP.
When I run this query (see below) I get standard disk drive on most of
the 1400 machines. I know there more because I see them in Resource
Explorer

select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion,
SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName,
SMS_R_System.NetbiosName, SMS_G_System_PC_BIOS.Description,
SMS_G_System_PC_BIOS.Manufacturer, SMS_G_System_PC_BIOS.SerialNumber,
SMS_G_System_PC_BIOS.*, SMS_G_System_DISK.PNPDeviceID,
SMS_GEH_System_DISK.Manufacturer from SMS_R_System inner join
SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_DISK on
SMS_G_System_DISK.ResourceID = SMS_R_System.ResourceId inner join
SMS_GEH_System_DISK on SMS_GEH_System_DISK.ResourceID =
SMS_R_System.ResourceId where SMS_R_System.Client = 1 or
SMS_G_System_DISK.Manufacturer in ( "%maxtor%" ) order by
SMS_G_System_DISK.PNPDeviceID, SMS_GEH_System_DISK.Manufacturer

.

Relevant Pages

  • Re: Resource Explorer questions
    ... I am afraid that the most likely explanation is that your query is not ... The fact that it shows up in resource explorer is proof that it ... And if it is in the database it should show up in ... > NAME...And only two machines showed up, however if I do a Resource Explorer ...
    (microsoft.public.sms.admin)
  • Re: Noidmif file not showing after upgrade
    ... database as you can extract it using a query but it doesn't show in the ... Resource Explorer; never got a resolution. ... Windows Server System SMS - MVP ...
    (microsoft.public.sms.admin)
  • Re: Query for Maxtor hard drive
    ... Here's a query that should help (this is WQL for a console query, ... After you paste this into a new query in the console, look at the design ... I found it in Resource Explorer under ...
    (microsoft.public.sms.inventory)
  • Re: Software inventory problem
    ... I do both query and resource explorer ... > Have you tried running Inventory again? ...
    (microsoft.public.sms.setup)