• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2118
  • Last Modified:

SCCM 2007 - Import CSV to Populate Collection

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
rmessing171
Asked:
rmessing171
  • 14
  • 6
  • 5
  • +1
1 Solution
 
yo_beeDirector of ITCommented:
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
 
rmessing171Author Commented:
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
 
yo_beeDirector of ITCommented:
is there anything that is common between these machines.
OU's, Model, makes.  Anything that can be queried?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
rmessing171Author Commented:
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
 
yo_beeDirector of ITCommented:
You have stated that your imported them during the OS Deployment with the Name TEST1 , TEST2, Etc...
Is that right?
0
 
rmessing171Author Commented:
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
 
yo_beeDirector of ITCommented:
My questions is "Do all the computers start with Test? as your example illustrate."
0
 
rmessing171Author Commented:
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
 
yo_beeDirector of ITCommented:
Not sure what your goal is then with the production machines?
Is there an OU that you can use as a filter?
0
 
yo_beeDirector of ITCommented:
could you post the CSV.
0
 
yo_beeDirector of ITCommented:
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
 
yo_beeDirector of ITCommented:
Are you still interested is assistance with this issue?
0
 
dadiehl04Commented:
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
 
yo_beeDirector of ITCommented:
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
 
dadiehl04Commented:
you bet.. thanks.. that seems to be the way to handle this kind of scenerio.

Thanks!
0
 
yo_beeDirector of ITCommented:
do you need help with the script.
0
 
dadiehl04Commented:
i don't see your script posted
0
 
yo_beeDirector of ITCommented:
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
 
dadiehl04Commented:
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
 
yo_beeDirector of ITCommented:
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
 
dadiehl04Commented:
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
 
rmessing171Author Commented:
Sorry for the delay, but I am still having an issue importing from a CSV file to a Collection.
0
 
yo_beeDirector of ITCommented:
What is the issue?
I see that you gave me points for the second part of the questions 39833401,
0
 
Keyennar nCommented:
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
 
yo_beeDirector of ITCommented:
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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

  • 14
  • 6
  • 5
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now