Thursday, July 19, 2012

All the Microsoft Updates Till Date

Here you can download all the list of updates from this link it will show from 1998 to TillDate... Auto Updated this excel sheet by Microsoft
http://go.microsoft.com/fwlink/?LinkID=245778

For more Security related info visit http://technet.microsoft.com/en-us/security/bulletin/

Enjoy..


Bulk SCCM Client Troubleshooting Approch


Site Name Site 1 Comments
Discovery What are The OU's Targeted? In AD Are they missing any in OU's IN AD ??
From AD In above Ou's Howmany Computers are there? (From AD) may be a difference in SCCM vs AD
in SCCM Now List howmany in SCCM may be a difference in SCCM vs AD
Run the AD stale Computers Command  Use this link http://configmgr2oo7.blogspot.sg/2010/09/for-finding-90-days-old-computers-in-ad.html Computers that are not connected in network or not logged on more than 90 means
 computer not there in network and SCCM treats as Stale and it will not discover
Get the difference of computers(AD-StaleAD-in Totall SCCM) Totall??  
Now get the Totall non SCCM Clients show in your clients report and fix by using below two tools    
Use these script to install the SCCM Client on remote computers    
                   -remotly install on many systems once by using these scripts http://configmgr2oo7.blogspot.sg/2009/01/sccm-client-installation-script-batch.html
http://sccmcat.codeplex.com/
USE SCCM Client action tools ..need to configure the .ini file as per your requirement check the blog
                  - Single computer based tool http://sourceforge.net/projects/smsclictr/ If it is a one computer use this tool
Catagorise the problems lile Ping Online & offline computers with this script to get the status of computes use this scrip may be usefull before you start work
WMI & Admin$ issues http://configmgr2oo7.blogspot.sg/2008/11/wmi-connectivity-check.html WMI & Admin$ is key to deploy clients
Once the clinet installation completed check the log CCMsetup.log,execmgr.log, Clientidmanager.log check the logs
  Check all these case's before start working http://configmgr2oo7.blogspot.sg/2010/03/client-troublshooting-checks-check-list.html  

Tuesday, July 3, 2012

Virtual LAB Microsoft Page

Virtual LABS : System Center 2012 Configuration Manager

System Center 2012 Configuration Manager

    Saturday, May 12, 2012

    To Download the YouTube Play list

    To download the YouTube Play list all videos at a time…

    The link to the page where you can download “Free youtube Download”.http://www.dvdvideosoft.com/products/dvd/Free-YouTube-Download.htm is really superb ..

     

    Enjoy

    Monday, April 23, 2012

    is computer is 32 bit or 64 bit ?


    --Finding computer is 32 bit or 64 bit is easy from SCCM... here is SQL query............

    SELECT Distinct SYS.Netbios_Name0, CS.Model0,CPU.Name0 AS [CPU Name], CASE  WHEN CPU.Is64Bit0 = 1
     THEN 'Yes' ELSE 'No' END AS [CPU 64-Bit],ROUND(CONVERT(FLOAT,CPU.MaxClockSpeed0), -2)/1000
      AS [CPU (GHz)],
    ROUND(ROUND(CONVERT(FLOAT,MEM.TotalPhysicalMemory0) / 1048576, 2) , 1)
    AS [RAM (GB)],[TPM Chip]=(SELECT  v_GS_SYSTEM_DEVICES.Name0
     FROM  v_GS_SYSTEM_DEVICES WHERE  v_GS_SYSTEM_DEVICES.ResourceID=SYS.ResourceID AND
       v_GS_SYSTEM_DEVICES.Name0 LIKE '%Trusted Platform%') ,LDISK.DeviceID0,LDISK.Size0/1024
       AS [Size (GB)],LDISK.FreeSpace0/1024 AS [Free Space (GB)] FROM v_R_System SYS LEFT JOIN
       v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID LEFT JOIN
       v_GS_COMPUTER_SYSTEM CS on SYS.ResourceID = CS.ResourceID LEFT JOIN
        v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID LEFT JOIN
         v_GS_Processor CPU on SYS.ResourceID = CPU.ResourceID LEFT JOIN
          v_GS_SYSTEM_DEVICES DEV on SYS.ResourceID = DEV.ResourceID
           WHERE  LDISK.DeviceID0 = 'C:' AND CS.Model0 NOT LIKE '%VMWARE%'

    ORDER BY SYS.Netbios_Name0

    Saturday, April 21, 2012

    Nomad Branch Agent Fix and re install


    echo sTOP sERVICE
    Net Stop NomadBranch

    Echo uNINSTALL If Nomad Found

    Call MsiExec.exe /NoRestart /X{94ADB1B7-6490-4DCD-800D-5214A8516DC6} /QN
    Call MsiExec.exe /NoRestart /X{1DBE047F-2734-4F18-BC8A-8721E1866BAC} /QN
    Call MsiExec.exe /NoRestart /x{B9AC4CC0-2AAB-42C7-A876-1C552500CD82} /QN

    Echo Install Nomad

    Call Msiexec.exe /i NomadBranch.msi AUTHENTICATEDUSERS=1 INSTALLDIR="%programfiles%\1E\SMSNomad" STATUSMSGEVENTS="0x2,0x200000" NOMADINHIBITEDSUBNETS="" PIDKEY=COMPkey1-1234-1234-1234-1234 MULTICASTSUPPORT=0 CachePath="%systemdrive%\NomadBranch" Logpath="%systemdrive%\NomadBranch\LogFiles" /log "%systemRoot%\temp\1e.log" /QN

    Echo Install Patch"Q11498.msp"

    Call Msiexec /p Q11498.msp /qn REBOOT=ReallySuppress /l*v %systemRoot%\Temp\1EQ11498.Log
    Call "%ProgramFiles%\1E\SMSNomad\NomadBranch.exe" -relicense=COMPkey1-1234-1234-1234-1234

    Echo if service not in auto state set to auto

    SC Config NomadBranch start= auto

    Net Start NomadBranch






    All WQL to info from SQL

    All WQL to info from SQL

    select * from dbo.v_CollectionRuleQuery

    SQL Query for Pathes required systems with the Size


    --SQL Query for Pathes required systems with the Size

    SELECT DISTINCT
                          TOP (100) PERCENT SYS.Name0 AS [Machine Name], UCS.Status AS [Patch Status Code], UI.BulletinID, UI.ArticleID, UI.Title,
                          dbo.v_FullCollectionMembership.ResourceID, dbo.v_Collection.CollectionID, UI.CI_ID, dbo.CI_Contents.SourceSize /(1024.0*1024) AS SizeinMB
    FROM         dbo.v_UpdateContents INNER JOIN
                          dbo.v_FullCollectionMembership INNER JOIN
                          dbo.v_Collection ON dbo.v_FullCollectionMembership.CollectionID = dbo.v_Collection.CollectionID INNER JOIN
                          dbo.v_R_System AS SYS LEFT OUTER JOIN
                          dbo.v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID INNER JOIN
                          dbo.v_UpdateInfo AS UI ON UCS.CI_ID = UI.CI_ID ON dbo.v_FullCollectionMembership.ResourceID = UCS.ResourceID ON
                          dbo.v_UpdateContents.CI_ID = UI.CI_ID INNER JOIN
                          dbo.CI_Contents ON dbo.v_UpdateContents.Content_ID = dbo.CI_Contents.Content_ID
    WHERE     (UCS.Status IN ('2')) AND (dbo.v_Collection.CollectionID = 'LAB000FB')
    ORDER BY UI.ArticleID

    All Systems that have been discovered last night:



    SELECT SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,
     SMS_R_System.SMSUniqueIdentifier,
     SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
    FROM SMS_R_System
    WHERE (DateDiff(day, CreationDate, GetDate()) < 1)


    Collection - ADVERTISEMENT FAILED systems



    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 = 'LAB20089' and LastStateName = "Failed"

    All S/w from Add& Remove Programs After some exceptional removing


    All S/w from Add& remove Programs

    SELECT DISTINCT arp.DisplayName0 AS [Product Name], arp.Publisher0, arp.Version0, dbo.v_R_System.Netbios_Name0, fcm.CollectionID
    FROM         dbo.v_GS_ADD_REMOVE_PROGRAMS AS arp INNER JOIN
                          dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID CROSS JOIN
                          dbo.v_Collection INNER JOIN
                          dbo.v_FullCollectionMembership AS fcm ON dbo.v_Collection.CollectionID = fcm.CollectionID
    WHERE     (NOT (arp.DisplayName0 LIKE '%update%')) AND (NOT (arp.DisplayName0 LIKE 'para%')) AND (NOT (arp.DisplayName0 LIKE 'Configuration Manager Client')) AND
                          (NOT (arp.DisplayName0 LIKE 'µTorrent')) AND (NOT (arp.DisplayName0 LIKE '%Service Pack%')) AND (NOT (arp.DisplayName0 LIKE '%Segurança%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Windows%')) AND (NOT (arp.DisplayName0 LIKE '%Audio Driver%')) AND
                          (NOT (arp.DisplayName0 LIKE '%C++ 2005 Redistributable%')) AND (NOT (arp.DisplayName0 LIKE '%Viewer%')) AND (NOT (arp.DisplayName0 LIKE '%Hotfix%')) AND
                          (NOT (arp.DisplayName0 LIKE '%.NET Framework%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%MSXML%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Microsoft Baseline Security Analyzer%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%'))
                          AND (NOT (arp.DisplayName0 LIKE '%HP Array Configuration%')) AND (NOT (arp.DisplayName0 LIKE '%HP Scanjet%')) AND
                          (NOT (arp.DisplayName0 LIKE '%HP Smart%')) AND (NOT (arp.DisplayName0 LIKE '%hppFaxUtility%')) AND (NOT (arp.DisplayName0 LIKE '%hppFonts%')) AND
                          (NOT (arp.DisplayName0 LIKE '%HPPhotoSmartExpress%')) AND (NOT (arp.DisplayName0 LIKE 'HPP%')) AND (NOT (arp.DisplayName0 LIKE '%HPProductAssistant%'))
                          AND (NOT (arp.DisplayName0 LIKE '%WebFldrs XP%')) AND (NOT (arp.DisplayName0 LIKE '%Visual Studio Tools for the Office system 3.0 Runtime%')) AND
                          (NOT (arp.DisplayName0 LIKE 'VBA%')) AND (NOT (arp.DisplayName0 LIKE '%uTorrentBar%%')) AND (NOT (arp.DisplayName0 LIKE '%Ultimate Extras%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Runtime Environment%')) AND (NOT (arp.DisplayName0 LIKE '%Toolbox%')) AND (NOT (arp.DisplayName0 LIKE '%IBM Themes%'))
                          AND (NOT (arp.DisplayName0 LIKE '%hp LaserJet%')) AND (NOT (arp.DisplayName0 LIKE '%GDR%')) AND (NOT (arp.DisplayName0 LIKE '%Fax%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Adobe Shockwave Playe%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Reader%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Adobe Download Manager%')) AND (NOT (arp.DisplayName0 LIKE '%Actualización%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Active Directory Migration Tool%')) AND (NOT (arp.DisplayName0 LIKE '%Adobe Flash Player%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Audio%')) AND (NOT (arp.DisplayName0 LIKE '%XML%')) AND (NOT (arp.DisplayName0 LIKE '%Web Part%')) AND
                          (NOT (arp.DisplayName0 LIKE '%WIMGAPI%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Silverlight%')) AND (NOT (arp.DisplayName0 LIKE '%SoundMAX%')) AND
                          (NOT (arp.DisplayName0 LIKE '%Spelling%')) AND (NOT (arp.DisplayName0 LIKE '%RDC%')) AND (NOT (arp.DisplayName0 LIKE '%Wallpapers%')) AND
                          (NOT (arp.DisplayName0 LIKE '%WebEx%')) AND (NOT (arp.DisplayName0 LIKE '%Microsoft Office Proof%')) AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%'))
                          AND (NOT (arp.DisplayName0 LIKE '%MSN Toolbar%')) AND (NOT (arp.DisplayName0 LIKE '%google%')) AND (NOT (arp.DisplayName0 LIKE '%SQL Server Native%'))
                          AND (NOT (arp.DisplayName0 LIKE '%VSS Writer%')) AND (NOT (arp.DisplayName0 LIKE '%XP Themes%')) AND (NOT (arp.Publisher0 LIKE '%Lenovo%')) AND
                          (NOT (arp.Publisher0 LIKE '%UPEK Inc%')) AND (NOT (arp.Publisher0 LIKE '%AutoIt%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
                          (NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%Seagate%')) AND
                          (NOT (arp.Publisher0 LIKE '%S3 Graphics%')) AND (NOT (arp.Publisher0 LIKE '%Active Directory Export%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND
                          (NOT (arp.Publisher0 LIKE '%Logitech%')) AND (NOT (arp.Publisher0 LIKE '%SCCM%')) AND (NOT (arp.Publisher0 LIKE '%Yahoo%')) AND
                          (NOT (arp.Publisher0 LIKE '%Canon%')) AND (NOT (arp.Publisher0 LIKE '%ZTE%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND
                          (NOT (arp.Publisher0 LIKE '%McAfee%')) AND (NOT (arp.Publisher0 LIKE '%Dell%')) AND (NOT (arp.Publisher0 LIKE '%1E%')) AND
                          (NOT (arp.Publisher0 LIKE '%Mozilla%')) AND (NOT (arp.Publisher0 LIKE '%TOSHIBA%')) AND (NOT (arp.Publisher0 LIKE '%Broadcom%')) AND
                          (NOT (arp.Publisher0 LIKE '%DivX%')) AND (NOT (arp.Publisher0 LIKE '%InterVideo%')) AND (NOT (arp.Publisher0 LIKE '%UPEK%')) AND
                          (NOT (arp.Publisher0 LIKE '%Intel%')) AND (NOT (arp.Publisher0 LIKE '%Realtek%')) AND (NOT (arp.Publisher0 LIKE '%REALTEK%')) AND
                          (NOT (arp.Publisher0 LIKE '%Conexant%')) AND (fcm.CollectionID = 'SMS00001')

    Nomad Service issue

    If Nomad service is getting stopped automatically as Licensing issue.. then we can re license as below command from the NomadBranch.exe path...

    NomadBranch.exe -relicense=Productkey-Abcad-123456-1231231-12312312

    Monday, April 9, 2012

    ITIL Exams

    ITIL Exams:


    The Information Technology Infrastructure Library™ (ITIL) offers a systematic approach to the delivery of quality IT services. ITIL was developed in the 1980s and 1990s by CCTA (Central Computer and Telecommunications Agency, now the Office of Government Commerce, OGC), under contract to the UK Government.

    Since then, ITIL has provided not only a best practice based framework for IT management, but also an approach and philosophy shared by the people who work with it in practice. ITIL has now been updated twice, the first time in 2000-2002 (V2), and the second time in 2007 (V3). 

    The ITIL Qualification Scheme uses a system that enables an individual to gain credits for each exam they take. Once candidates have accumulated a sufficient number of credits they can be awarded the ITIL Expert in IT Service Management. There are four levels within the scheme:

    §  Foundation Level 

    §  Intermediate Level (Lifecycle Stream and Capability Stream) 

    §  ITIL Expert 

    §  ITIL Master

    Saturday, March 24, 2012

    PXE Client How will find the PXE Server

     

     

    The process is roughly as below:

     

    1. Client powers on
    2. NIC initiates PXE process
    3. NIC acquires DHCP address
    4. NIC contacts PXE server (WDS)
    5. PXE server delivers NBP to client
    6. NIC TFTPs boot image (from WDS)

    4 This can be couple of different ways. If the DHCP request returned options 66 and 67, then the NIC BIOS will directly use the information in these options to contact the PXE server.

    If options 66 & 67 are not specified, then the NIC BIOS will send a broadcast request to find a PXE server.

    If the PXE server is not on a local subnet, then something needs to forward the broadcast request to the PXE server: iphelpers (there are other possibilities but this is the primary solution to this).

    Once the PXE server is contacted, it sends back the info to the client so the client can directly contact the PXE server.

    Wednesday, March 21, 2012

    Tools Website

    This is a good Tools Website.. has lot of tools and very useful..

    http://www.robvanderwoude.com

    Wednesday, March 7, 2012

    Powershell in Visual Studio 2010

    Steps Involved:

    Powershell in Visual Studio 2010

    Steps Involved:

    Monday, March 5, 2012

    PowerShell in Nutshell learn from these steps

    Stage 1

    Stage 2

    Stage 3

      SCCM Virtual Labs

      System Center Configuration Manager 2007

      GPO IE Security Settings

      To set a GPO related to IE settings can be setup from below

      See Computer Configuration --- Administrative Tools --- Windows Components

      --- Internet Explorer --- Internet Control Panel --- Security Page and then

      double click to the "Site to zone assignment list".


      Enable it, click Show, add website as value name and 1, 2, 3 or 4 as value.

      1. Intranet zone
      2. Trusted Sites zone
      3. Internet zone
      4. Restricted Sites zone

      Just a visual memory for easy remember

      image

      Thursday, March 1, 2012

      Enable RDP in the Task Sequence

      Const HKEY_LOCAL_MACHINE = &H80000002
      strComputer = "."

      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

      Tuesday, February 21, 2012

      How to disable the UAC in Windows 7 Deployment

      In fact we might get more errors if you have the UAC enabled while deploying the Windows 7, You can include one step in the task sequence as run a command line and fill this below in the command line box

      “CMD /C REG.EXE ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v EnableLUA /t REG_DWORD /d 0 /f”

       

      image

      Note: Not required any options in the options to configure however you can record with a optional Success Code “0 3010”

      How to set the Timezone

      How to set the Timezone with in one task sequence… like you have more than one location and all these locations has different time zones…

       

      To do this under the task sequence Apply Windows Settings in the options TS Variable is ADSite name equals is “WhateverTheSite” and in the Properties Time Zone choose the time you wanted…

       

      image

      image

      How to set the Timezone

      How to set the Timezone with in one task sequence… like you have more than one location and all these locations has different time zones…

       

      To do this under the task sequence Apply Windows Settings in the options TS Variable is ADSite name equals is “WhateverTheSite” and in the Properties Time Zone choose the time you wanted…

       

      image

      SNAGHTMLfacb20

      On AD & exchange simply good website

      http://www.netometer.com/

      Monday, February 20, 2012

      OSD import permission Issue

      We might get when we are looking for only import permissions for a user or Group..

      or

      even when we setup the permissions at the end of the wizard we may get this error..

      Errors

      ·You do not have security rights to perform this operation.

      ·ConfigMgr Error Object:

      ·instance of SMS_ExtendedStatus

      ·{

      · Description = “User \”*************\” does not have permission of the current site to import machines.”;

      · ErrorCode = 1112017920;

      · File = “e:\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspsite.cpp”;

      · Line = 766;

      · ObjectInfo = “524288″;

      · Operation = “ExecMethod”;

      · ParameterInfo = “SMS_Site”;

      · ProviderName = “WinMgmt”;

      · StatusCode = 2147749889;

      };

       

      The actual permissions required at SCCM Console level is:

      1. On SCCM Root Collections we must grant read & read Resource
      2. and for the target of the collection we need to give the permissions to add or whatever you wanted
      3. at computer Association level we must give permissions for importing
      4. (The most common mistake or un- mentioned step ..this one we may forget most of the time)

      On the top of the Site ==Properties=> Security Tab => Class Security rights and we must choose here read,Import Computer Entry (below screenshot)

      image

      image

      OSD import permission Issue

      We might get when we are looking for only import permissions for a user or Group..

      or

      even when we setup the permissions at the end of the wizard we may get this error..

      Errors

      ·You do not have security rights to perform this operation.

      ·ConfigMgr Error Object:

      ·instance of SMS_ExtendedStatus

      ·{

      · Description = “User \”*************\” does not have permission of the current site to import machines.”;

      · ErrorCode = 1112017920;

      · File = “e:\\nts_sms_fre\\sms\\siteserver\\sdk_provider\\smsprov\\sspsite.cpp”;

      · Line = 766;

      · ObjectInfo = “524288″;

      · Operation = “ExecMethod”;

      · ParameterInfo = “SMS_Site”;

      · ProviderName = “WinMgmt”;

      · StatusCode = 2147749889;

      };

       

      The actual permissions required at SCCM Console level is:

      1. On SCCM Root Collections we must grant read & read Resource
      2. and for the target of the collection we need to give the permissions to add or whatever you wanted
      3. at computer Association level we must give permissions for importing
      4. (The most common mistake or un- mentioned step ..this one we may forget most of the time)

      On the top of the Site ==Properties=> Security Tab => Class Security rights and we must choose here read,Import Computer Entry (below screenshot)

      image

      image

      How to grant the SCCM Console permissions to Support Executive

      Scenario SCCM installed on cm07.test.com & I have a test system with windows XP/7.
      I have a User called RBAC and RBAC wanted some permissions on SCCM console.

      Steps:-

      Install the SCCM console on windows Xp/7

      add the RBAC user to SMS Admins Group.

      Follow these steps for granting the DCOM rights.

      1. From SCCM Server the Start menu, click Run and type Dcomcnfg.exe.

      2. In Component Services, click Console root, expand Component Services, expand Computers, and then click My Computer. On the Action menu, click Properties.

      3. In the My Computer Properties dialog box, on the COM Security tab, in the Launch and Activation Permissions section, click Edit Limits.

      4. In the Launch Permissions dialog box, click Add.

      5. In the Select User, Computers, or Groups dialog box, in the Enter the object names to select (examples): box, typeSMS Admins and click OK.

      6. In the Permissions for SMS Admins section, select the check box to allow Remote Activation.

      7. Click OK twice, and then close Computer Management.

      Friday, February 17, 2012

      C drive disk space information on my all machine

      SELECT TOP (100) PERCENT dbo.v_R_System.Name0 AS [System Name], dbo.v_GS_LOGICAL_DISK.Name0 AS [C Drive], dbo.v_GS_LOGICAL_DISK.Size0 AS [Total Size],
      dbo.v_GS_LOGICAL_DISK.FreeSpace0 AS FreeSpace, dbo.v_GS_LOGICAL_DISK.Size0 AS Used
      FROM dbo.v_R_System INNER JOIN
      dbo.v_GS_LOGICAL_DISK ON dbo.v_R_System.ResourceID = dbo.v_GS_LOGICAL_DISK.ResourceID INNER JOIN
      dbo.v_FullCollectionMembership ON dbo.v_FullCollectionMembership.ResourceID = dbo.v_R_System.ResourceID
      WHERE (dbo.v_GS_LOGICAL_DISK.DriveType0 = 3) AND (dbo.v_FullCollectionMembership.CollectionID = 'sms00001') AND (dbo.v_GS_LOGICAL_DISK.Name0 = 'c:')
      ORDER BY FreeSpace

      Wednesday, February 8, 2012

      For a specific Advertisement status for last 3 Days…

      ---for a specific Advertisement status for last 3 Days… if we include the Set   @AdvName = '%' line then and remove the above line in red color will show for all advertisements with last 3 days status

      -- To include all we need to give % in SQL this is a tip

      Declare     @AdvName Varchar(256)
      Set   @AdvName = 'Lync_2010_Full_Install'

      ---Set   @AdvName = '%'  
      Select      adv.AdvertisementName
      ,    adv.AdvertisementID
      ,    s.Host
      ,    LastAcceptanceMessageIDName
      ,    LastAcceptanceStateName
      ,    LastAcceptanceStatusTime
      ,    LastStatusMessageIDName
      ,    LastStateName
      ,    LastStatusTime
      ,    LastExecutionResult
      From  (
            Select      AdvertisementName
            ,    AdvertisementID
            From  dbo.v_AdvertisementInfo
            Where AdvertisementName Like @AdvName
            ) As  adv
      Join  (
            Select      AdvertisementID
            ,    ResourceID
            ,    LastAcceptanceMessageIDName
            ,    LastAcceptanceStateName
            ,    LastAcceptanceStatusTime
            ,    LastStatusMessageIDName
            ,    LastStateName
            ,    LastStatusTime
            ,    LastExecutionResult
            From  dbo.v_ClientAdvertisementStatus
            Where LastStatusTime >= DateAdd(d,-3,GetDate())
            ) As  cas
      On    adv.AdvertisementID = cas.AdvertisementID
      Join  (
            Select      ResourceID
            ,    Netbios_Name0 As Host
            From  dbo.v_R_System
            Where Client0 = 1
            And  Active0 = 1
            And  Obsolete0 = 0   
            ) As  s
      On    cas.ResourceID = s.ResourceID
      Order By
            AdvertisementName
      ,    Host

      HeartBeat Discovery Status of specific collection of systems

      select
          CS.Name0,
          max(AD.AgentTime) as 'Date/Time'
      from
          dbo.v_AgentDiscoveries ad
          JOIN dbo.v_GS_COMPUTER_SYSTEM cs on AD.ResourceID = CS.ResourceId
          join dbo.v_FullCollectionMembership FCM on FCM.ResourceID = CS.ResourceId
      Where
          AgentName = 'Heartbeat Discovery'
          and FCM.CollectionID = 'SMS00001'
      Group by
          CS.Name0

      Tuesday, February 7, 2012

      To get ride of IIS Webdav issue

      Most of the time some or other application extension would be blocked because of IIS Webdav Settings issue, to stop filtering in IIS Webdav we can change the

      setting at the site level, i.e., open inetmgr/ IIS Console and chose the server name and in the right side we need to choose the “WebDav Authoring Rules” and in actions you will see “WebDAV  settings” click on the  button and you need to configure you Request filtering Behavior as below.

       

      image

       

      Okey, we may read in the blogs as we need to change in the applicationHost.config file.. if we do above settings it must be appear in the file… okey if you want to see the file how it looks like ……..

      <requestFiltering>

                      <fileExtensions allowUnlisted="true" applyToWebDAV="false">

                          <add fileExtension=".asa" allowed="true" />

                          <add fileExtension=".asax" allowed="true" />

                          <add fileExtension=".ascx" allowed="true" />

                          <add fileExtension=".master" allowed="true" />

                          <add fileExtension=".skin" allowed="true" />

                          <add fileExtension=".browser" allowed="true" />

                          <add fileExtension=".sitemap" allowed="true" />

                          <add fileExtension=".config" allowed="true" />

                          <add fileExtension=".cs" allowed="true" />

                          <add fileExtension=".csproj" allowed="true" />

                          <add fileExtension=".vb" allowed="true" />

                          <add fileExtension=".vbproj" allowed="true" />

                          <add fileExtension=".webinfo" allowed="true" />

                          <add fileExtension=".licx" allowed="true" />

                          <add fileExtension=".resx" allowed="true" />

                          <add fileExtension=".resources" allowed="true" />

                          <add fileExtension=".mdb" allowed="true" />

                          <add fileExtension=".vjsproj" allowed="true" />

                          <add fileExtension=".java" allowed="true" />

                          <add fileExtension=".jsl" allowed="true" />

                          <add fileExtension=".ldb" allowed="true" />

                          <add fileExtension=".dsdgm" allowed="true" />

                          <add fileExtension=".ssdgm" allowed="true" />

                          <add fileExtension=".lsad" allowed="true" />

                          <add fileExtension=".ssmap" allowed="true" />

                          <add fileExtension=".cd" allowed="true" />

                          <add fileExtension=".dsprototype" allowed="true" />

                          <add fileExtension=".lsaprototype" allowed="true" />

                          <add fileExtension=".sdm" allowed="true" />

                          <add fileExtension=".sdmDocument" allowed="true" />

                          <add fileExtension=".mdf" allowed="true" />

                          <add fileExtension=".ldf" allowed="true" />

                          <add fileExtension=".ad" allowed="true" />

                          <add fileExtension=".dd" allowed="true" />

                          <add fileExtension=".ldd" allowed="true" />

                          <add fileExtension=".sd" allowed="true" />

                          <add fileExtension=".adprototype" allowed="true" />

                          <add fileExtension=".lddprototype" allowed="true" />

                          <add fileExtension=".exclude" allowed="true" />

                          <add fileExtension=".refresh" allowed="true" />

                          <add fileExtension=".compiled" allowed="true" />

                          <add fileExtension=".msgx" allowed="true" />

                          <add fileExtension=".vsdisco" allowed="true" />

                          <add fileExtension=".exe" allowed="true" />

                          <add fileExtension=".vbs" allowed="true" />

                      </fileExtensions>

                      <verbs allowUnlisted="true" applyToWebDAV="false" />

                      <hiddenSegments applyToWebDAV="false">

                          <add segment="web.config" />

                          <add segment="bin" />

                          <add segment="App_code" />

                          <add segment="App_GlobalResources" />

                          <add segment="App_LocalResources" />

                          <add segment="App_WebReferences" />

                          <add segment="App_Data" />

                          <add segment="App_Browsers" />

                      </hiddenSegments>

                  </requestFiltering>

      Monday, February 6, 2012

      PXE error: PXE-T01:File not Found & PXE-E3B: TFTP Error – File Not Found

       

      You might get the below error..

       

      image

       

      The above problem will come When you don’t Have the files in DriveLetter:\RemoteInstall\SMSBoot\  

      In fact the below article address the issue, However I have approached in different way as just copy the Missing files & folders from other Remote Install Folder and past on the Problem system.

       

      http://www.kozeniauskas.com/itblog/2008/02/26/sccm-pxe-t01-file-not-found-and-pxee3b-tftp-error-file-not-found-errors/

      Friday, January 27, 2012

      AD computer Numbers vs SCCM Computer Numbers

      read here more http://smsug.ca/blogs/garth_jones/archive/2008/12/03/how-to-add-ad-data-to-configmgr-reporting.aspx

      AD it just another database, just like SQL server is. With that in mind there is nothing stopping you from using SQL to link to AD to give you data about your AD environment!

      1) Create Linked Server using SSMS

      exec master.dbo.sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', '<DC Name FQDN>'

      2) Modify the security for ADSI using SSMS

      exec master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'ADSI', @locallogin = NULL , @useself = N'False', @rmtuser = N'<Domian>\<User Id>', @rmtpassword = N'<Password>'

      3) The hard part is over!

      4) Create query to query AD and ConfigMgr

      This query will list all PCs within AD that are NOT within ConfigMgr (or SMS)

      select

      AD.cn as 'PC Name(AD)',

      AD.operatingSystem as 'OS (AD)',

      AD.operatingSystemServicePack as 'SP (AD)'

      from

      openquery (ADSI,

      'SELECT cn,

      operatingSystem,

      operatingSystemServicePack

      FROM ''LDAP://<DC Name FQDN>''

      WHERE objectCategory = ''Computer''') as AD

      Where

      AD.cn not in (Select name0 from v_GS_Computer_System as CS)

      order by

      AD.cn,

      AD.operatingSystem,

      AD.operatingSystemServicePack

      This query will give you a count of all OS that are NOT within ConfigMgr (or SMS)

      select

      AD.operatingSystem as 'OS (AD)',

      count(AD.operatingSystem)

      from

      openquery (ADSI,

      'SELECT cn,

      operatingSystem,

      operatingSystemServicePack

      FROM ''LDAP://gartek-dc.gartek.tst''

      WHERE objectCategory = ''Computer''') as AD

      Where

      AD.cn not in (Select name0 from v_GS_Computer_System as CS)

      Group by

      AD.operatingSystem

      order by

      AD.operatingSystem

      So what does this report look like.

      image

      So there you have it.

      Wednesday, January 25, 2012

      ClientIDManagerStartup.log Error: 0x80040225 & Error 3

      Failed to send registration request message. Error: 0x80040225

      also when you see in the error 3 in ClientIDManagerStartup log

      RegTask: Server rejected registration request: 3    ClientIDManagerStartup    26/01/2012 1:07:43 AM    7904 (0x1EE0)

       

      You might also see (not in all cases) in ccmexec.log

      System task 'ClientRegistrationStartup' returned error code 0x80040222.    CcmExec    26/01/2012 1:10:03 AM    7904 (0x1EE0)

      Solution: Remove the Client authentication and SMS certificates Certificates of from Certificates console and request new certificates

      PXE-T00: Unspecified file opening error detected

      Found the error: While deploying 7 with the SCCM 2007 and MDT 2010.

      sccm PXE-T00: Unspecified file opening error detected
      PXE-E36:Error Received from TFTP server

       

      image

      Solution:This is not related to SCCM / WDS Issue.. it was with Symantec Ghost caused the issue, once the service was stopped the issue is resolved.

      Saturday, January 21, 2012

      How would I extend my Windows 2008 R2 Evolution ?

    • Click Start, and then click Command Prompt.
    • Type slmgr.vbs -dli, and then press ENTER to check the current status of your evaluation period.
    • To reset the evaluation period, type slmgr.vbs  /rearm, and then press ENTER.
    • Restart the computer.
    • It will again extend your evolution to 180 Days

      Friday, January 20, 2012

      How to change the SCCM Client Log files size to Max value that you want

      Sometimes or other we might need to retain the max size of log files for reading/analyzing.

      Here are some useful info………… in this regards………….

      Client side reference registry

      For X86 systems

      -          HKLM\Software\Microsoft\CCM\Logging\@GLOBAL

      For X64 systems

      -          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\CCM\Logging\@GLOBAL

       

      The reference key is Log Maxsize

      I tried to change manually by regedit how it is showing error as can’t be edited the value..

      So I depended on below WMI script

      ' VBScript to change the Log File Size on a ConfigMgr client

      ' Change the 500000 to your required size in bytes

       

      Dim newLogMaxSize

      Dim sMachine

      newLogMaxSize = 500000

      sMachine = "."

      set oCCMNamespace = GetObject("winmgmts://" & sMachine & "/root/ccm")

      Set oInstance = oCCMNamespace.Get("SMS_Client")

      set oParams = oInstance.Methods_("SetGlobalLoggingConfiguration").inParameters.SpawnInstance_()

      oParams.LogMaxSize = newLogMaxSize

      oCCMNamespace.ExecMethod "SMS_Client", "SetGlobalLoggingConfiguration", oParams

      ' End of script

       

      So Do not change the registry value directly!

       

      The SDK shows the SetGlobalLoggingConfiguration Method in Class SMS_Client

       

      http://msdn.microsoft.com/en-us/library/cc146025.aspx

      Monday, January 16, 2012

      How to learn / Education

      Education has five aspects

      1. Information -- Often we think information is education, but it is only one aspect of education.

      2. Concepts -- Concepts are the basis for all research. You need to conceive in order to create.

      3. Attitude -- An integral aspect of education is cultivating the right attitude. Proper attitude at the right time and place determines your actions and behavior.

      4. Imagination -- Imagination is essential for creativity, for the arts. But if you get stuck in imagination, you may become psychotic.

      5. Freedom -- Freedom is your very nature. Only with freedom, do joy, generosity and other human values blossom. Without freedom, attitudes become stifling, concepts become a burden, information is of no value and imagination becomes stagnant.
       
      Just understand these five aspects of education.

      Friday, January 13, 2012

      The program for advertisement "CEN20199" has not been run yet ("CEN0018E" - "*"). Software Distribution is currently paused on this computer, and it has to be resumed before this program can begin.

      You may get above (The program for advertisement "XXXXXXX" has not been run yet ("XXXXXXXX" - "*"). Software Distribution is currently paused on this computer, and it has to be resumed before this program can begin. ) error and your advertisement will never run…  because system required a reboot to continue further any installation……

       

      image

       

      Solution: Reboot the system

      image

      Packaging tools - From Forum Responses

      Some of Free Packaging tools - From Forum Responses

      1. Install shield Adminstudio
      2. wise package studio
      3. Repackaging tool http://www.appdeploy.com/tools/repackager/download.asp
      4. EMCO Package Builder!http://emcosoftware.com/msi-package-builder
      5. Invest some time and training budget in www.windowsinstallertraining.com