A VBScript that will obtain the current value of the SDK Site Control File Serial number from a specified SMS site server, for a specified SMS site servers site sode and change it to a value specified on the command line.
Use this script only after you understand the underlying concepts of SDK values for Site Control files, their location in the registry, their purpose and the implications of changing them. Google Is Your Friend, so is Technet.
This is useful for changing the SDK to that lower than the value set by a parent\grand-parent SMS site server, so that Type 2 Site Control file Delta's are processed correctly by the child SMS site server and not rejected\ignored.
To determine if you have a build-up of Type 2 Site Control files, go to your Central SMS Site server, open ISQLW (SQL Query Analyzer) then change the focus to your SMS database, then type in and execute the following SQL command:
Select SiteCode, TypeFlag, SerialNumber from SiteControl where TypeFlag = '2'
If any rows are returned, you can always visit the SMS site server that these Deltas are destined for, open the SiteCtrl.log file and see if any references are made to Site Control files being ignored due to them having an older Delta value.
The delta site control file "D:\SMS\inboxes\sitectrl.box\incoming\zwfbgc5o.CT1" contains a record submitted by the SMS Administrator Console running as user <DOMAIN>\<USER> on computer <COMPUTER> at site <SITECODE> via the SMS SDK on Tue Jan 15 10:23:17 GMT. The record was assigned the serial number 2 at site <SITECODE>.
SMS_SITE_CONTROL_MANAGER will ignore this record because it was already processed as part of an older delta site control file. SMS_SITE_CONTROL_MANAGER
The first line tells you who, where and when the site control file originated from. It also tells you what SDK Delta this Site Control File change was given. The last Delta to be processed is recorded as the minimum value +1 for the next Delta that comes in. If the next Delta is lower it is ignored, as per the second line above. Just change the last known Delta value using this tool to that lower than the Delta being rejected, and it will be processed when the Delta is replicated to the server (every 1hr).
This is a loose and fast description of the entire process, please do read up and understand this subject before you use the tool. Otherwise you could be scratching your head wondering why the Site Control Manager is not processing your Site Control file changes.
02/04/2008 - Script wasn't working, a sitecode was hard-coded in, resolved so sitecode specified on command line is used. Sorry!