Solved

SCCM 2007 - Import CSV to Populate Collection

Posted on 2014-01-24
26
1,951 Views
Last Modified: 2015-09-16
I have a list of 186 computers all currently registered in SCCM 2007 with Client=YES and Active=YES.  I would like to add all 186 computers to a new Collection named HP TEST.  I have a CSV file in the Computername, SMBIOS GUID format listed below:


TEST1-LPTP,8057197D-5008-11E4-B1B5-C5E6F40280E1
TEST2-LPTP,76D1C2D7-5008-11E4-95A3-C5DE5C0D5006
TEST3-LPTP,BE0E6F42-474F-11E2-843B-A3C45F06007A

It seems that I am successfully importing the CSV file correctly via Operating System Deployment> Computer Association> Import Computer Information, however after I perform an "Update Collection Membership" on the HP TEST collection, it shows no computers and is empty.  Any thoughts?  Is there somethings I check?
0
Comment
Question by:rmessing171
  • 14
  • 6
  • 5
  • +1
26 Comments
 
LVL 21

Expert Comment

by:yo_bee
ID: 39808766
You do not need or should have to import any items via CSV if they are already in the CCM System.  You will need to create a Query to find all Items/Objects that meet the query crietera.

Here are the steps you need to follow.
Step1: Locate the Collection and Right Click > Properties
CCM1
Step2: Select the New Query Wizard Button
CMM2
Step3: Import a stanard Query from SCCM.
Name it
Press Import and select from the list (I recommend ALL CLIENTS SYSTEMS)
CMM3CCM4
Step 4: Edit the Query
Press Edit Query Statement

CCM5
Step5: Select the Tab that says Crietera and press the New Crietera Button
CCM6
Stepg: Select the Attributes.
Attribute Class: Select Computer System
Alais: leave alone
Attribute: Name
CMM6-1
Step7: Criterion Properties. This is how you will filter
Criterion Type: Leave as Simple Value
Where: Should say Computer System - Name (created From the Previous Step)
Operator: is Like
Value: Test% (this is a wild card value for any computer name that starts with Test)
CCM7
Step8: You should see the new Creitera appended.
Option: Press Show Query Language if you want to see what the SQL statement looks like.
Press OK
CCm8
Step9: Option if you want to edit the creitera press the icon with the hand next to the new query wizard button then repeat the previous steps
CCM9
0
 

Author Comment

by:rmessing171
ID: 39812283
Thank you for this info, however it is not going to help me because all of the computernames in my company are all named entirely unique.  I thought there was a way I could import a CSV file with computernames into a specified collection?
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39812334
is there anything that is common between these machines.
OU's, Model, makes.  Anything that can be queried?
0
 

Author Comment

by:rmessing171
ID: 39812349
Unfortunately not.  I also deploying a package in phases to 50 laptops at a time.  Importing a CSV file of computernames would be ideal.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39812386
You have stated that your imported them during the OS Deployment with the Name TEST1 , TEST2, Etc...
Is that right?
0
 

Author Comment

by:rmessing171
ID: 39812554
Thank you for the quick reply.  I have a CSV file with the computername and each computername's associated SMBIOS number.  The CSV file looks like below:

TEST1-LPTP,8057197D-5008-11E4-B1B5-C5E6F40280E1
TEST2-LPTP,76D1C2D7-5008-11E4-95A3-C5DE5C0D5006
TEST3-LPTP,BE0E6F42-474F-11E2-843B-A3C45F06007A

When I perform the import of the file, it looks like it is importing the information, however when I look at the Collection I specified to import to, the computernames are not present.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39812819
My questions is "Do all the computers start with Test? as your example illustrate."
0
 

Author Comment

by:rmessing171
ID: 39812881
Unfortunately not they do not start with Test in the computernames.  The TEST computernames for only for my lab.  All of the computernames in PROD are tied to the user's initials.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39813277
Not sure what your goal is then with the production machines?
Is there an OU that you can use as a filter?
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39814904
could you post the CSV.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39816762
You could created a new AD group and import the computer objects into the group using power shell.  Once the group is populated you can query the security group in SCCM to add to the collection.

I will post the Power shell script tomorrow.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39829277
Are you still interested is assistance with this issue?
0
 

Expert Comment

by:dadiehl04
ID: 39830825
i need to create a collection as well .. without using a query from sccm.
i have a list of users that are unique to HR database.. sccm cannot query on their properity.. so i thought i could IMPORT A TARGET LIST of users and make that a collection..

which seems to be difficult.

In landesk, we used a tool to convert a csv into a query statement, saved it as xml, then imported it into landesk, viola, instand query statement.  I'm not on a landesk box, i'm just saying the BUSINESS NEED is there and it's hard to believe sccm techs don't have a graceful solution.

It's vain to think that sccm can query on anything.. and that we don't NEED an alternative way to populate a list of devices or users we want to target with an action like an inventory report or an app deployment.

furstrated but still hopeful :)

and interested in powershell script as mentioned above.
$ ?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 21

Expert Comment

by:yo_bee
ID: 39833163
Here is an option can you create a security group using powershell from your list in AD?
If so then you can leverage SCCM auditing of AD to create the collection based on security groups.

We do that in our environment.

Does that sound like a viable solution then you update the security group as needed to address the collection.
0
 

Expert Comment

by:dadiehl04
ID: 39833174
you bet.. thanks.. that seems to be the way to handle this kind of scenerio.

Thanks!
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39833203
do you need help with the script.
0
 

Expert Comment

by:dadiehl04
ID: 39833329
i don't see your script posted
0
 
LVL 21

Accepted Solution

by:
yo_bee earned 500 total points
ID: 39833378
I never posted it?
I was asking if you wanted help with writing the script?

If so I would open a New Question under the same Category


This is someone else questions and they have not given any feedback as of yet.
So if I give you the Answer/Solution there will be no points awarded which is sort of unfar.

Once Opened Copy and paste the question link here and I will follow you and answer it there.

It may sound petty, but I only think it is far.
0
 

Expert Comment

by:dadiehl04
ID: 39833388
yep.. i was wondering how to "award a right answer" since i wasn't the poster.. i understand...

on the script.. i'll check w/ domain services in my company.. i'm sure they have a script already... I work DESKOP/SCCM and don't typically have rights to AD groups :)

thanks for your help.. will open a new thread as you suggested
0
 

Expert Comment

by:dadiehl04
ID: 39833401
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39833402
No Problem.

If you do come up with the question that is relevant to this one and you want help I will be more than happy to assist.

One the comment about rights.
If you do not have rights to create the group or add then as script will be useless until get  DS group to create a group and make you a delegate so you can update this group on a need be basis.

Does that help at all?
0
 

Expert Comment

by:dadiehl04
ID: 39833635
yep.. thanks.. we use dra's Netiq which is just a bundle of joy to manage our AD groups.  I'm not sure command lines work over netiq ... i can become a delegate or "peak over someone's shoulder that has rights" to get it done.
0
 

Author Comment

by:rmessing171
ID: 39904735
Sorry for the delay, but I am still having an issue importing from a CSV file to a Collection.
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 39906481
What is the issue?
I see that you gave me points for the second part of the questions 39833401,
0
 

Expert Comment

by:Keyennar n
ID: 40979695
Hi All,

I have a list of computers named uniquely. how can I create collection? do I have option to Import as a excel file?

Regards,
Nalla
0
 
LVL 21

Expert Comment

by:yo_bee
ID: 40979738
Did you see my solution that was accepted
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_28356291.html

Do you have SQL scripting knowledge?  You could add a custom table to SCCM DB, import the CSV data then build a query, but I have not done this and would recommend that you backup the database prior to do any modifications to  it.

If you rather send me a Private Message to continue this conversation rather than post to an already closed question I am open to that.
0

Featured Post

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Join & Write a Comment

Suggested Solutions

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now