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…

There are many tools like SMS /SCCM or scripting to get list of applications installed on computers(you dont use SMS/SCCM only for this kind of information 🙂 ) but what if the clients are not reported back to site server for some other reason…

Is the client getting the advertisement policy? 1.      Check the ccmexec.log for the advertisementID. 2.      If the advertisementID is not in the ccmexec.log, check the ccmexec.log for errors communicating with the Management Point. 3.      If the ccmexec.log shows errors communicating…

Both MySQL and SQL Server do a good job of supporting all major protocols for accessing their respective databases. A standard protocol is the “programming language” used for a program to communicate to a SQL database. The most common protocol…

It is difficult to troubleshoot the machines where the Task sequence(Os deployment) failed remotely.If there are one or two computers which are in front of you,you can check press F8 and see what happens by looking at smsts.log but take…

You might have different operating Systems installed on the computers.One fine day your boss might request you to get list of computer with Operating system and language installed on the computers.Here is the Report to list all the computers with…