Creation by Ankur the ' IT Guy '

I have been always struggling to get desired data from SCCM and it's a really hard job. At least for me J Following query resolved my all problem of searching information SELECT * FROM INFORMATION_SCHEMA.Columns  This gives you all SCCM sql tables information with their columns detail. Now you know what is where …. Cheers……

Hi Folks Below link is really helpful for dealing with 1603 error code so thought to share…. https://support.microsoft.com/en-us/kb/834484 Following also could be the possible causes 1 .        Presence of higher version of same application. 2.        Specific installation sequence is required for Application and Prerequisites. 3.        Windows installer service is corrupted. In this case unregister windows installer service and register back. 4.        Higher Windows installer version is required, at least should be 3.0 or Higher. 5.        Insufficient access permissions . Cheers.....

The SCCM clients receive their SUP/WSUS settings as a local policy on the clients, Scan gets initiated as per configured schedule and happens on base of update GUID. Location services looks for our nearest SUP. This also can be checked in windowsupdate.log When scan is completed. ScanAgent reports that the scan is complete and records the results of the scan in the updatestore. Information can be checked in updatestore.log Client sends result of scan cycle through status massages with topic ID 501 and 500 to MP and site server for each the update that are missing on machine. This can be checked in statemassage.log Once all this process completes updates evaluation gets start by receiving policy for applicable updates. Scan gets initiated for to have latest scan data update applicability and report status, This information can be checked in updatedeployment.log Client Retrieve needed update components through CIAssignment and then SDM agent checks what binaries ar...

Hi Guys, In this post  we will focus on about boot images & OSD Process In SCCM. So quick questions are  What are boot images in SCCM? Boot Images are the image used to boot the machine. The two types of largely used Boot images WinPE Boot Images:   These are used to boot the machine in to Windows Pre Execution Environment or we can say that Windows Installation Mode. OS Boot Images:   These are the boot images used to boot the machine to load the Operating System. Boot Images can contain Drivers like storage drivers, network drivers or any drivers you want to have in boot images, you can simply add or inject those drivers. You can customize the settings of Boot Images or can create your own new Boot Images by integrating MDT with SCCM. Now   How SCCM OSD actually works OSD is a very cool feature of SCCM. Once you do the configuration for OSD, you are ready to do Operating System Deployments. Apart from Boot Imag...

Hi guys, I have seen that while  working on OSD. lots of guys get error  0x80004005 or 80072ee7. I have also suffered in this issue This Error Stats about -- 1. Failure to get the policies 2. Failed to get information for MP: http://sccm I had configured everything properly & just satrted my machine to boot in to PXE. Machine booted properly, Got IP from DHCP Contacted to SCCM Server Booted in to Win PE Published the available Task Sequences But when i selected a task sequence & hit the Run. i got the Error. Failed to run task sequence Error0x80004005 or 80072ee7 Reason:Because OSD PXE boot is totally dependent on DHCP and machine receives the DNS server that is specified in the DHCP Scope. Solution:-  Go to the  DHCP  -> DHCP Scope Options -> Right-click -> Configure Options Just Check & Configure  DHCP Scope Options 003 Router IP or Gateway IP 006 DNS Servers (IP Address) 015 DNS Domain Name ...

Hi guys, This time we will talk about   SCCM   Operating system deployment (OSD).  So first thing  What is SCCM OSD ? Operating system deployment Provides a tool to create operating system images. You can then use these images to deploy them to computers that are managed by Configuration Manager and to unmanaged computers, by using PXE boot or bootable media such as a CD set, DVD, or USB flash drives. Components of  Operating system deployment (OSD) Boot Images Computer Association OS images OS Install Packages Task Sequence  Drivers  Drivers Packages on my fingers  If i start to count tasks which i can do, Boot images creation ( Using MDT Integration ) + Recreation Using WAIK Computer Association B/w One or More OS deployment from OS Packages (Only build Scenario) OS deployment from OS Packages & Capture Images( Build + Capture ) OS deployment from OS Images (Captu...

Hi Guys, I have seen most of the time when SMS Executive stop and when I see in logs folder, crash folder, and I found SMS Executive service again crashed. This is happening due to Unhandled exception. What is an unhandled exception? In almost every Configuration Manger crash there is an exception involved. An exception occurs when an instruction is attempted but fails for some reason (e.g. an Access Violation), so when an exception occurs we need information about that exception or what was in memory when the exception occurred. Most applications have their own exception handling code and Configuration Manager is no different. Configuration Manager has its own exception handler that is designed to collect certain predefined data such as thread stack information and other data when the exception has occurred. Note that it is also sometimes necessary to do live debugging or post mortem debugging when an application/OS crashes using the Windows debugging tools. Componen...

Hi Guys , There are lots of queries about the verification of successful SCCM SITE Installation.Here are some steps that you can follow to verify... For more information, Take a look http://technet.microsoft.com/en-us/library/bb693526.aspx After you install Configuration Manager 2007, apply a service pack (or upgrade a site), or perform a site reset,  you can check the Configuration Manager 2007 setup log file (ConfigMgrSetup.log) located at the root of the system drive for the string Configuration Manager Setup completed successfully.  This entry indicates that Configuration Manager 2007 Setup successfully completed the required installation tasks.  However, this does not necessarily mean that other Configuration Manager 2007 processes have completed their own tasks associated with setup or site reset. To review installation tasks performed by site component manager, after initial Setup tasks have completed,  you can review theComponentSetup...

Discovery Methods & DDR available in SCCM 2007 & 2012? Discovery Data Records When Discovery runs, it creates discovery data records (DDRs). The information contained in a DDR varies depending upon the discovered resource. For example, it can include the NetBIOS name of a computer, the IP address and IP subnet of a computer or device, and the computer operating system name. The approximate size of an individual DDR is 1 KB. Discovery Methods Active Directory System Discovery   – Discovers computers from the specified locations in Active Directory Domain Services. Active Directory User Discovery   - Discovers user accounts from the specified locations in Active Directory Domain Services. Active Directory Security Group Discovery   - Discovers security groups, including local, global, and universal groups from the specified locations in Active Directory Domain Services. Active Directory System Group Discovery   – Discovers addit...

Hi guys, Today i going to talk about SCCM Wake ON LAN Feature. Few concerns are What, Why & How ?   Wake ON LAN What : - This is the feature of SCCM by which SCCM sends wake up transmission packets to clients for a particular Deployment or a Task Sequence to run Why: -  Configure scheduled Configuration Manager  activities to take place outside business hours using the Wake On LAN feature, which has the following benefits: Helps to achieve a higher success rate for Configuration Manager activities. Reduces the associated network traffic during business hours. Helps to conserve power by not requiring computers to be left on outside business hours. Enabling Wake On LAN in Configuration Manager 2007 allows the primary site server to send wake-up packets for the following Configuration Manager activities: Software update deployments Software distribution advertisements Task sequence advertisement Configuration Manager Dependencies De...

Hi guys , Cool  Q's & A's for SCCM Interviews. SCCM Questions & Answers Q. What Is SCCM? System Center Configuration Manager   (CM12   or   CM07   or   ConfigMgr   or   Configuration Manager), formerly   Systems Management Server   (SMS), is a   systems management   software product by   Microsoft   for managing large groups of   Windows -based computer systems. Configuration Manager provides remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory . Q. what are the versions of SCCM?                                                                                           ...