Hello! I have a tricky situation. I need to import workstation’s names stored directly in a database table into a collection in SCCM. Using SQL was the only way to get the needed set of names, so please do not ask what type of data I need... long story to tell. I know I can do it manually by coping the table content and adding it with Collection Commander. But this is not a one time action, and I really need a way to automate this. Anyone has an idea how to import these data, preferably without using the scripts? I am using SQL Managenet Studio 2005 9.00.3042.00 and SCCM 2007 version 4.00.6487.2000 Any tips are welcome :)

The only supported way is creating a custom solution (using a script, compiled exe, powershell, whatever) that connects to the database, reads the names and creates the objects in ConfigMgr. The ConfigMgr SDK (http://msdn.microsoft.com/en-us/library/cc145334.aspx) does provide all methods needed. Torsten Meringer | http://www.mssccmfaq.de