Create Direct Membership Based on PC Serial Number
https://social.technet.microsoft.com/Forums/systemcenter/en-US/6f998293-c7b5-484c-981d-55723c9bb0ea/create-direct-membership-based-on-pc-serial-number?forum=configmgrswdist
 
The problem is, the solution for this is based on SCCM 2007 and an older version of Right Click Tools.
 
What I'm looking to do is to create a Collection based on serial numbers. I have a spreadsheet containing 5700 devices, but by serial number only. I need to convert that into the asset name.
 
Thank you
August 25th, 2015 12:10pm

ok, I will bite, what are you going to do this a DM collection of 5700 computer? keep in mind that this will be a HUGE DM collection, and heck it will like break long before you get all 5700 computer into it.

BTW if it worked in CM07, it will work in CM12. You might however have to edit the xml files yourself.

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 12:52pm

Hi Garth,

Thanks for the reply. Yes, I do plan to create a DM collection (or a few, since, I agree, all 5700 in 1 collection would be silly).

The problem is, the solution in CM07 doesn't apply to CM12 that I can see. The CM07 solution references <SCCM install folder>AdminUI\XmlStorage\Tools but that folder doesn't exist in CM12.

August 25th, 2015 3:22pm

That right you will have to create that folder, add the hta to that folder and edit the xml files too.

I would personally look at a different way to do this. 100 DM is a lot for a collection. What is the point of these collections?

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 3:42pm

The company I'm currently consulting for outsources their device lease and purchase information.

They recently received a spreadsheet back from the outsourcing company that contained, in their words, far too many machines. They don't want to have to pay for all these machines, so they want me to go into SCCM and see what's what.

Unfortunately, this spreadsheet only contains the serial number of all devices.

My job is to plug this spreadsheet into SCCM and convert the serial numbers to device names, which I can then run reports on.

August 25th, 2015 3:50pm

What does that have to do with creating collections?

This should be a SQL query or report at most. Or extract the data from ConfigMgr and plug it into Excel along with the spreadsheet from the vendor.

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 4:26pm

Hi Jason,

Thanks for the reply. I mentioned creating a collection because the CM07 solution references using Right Click Tools, which puts the computers as serial numbers and converts them into asset names.

I'm really not sure how you could create an SQL query or report based on 5700 machines that would convert the serial number to asset name.

August 25th, 2015 4:40pm

Thanks for the reply. I mentioned creating a collection because the CM07 solution references using Right Click Tools, which puts the computers as serial numbers and converts them into asset names.

I'm really not sure how you could create an SQL query or report based on 5700 machines that would convert the serial number to asset name.

I'm with Jason on this, I would turn this into a SQL query/report. This allow for the data to be dynamic, if the excel file is updated you can quickly update the sources files. Tying a SN to a Computer name is fairly easy but it will depend on make and model of computer.

Really, you need to look at excel file to see exactly what data you have.

Then you need to understand exactly what reports that want. my guess would be:

  • What computers are within Excel but not in CM12
  • List basic details for all computers within Excel

Having a DM collect base SN is a problem for lots of reasons but one of the biggest, is that if the ResourceID of any computer changes, they will not longer be part of that collection and therefore throw off everything.

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2015 5:07pm

I had to do something similar to this a while back.

My first action was to create a simple report showing the device name and both the serial numbers from the PC BIOS as well as the System Enclosure and exported that to Excel.  Then I did some VLOOKUPS to try and match the data.  This worked fairly well, but the data kept changing so it became a tedious job.

I ended up creating a temp table in SQL with the data from the excel sheet and used this as a lookup table against my devices.  I don't know if this is the best option, but it worked for what I needed to do.

August 26th, 2015 4:20am

"Best" is always in the eye of the beholder, but what Jacques outlined above is the better path to take and certainly (more or less) what I would do also (and have done in
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2015 4:34am

Thank you Garth. That's what I'll end up doing.
August 27th, 2015 12:32pm

Thanks Jason. I'll go this route.
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 12:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics