This page will go though how to create a "Microsoft System Center Configuration Manager 2007" collection that contains all systems that do not have a specific exe file at a certain version present on any local drive.

I personally use this method to distribute software to systems that either do that have it already or have an old version installed.

I recently needed to migrate our Citrix data store from a MS Access database to Microsoft SQL Server 2005 (32-Bit), this document shows the steps I went though.

Step 1
Before starting I created a backup of my data store take a look at http://www.geekshangout.com/?q=node/32 for instructions

Step 2
I created a new database and user on the SQL server

Step 3
On one of the Citrix Servers I created a file DSN that pointed to my new SQL database

The below script is an example of how using VBS and ADODB you can perform SQL like queries against Active directory to return or change properties of an object.

In this case the script returns the "Home Drive" on the user "testusername" in the domain "domainname.com"