I have run into a few CI update problems over the last few months. It seems that these are becoming more frequent. I found the information below in my research. I did some additional testing and rewrote part of it. Let me first say that before doing anything we need to make sure that we…
Month: June 2011
How to Move the WSUS Database
I ran into an issue where a customer needed to move the WSUS Database to a different SQL server. In my research I found most of the information below. In testing I added a few pieces to it since my customer was using a remote SQL server. To move your WSUS Database to another…
What Collections is your Client a Member of?
Many times during the course of troubleshooting, you may come across a situation where you need to find out how many Collections a specific Client machine is a member of. Here is how you can find that information, along with the Collection Names and the ID’s. Run the following SQL query in against the SMS…
How to Remove Custom Discovery Architecture
A while back a customer had added some custom discovery architecture to their sites but needed to change a column name due to a conflict in SQL. We searched the web but didn’t find much on how to remove the added information. I did some testing and came up with a solution but didn’t think…