Query a SQL server then add the results to a Collection in Configuration Manager 2007(SCCM/ConfigMgr)

Here is a powershell script I wrote that will be run on a schedule in ConfigMgr and does the following:
1.  Removes all members of groups specified by their Collection ID
2.  Queries a remote SQL server for a listing of server names, followed by their appropriate Collection ID
3.  Adds the members to the Collections specified in the SQL database
4.  Writes to an error log for servers that are not found in SCCM
 
Here is the Script:
Advertisements

One response to “Query a SQL server then add the results to a Collection in Configuration Manager 2007(SCCM/ConfigMgr)

  1. It iis based on computer with electrographic sensor technology.
    Age Level – A good factor to write about is the appropriate age level for the video game
    that you are reviewing. But what happens when a player runs out of race tokens.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s