Author: Eswar Koneti

Posted on March 12, 2010 by | 0 Comments | 1,258 Views
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 the Run dialog box, type regedit, then click OK. 3.     In the registry, navigate to…
Read more »

Posted on March 11, 2010 by | 14 Comments | 6,413 Views
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 be useful for some one. SELECT A.Name0, A.UserName0, B.Name0, B.DriverName0, B.Location0, B.PortName0, B.ShareName0 FROM v_GS_COMPUTER_SYSTEM…
Read more »

Posted on March 10, 2010 by | 2 Comments | 633 Views
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 and there could lot of applications installed on computers then you will start troubleshooting the…
Read more »

Posted on March 10, 2010 by | 0 Comments | 110 Views
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 with the MP, follow basic connectivity tests such as pinging the MP by IP address,…
Read more »

Posted on March 10, 2010 by | 1 Comment | 128 Views
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 is called tSQL, or Transact SQL. Transact SQL is a series of statements that a…
Read more »

Posted on February 15, 2010 by | 4 Comments | 8,156 Views
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 this information. select distinct a.name0,c.Caption0 as 'Operating System',c.CSDVersion0 as Version,b.SystemDefaultLCID as Language from v_R_System a,…
Read more »

Posted on February 12, 2010 by | 4 Comments | 2,521 Views
2 weeks back,working on patching issues in SMS 2003 which are having some trouble.there are lot of systems which failed the patches due to windows update agent doesnt exisit on the machines(identified the cause because of this) more information look here .It is bit hard to find the systems by looking at resource explorer and finding if…
Read more »