White Boxes came with same Serial Number

Larry Whittaker · 06-30-2008, 12:06 PM

We have over 4,000 machines. In addition to buying Dell, HP or some other main brand system we also have a vendor that provided a white box. The vendor used their company name as the serial number to all systems that were purchased.

There are close to 1,000 different systems with the same Serial Number.

I would like to disable the AEXSNPLUS/SN Agent from scanning the systems for Serial Number.

Any Ideas on how to do this?

EMercado · 06-30-2008, 12:46 PM

I'd say you put them in a collection, and restrict that collection from running any inventory tasks where aexsnplus is being called. Hopefully they have something in the BIOS (asset tag, model, etc) that you can use to put them in the proper collections.

Nick · 06-30-2008, 01:17 PM

Thought about seeing if the vendor will provide you with a tool to change them or maybe using wmi to do so?

Larry Whittaker · 07-02-2008, 12:35 PM

Update.
White box vendor said there is nothing they can do now. In future they will asssign a Serial Number.

Still trying to find out if I can disable the SN scan.

Nick · 07-02-2008, 12:48 PM

Larry,

Have you thought about doing some custom sql and changing the SN for all the white boxes to be something like their MAC address within the respective table.

Larry Whittaker · 07-02-2008, 01:47 PM

Nick,
It sounds like that would work out good. Customizing SQL to do this would be the hardest part. I think this is the direction I shouldl go.
Thanks
Larry

Flatdog · 07-02-2008, 03:33 PM

If CMDB is installed run these both in sql if only cms run the latter.
The easiest way to automate this is to create a new report using the following sql code and schedule the report
to run after everytime the S/N scan runs.
*Report will not produce any results

REPLACE: = 'WhiteBoxVendorName' with actual vendor name

Code:

 
--If CMDB IS Installed
UPDATE dbo.Inv_Serial_Number  
SET [Serial Number] = ( SELECT dbo.Inv_AeX_AC_TCPIP.[Mac Address]
FROM dbo.Inv_AeX_AC_TCPIP
WHERE dbo.Inv_AeX_AC_TCPIP._ResourceGuid = dbo.Inv_Serial_Number._ResourceGuid)
WHERE [Serial Number] = 'WhiteBoxVendorName'

Code:

 
-- For CMS
UPDATE dbo.Inv_AeX_HW_Serial_Number  
SET [Serial Number] = ( SELECT dbo.Inv_AeX_AC_TCPIP.[Mac Address]
FROM dbo.Inv_AeX_AC_TCPIP
WHERE dbo.Inv_AeX_AC_TCPIP._ResourceGuid = dbo.Inv_AeX_HW_Serial_Number._ResourceGuid)
WHERE [Serial Number] = 'WhiteBoxVendorName'