Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SCCM 2007 - Import CSV to Populate Collection

Posted on 2014-01-24
26
Medium Priority
?
2,094 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 14
  • 6
  • 5
  • +1
26 Comments
 
LVL 23

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 23

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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 23

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 23

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 23

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 23

Expert Comment

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

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 23

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
 
LVL 23

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 23

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 23

Accepted Solution

by:
yo_bee earned 1500 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
 
LVL 23

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 23

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 23

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 Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

636 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