Finally the help of IT is here

Blog of computer solutions.

How to make a list of needed patches on WSUS team through an SQL query.

Posted by Xaus Xavier Nadal 28th on February 2010


In this article I'll show how to make a view in SQL that encompasses the fields that we want by a select of 2 tables joined with inner join to get a list of the patches that are missing listings computers in a WSUS server.


Megacrack read »

tags: , , , , , , ,
Posted by SQL Server, Windows Update Services | 1 Comment »

Manage the WSUS database (Windows Internal Database)

Posted by Xaus Xavier Nadal 28th on February 2010


Today we continue with some WSUS.

I'm going to teach you how to manage the database we created through the installation of WSUS to make SQL queries, database resize, move to another location, etc ...


First of all we we download and install the 40 MB of Microsoft SQL Server Management Studio Express from the following link:

Megacrack read »

tags: , , ,
Posted by Windows Update Services | 8 Comments »

Script to send mail with AD teams <ServicePack desired

Posted by Xaus Xavier Nadal on February 1st 2010

Today a bit of Active Directory from the command line.

Aimed at people who do not believe in the power of CMDLINE.

I remember years ago that modified AUTOEXEC.BAT and CONFIG.SYS files to ensure maximum possible memory (I remember it made competitions) (Surely many of those who know me and have been in my little world will bring fond memories).

For years after we go down that road. Also great with Microsoft PowerShell, Core version, etc. ..

Following the second installment of WSUS will show you a script that I made to get a numbered list operating system and Active Directory computers that do not have a specific service pack, this list will be sent by mail to an e-mail .


1. - Tools for managing Active Directory. (Windows 7, View x64, XP)

2.- Blat.exe (Program to send mails via SMTP from the command line).

Megacrack read »

tags: , , , , , , , , , ,
Posted by Active Directory, Windows Update Services | No Comments »

How to configure a Replica WSUS server 3.0 SP2

Posted by Xaus Xavier Nadal 30th on January 2010


In large corporations need to minimize the bandwidth used by WSUS placing distributed servers in delegations containing more teams. This can be configured WSUS so that we have a central server and distributed servers to catch updates from central server to 1 1.

And why not create WSUS servers in delegations and who is himself of the delegation WSUS to download updates from internet? The answer is simple. From the central server WSUS will control all updates will be distributed to all teams of the corporation, otherwise we should approve the WSUS patches on each server, each server to clean up WSUS, so will control centralized patching minimizing the bandwidth used by customers.


From there we can through GPO's or even using dns round robin in making customers download their updates from a server or another.

First of all we must install WSUS as shown in the following article:

Install WSUS server in Windows Server 3.0 SP2 2008 R2 x64

Megacrack read »

tags: , , , , , , , , ,
Posted by Windows Update Services | No Comments »

How to create a WMI filter and apply it to a Group Policy (GPO).

Posted by Xaus Xavier Nadal 26th on November 2009


First of all comment that WMI filters are very useful in many cases. For you to have an easy way to make a WMI filter without complicaros much I leave this link to a tool that will directly create the WMI select that you should use in other programs such as the GPO from Active Directory.

The WMI Code Creator program:

I show you how it works a bit different. Extort the program:


You select field Classes the kind you please for example in this case need to know if the available disk space is 2GB Well majority to press on Win32_LogicalDisk

Now Select the properties you want values ​​for select FreeSpace.

click on Search for Property Values to see some possibilities for this WMI filter.

click on FreeSpace.

In the right screen Generated Code: We found that the WMI query that we use is: SELECT * FROM WHERE FreeSpace = 32 Win200867135488_LogicalDisk ", 48)

Now we have a WMI query that we can use at will by modifying a little bit.

Megacrack read »

tags: , , , , , ,
Posted by Active Directory, WMI Filters, Windows Update Services, WMI | 3 Comments »

GTranslate Your license is inactive or expired, please subscribe again!