Re: How to add multiple computers into collection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hey guys!

Check this out!

http://www.myitforum.com/articles/8/view.asp?id=8651

This is a great console additions that will do what you asked and many more.
It makes life much easier when adding computers to a collection via direct
membership. it aslo give result of your action. Plus, many tools to totally
simplified the SMS administration. Can't live without it and it's sad that
it's not part of the V4 next generation.


"RobM" wrote:

Santos suggested a good solution.

An alternative would be to build queries that expose the
Advertisement, Package and Collection data from the database using WQL
and SMS Queries.

To do this follow these steps:

Create three queries and give them a name, for example:

SMS_Advertisements
SMS_Packages
SMS_Collections

Put the following query code in to the respective query

For the advertisment query insert this WQL query:

select AdvertisementName, AdvertisementID, CollectionID, PackageID,
ProgramName from SMS_Advertisement

For the Collection query insert this WQL query:

select Name, CollectionID from sms_collection

For the Package query insert this WQL query:

select Name, PackageID, StoredPkgVersion, PkgSourcePath from
SMS_Package

Now you can run these queries from the console and see the data you
need. You could modify these queries to expose a whole lot more
information but the above code will reveal what you need for now.

enjoy,

On 7 Dec 2006 20:33:46 -0800, "Pankaj" <pankaj.bapat@xxxxxxxxx> wrote:

Hi Rob,

That was ausumn. fantastic. i got the ids of all the collections.
Thanks a lot.

Can u please let me know what should be technical way of finding out a
collection id supposing that I m not having this script.

Hope u r not irritated by such question. Thanks a lot in advance

Regards,
Pankaj

RobM wrote:
Hi,

No their different, that script will dump the collection names + ID's
for you so you can identify the Collection ID ... just run it and only
specify the sms site servers name. you can run the script with no
arguments and it'll dump the arguments it expects.

On 7 Dec 2006 04:23:15 -0800, "Pankaj" <pankaj.bapat@xxxxxxxxx> wrote:

Hi Rob,

how do i find collection ID? I know name of the collection. Is it the
same?

Regards,
Pankaj

RobM wrote:
theres a great vbs script called colladd.vbs by Mark Nunn that
automates population of a collection with direct membership rules:

http://www.myitforum.com/inc/upload/8200colladd.zip

launch it via a cmd prompt using cscript

cscript /nologo Colladd.vbs smsserver filename collectionID


On 6 Dec 2006 23:03:49 -0800, "Pankaj" <pankaj.bapat@xxxxxxxxx> wrote:

Dear All,

We are using SMS 2003 in our organization. Our SMS administrator
created a collection and asked me to add computers into it. There are
bout 250 computers need to be added. Does anybody have a simple
solution or script to this. Pls let mw know if you hav 1. I am a
newcomer to SMS.

Regards,
Pankaj
-

Rob - Windows Management User Group

www.wmug.co.uk
-

Rob - Windows Management User Group

www.wmug.co.uk
-

Rob - Windows Management User Group

www.wmug.co.uk

.



Relevant Pages

  • Re: How to add multiple computers into collection
    ... An alternative would be to build queries that expose the ... Package and Collection data from the database using WQL ... Put the following query code in to the respective query ... specify the sms site servers name. ...
    (microsoft.public.sms.admin)
  • RE: Scripting Export List for a Query
    ... SMS console... ... When I wrote the next script to make an export, using the same query into ... Dim Location ...
    (microsoft.public.sms.misc)
  • RE: Out of memory exception
    ... Why not just try the script with each query in a separate batch? ... basically there are many thousand of these queries in a single file, ...
    (microsoft.public.sqlserver.programming)
  • Re: Context menu in private queries.
    ... > Hey, I had this question in my old SMS Trainer FAQ for 2.0, but I bet it ... I got my query results in the query window. ... in predefine queries when I right click on PC I ... >> heve big context menu and can directly use RemoteTools. ...
    (microsoft.public.sms.admin)
  • Re: Creating Query
    ... Do you have any docs on creating queries for SMS. ... > Your query is actually a subtle variation on a popular query theme we ... >> I would like to create a query for machines that have both Acrobat.exe ...
    (microsoft.public.sms.misc)