Asset Management Suite

 View Only

Data Remediation Part V: Cleaning Up Duplicate Serial Numbers 

Nov 16, 2007 10:06 AM

As outlined in the article majoris, or major article, a number of causes can lend to having duplicates exist in your environment. Some are easy to remediate others, not so much. Since working with Altiris, we've developed some very good merge scripts and identifiers of data to help you on your way. The nature of all the previous merge scripts and reports only took into account one attribute for a resource - serial number. I've shown previously where you may have in your environment 2 or more unique resources reporting the same serial number. In this instance, if you were to merge these computers, you would essentially loose a computer because they are in fact unique assets, they just have a slight identity issue with giving you the correct serial number. Well, one way to fix this is to compare serial number, which should be a unique value, with another identifiable & unique value for each computer... like MAC address. Using a combination of these 2 attributes, you can clearly identify if assets which happen to be reporting the same serial number are reporting the same MAC address. If they are, your odds that they are identical computers are pretty darn high, go play Powerball tonight if you're feeling lucky. Since they are the same assets you would more than likely want to merge the 2 to clean-up your NSs. The attachment will show/allow you:

  • Computers With Duplicate Serial Number & MAC Address
  • Show the oldest of the Computers with Duplicate Serial Number & MAC Address of the pair from the previous report
  • Allow you to merge the computers with the same serial numbers and MAC address
License: AJSL
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
Support: User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.


Data Remediation Part IV: Duplicate Serial Numbers From Asset


Data Remediation Part VI: Serial Number Comparisons

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
zip file
Duplicate Serial Numbers & MAC Addresses.zip   6 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Related Entries and Links

No Related Resource entered.