Author: Eswar Koneti

I spent around 45 min to 1 Hour to find the root cause why it is happening though i have updated all the packages and use the correct TS. When you advertise a TS to refresh the Existing Operating system ,some times u might see error like "the requested software cannot be located ,the system might be in the process of transferring thse files try again later ' Resolution:  Try looking into the CAS.log file and see what it says . In my scenario ,it gives me an error "Location update from LS for content C0100001.01 and location request …No…

Read More

Below listed the basic reports to display computers with particular add and remove application installed on computers. Report to list all the computers which have particular software/application installed ? SELECT c.Name0, a.DisplayName0 FROM v_GS_ADD_REMOVE_PROGRAMS a, v_R_System c WHERE a.ResourceID = c.ResourceID AND a.DisplayName0 like '%Adobe acrobat%' GROUP BY c.Name0, a.DisplayName0 ORDER BY c.name0 You can also add the prompt value to ask for application name as well. Report to List all add and remove programs on Particular computer excludes software updates ? SELECT A.DisplayName0,A.InstallDate0, A.Version0,A.Publisher0 FROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM B WHERE A.ResourceID = B.ResourceID AND A.DisplayName0 NOT LIKE ‘Hotfix for…

Read More

Here is a script that is used to activate/enable remtote desktop(RDP) on a local /remote computers. '*** Activates Remote Desktop on remote machine*** Const HKEY_LOCAL_MACHINE = &H80000002 'strComputer = "." strComputer = Inputbox ("Enter Computername:","Activate Remote Desktop","Computername") Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & _ strComputer & "\root\default:StdRegProv") strKeyPath = "SYSTEM\CurrentControlSet\Control\Terminal Server" strValueName = "fDenyTSConnections" dwValue = 0 oReg.SetDWORDValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,dwValue msgbox "Remote Desktop is active!" If you want to activate on a list of machines ,u can use FOR loop until it fisnihes to activate on all machines 🙂

Read More

SCCM 2007 OSD is a fantastic way to deploy operating systems; however, like most things SCCM, issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispersed nature of the blog posts that deal with some of these issues. This article will help SCCM OSD newbie’s with some of these issues.   Integrating SCCM and MDT 2008 For our deployments, we always install MDT 2008 on our SCCM server and select Configure ConfigMgr Integration from the MDT area on the start menu. This gives us:   Templated task sequences we can import into SCCM Additional TS Variables for…

Read More

There are some warnings under component system for MP_control_manager bcz of client machine are not approved and MP is rejecting the policys that are requesting from the client (MP has rejected a policy request from GUID:d0400dcb-68a9-4b64-92af-daa70db2a53a because it was not approved. The operating system reported error 2147942405: Access is denied.) It might be difficult in finding a system in a large number of systems based on GUID. Create a new report and paste the following qeury into the report: Select     Sys.Name0,     Sys.SMSID0,     Sys.Domain0,     Sys.SystemRole0 from     dbo.v_GS_SYSTEM Sys Where     Sys.SMSID0 = @GUID Prompt: select SMS_Unique_Identifier0…

Read More

since few weeks i was working on  troubleshooting the inventory data loader issues on the client computers .Sometimes I get red Alert on the configuration manager Site status node for sms_inventory_data_Loader component. If you look at the monitoring node--site status--component status.Right click and select show messages all ,look at the red alerts with description "SMS Inventory Data Loader failed to process the delta MIF file “Xr1i0uv7v.MIF” because the file does not have a corresponding discovery record. SMS Inventory Data Loader has moved this file to the Orphans directory as file "D:\SMS\inboxes\auth\dataldr.box\Deltamismatch\86rt11zz.MIF” and will retry processing it within 10 minutes.“ Take a…

Read More

Today ,i updated my SCCM SP1 site server to SP2 .I have listed the actions that might be helpful in doing so .It is strongly recommened that ,test it in testing environment before taking it to the production. It is strongly recommended  to follow the check list from microsoft http://technet.microsoft.com/en-us/library/ee344152.aspx ************************************************************************************************* Take backup of your Config mgr Install SCCM SP2 setup file and check the prerequisite components .if no major errors, then proceed to install SP2. Check the Configmgr setup log file to see the status of success. Once you finished installing SCCM SP2, the new WAIK version would be automatically installed on the site server.  It needs…

Read More

this post is just to make the application deployment easier.when you deploy any application to a collection,you might see faliure,no status and waiting.I had similar issues(number count was more).This collection gives you list of systems with faliure/no status/waiting status for particular advertisement.if you need more ,just customise it. Collection: select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID  WHERE AdvertisementID = 'KBS20326' and (LastStateName = "Failed" or LastStateName='Waiting' or LastStateName='No status') and sys.Name like "US_%" Where KBS20326 is advertisement ID ,just replace it with your ID.once you are ready with this collection,you can simply advertise it and…

Read More