Author: Eswar Koneti

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 referring to the Patch process and found an image which gives the statistics for the listed patches in a good viewable way.so thought of creating such a report and can be linked to other report to get preferable colums which are necessary.May be i can show it to the management team for the patch activity on monthly basis.This basically requries to create…

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 onto it. select SMS_G_System_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name not in (select SMS_G_System_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe acrobat reader") change the application(adobe actobat reader) the one you are looking at.

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 later install 2008 and restore backed up database.I just simply ran the upgrade advisor to see if it has any DTS jobs and other stuff.So started installing SQL 2008(passed pre requisists) and it prompt me to select the instance name.So tried using the default instance name but failed bcz it used by SQL 2005 .I  selected named instance(computername\SQLserver2008).For installing the…

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 - Run - type CMD  3. At the command prompt type net stop wuauserv  4. Navigate to the Windows Directory  5. Delete the 'Software Distribution' Folder  6. Run Microsoft Update from the Start menu (This will ensure the update software is up to date)  7. Restart the PC  8. Select Start - Run - type in the run box http://WSUSServerName/iuident.cab (wsus…

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 the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\WUServer subkey. Make sure the WUServer subkey points to your SUS or WSUS server and not Microsoft Windows Update. 4.     Navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update subkey. Find the AUState entry and note its value. The AUState value can help you determine the problem. Here are the…

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 A, v_GS_PRINTER_DEVICE B WHERE A.ResourceID = B.ResourceID AND B.Name0 != 'Microsoft Office Document Image Writer' AND B.Name0 != 'Adobe PDF' AND B.Name0 != 'Microsoft XPS Document Writer' AND B.Name0 != 'PDF-XChange 3.0' AND B.DriverName0 != 'Microsoft Shared Fax Driver' AND B.DriverName0 != 'pdfFactory 2' AND…

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 clients why it doesnt report.  Use the below simple VB script to get list of applications installed on target computers with its installed date and product ID as well. Collect list of computers that you are looking for and pipe all the computer names into…

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, pinging the MP by hostname and telnetting to port 80 on the MP.  4.      If the ccmexec.log indicates the client can communicate with the MP, check the Management Point to see if the policy exists using SMS Client Centre tool. 5.      If the policy is…