Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude…

Are you looking to identify the machines which are having lessthan 512 MB running with Office 2007 or OFfice 2003 with the operating System Installed.If so you can use the below simple SQL query into your reports. Create a New Report…

There might be some scenarios where in you would like to fetch computers with IE Versions, how many of them have IE8, IE9 ,how many of them do not have IE8 etc. Through this post,i wanted to give some useful…

This VB script might help you in initiating the communication between WindowsUpdateAgent(Client) and WindowsUpdateServer(Server) for windows updates. ' ---------------START CODE--------------- strComputer = inputbox("Enter a computer name to run WUA detectnow","Invoke detectnow") if strComputer = "" then wscript.quit on error goto 0 Set autoUpdateClient =…

Long back created a report for the monthly Patch statistics which can be found in http://www.windows-noob.com/forums/index.php?/topic/1764-patch-management-report-in-sms-2003/#entry6281 Below all the reports have been created using the last state messages.Even you can create different type of quiries based on this. I was…

There might be the scenario where you will be looking for computers which doesnt have particular application installed on.Create a new collection and copy the below  simple WQL query which list you all computers there by you can advertise the application package…

Though this process looks easy but havent had a chance to use this.Recently ,i have upgraded my SQL server 2005 to SQL server 2008.There are different ways that you can do this like taking backup of SQL server 2005 ,uninstall 2005…

Issue:    Client PC's would not communicate to WSUS 3.0 SP1  Solution:  1. Delete the PC from the WSUS console (Client PC's - The PC will likely have a red X)  2. At the client PC - Select Start -…

If clients are having trouble downloading and installing updates from your SUS or WSUS server, should check a familiar place—the registry. Go to the problematic client PC and follow these steps: 1.     Select Run on the Start menu. 2.     In…

You might get a request to find out all the computers in organisation connected to which printers.There might be differetn printers in organisation and connection to the computers will vary.I just thought to post this qeury on the which will…