About Author

Hi and Welcome to my blog eskonr.com

My self Eswar Koneti ,completed Bachelor of Technology from JNTU University, India.

Eswar

I started my career as Infrastructure Engineer with Global Company. while i was with my first company ,got a chance to explore different Microsoft Technologies like Active Directory, SMS 2003 ,MOM 2005 and Symantec Antivirus (Non-Microsoft). After working for year+ on these technologies ,I was more interested in SMS 2003 (on the deployment,patching ,OSD and lot more on troubleshooting clients) than other technologies that drive me to choose opportunities in SMS 2003 /SCCM and glad that i am still working SCCM/intune product and i love it.

I have started blogging in year 2009 at www.eskonr.com to share Technical stuff on SCCM/Configmgr and its connected objects like Active Directory ,MBAM etc and to keep this blog as Library for my own reference for future needs.

I spend my free time working with SCCM/Configmgr to explore different things and share it on my on my blog.

In addition to blogging, I like to spend time on Technical forums like TechNet, Myitforum,windows-noob and other SCCM/Configmgr forums responding to queries and gather information on different arenas of deployment technologies.

I was awarded by Microsoft with Title ‘Microsoft Community Contributor’ for my technical contributions towards technical Forums and other Configmgr forums on System Center configuration Manager in year 2011, 2012 and 2013.

you can get in touch with me via social networking sites by simply clicking on the following images.

Inline images 1    Inline images 2   Inline images 3  Inline images 4

 

Community Activities:

I will try (never ending process) to share/absorb as much IT knowledge within my spare time.

Forums, pages and communities where I am active at:

Certificates and Awards:

Microsoft Certifications:
Credential Certification Name /Version
MCTS (Microsoft Certified Technology Specialist ) Microsoft® System center Configuration manager 2007 (70-401)

Microsoft® System Center 2012 Configuration manager (70-243)

Microsoft® System center Operations Manager 2007 (70-400)

MCP (Microsoft Certified Professional) Microsoft® Server Virtualization with Windows Server Hyper-V and System Center (70-409)

To view my full certification transcript, please go to http://www.microsoft.com/learning/mcp/transcripts
Transcript ID: 886095 and  Access Code: transcript

Disclaimer :The opinions expressed herein are my own personal opinions and do not represent anyone else's view in any way, including those of my employer and are  provided "AS IS" with no warranties.The Scripts that are posted here in this Blog are worked in my environment .Please test in Non-Production system before you execute it on any.

 

       

11 Responses to "About Author"

  1. Hi Eswar,
    This is Senthil(worked with you in Logica).Hope you remember me?
    Need help, we are facing issue in SCEP where 1901 statemessage is not sending,
    and how to repair SCEPinstall.exe

    Reply
    1. Hi Senthil,
      Yes ,i do remember,How are you ? for SCEP ,did you check the logs ? try to initiate the state messages on client.

      Regards,
      Eswar

      Reply
  2. Hi Eswar, I am looking for a query generating report for Required patches based on collection, the query I am using is not filtering servers based on collection, it shows list of all servers those are having SCCM agents installed and those servers needed patches, below is my query:

    Can you please help:

    1. Update_Dataset1

    elect Name0 as Machinename , CAST(DATEPART(yyyy,ui.DatePosted) AS varchar(255)) + '-' + RIGHT('0' + CAST(DATEPART(mm, ui.DatePosted) AS VARCHAR(255)), 2) AS MonthPosted,
    ui.bulletinid [BulletinID],ui.articleid [ArticleID], ui.Title,
    IsRequired=(case when css.Status=2 then 'YES' else '' end),
    ui.InfoURL as InformationURL,
    ui.dateposted [Date Posted]
    from V_UpdateComplianceStatus css
    join v_UpdateInfo ui on ui.CI_ID=css.CI_ID
    left join v_CITargetedMachines ctm on ctm.CI_ID=css.CI_ID and ctm.ResourceID = css.ResourceID
    left join v_FullCollectionMembership fcm on fcm.resourceid=fcm.resourceid
    and fcm.Collectionid= @Collection
    INNER join v_CICategories_All catall2 on catall2.CI_ID=css.CI_ID
    INNER join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID
    and catinfo2.CategoryTypeName='UpdateClassification'
    JOIN dbo.v_R_System AS vrs ON vrs.ResourceID = css.ResourceID
    outer apply (
    select Deadline=min(a.EnforcementDeadline)
    from v_CIAssignment a
    join v_CIAssignmentToCI atc on atc.AssignmentID=a.AssignmentID
    and atc.CI_ID=css.CI_ID
    ) cdl
    WHERE
    css.Status=2
    ORDER BY vrs.Name0

    2. CollectionIDParameterinputDataset

    Select CollectionID, Name from v_Collection Order by Name

    Reply
      1. Hello Eswar,

        Thank you for the update, I have used the query you provided and it looks good and shows the same result which query I am using

        I came to know that both queries (yours and mine) are showing same result for 43 servers out of 8000+ servers in "All Systems" collection especially for missing patches(compliant/non-compliant servers)

        However if I use WSUS console (old Separate server - not SCCM) and get the Needed patch report at that time I am getting needed patch report where for the same servers I do not see the missing patch (no data available) in SCCM

        the query I am using is:
        --------------------------------

        Dataset1
        =========

        Select Name0 as Machinename , CAST(DATEPART(yyyy,ui.DatePosted) AS varchar(255)) + '-' + RIGHT('0' + CAST(DATEPART(mm, ui.DatePosted) AS VARCHAR(255)), 2) AS MonthPosted,
        ui.bulletinid [BulletinID],ui.articleid [ArticleID], ui.Title,
        IsRequired=(case when css.Status=2 then 'YES' else '' end),
        ui.InfoURL as InformationURL,
        ui.dateposted [Date Posted],
        fcm.Collectionid
        from V_UpdateComplianceStatus css
        join v_UpdateInfo ui on ui.CI_ID=css.CI_ID
        left join v_CITargetedMachines ctm on ctm.CI_ID=css.CI_ID and ctm.ResourceID = css.ResourceID
        INNER join v_CICategories_All catall2 on catall2.CI_ID=css.CI_ID
        INNER JOIN v_FullCollectionMembership fcm on fcm.resourceid=css.resourceid
        INNER join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID
        and catinfo2.CategoryTypeName='UpdateClassification'
        JOIN dbo.v_R_System AS vrs ON vrs.ResourceID = css.ResourceID
        outer apply (
        select Deadline=min(a.EnforcementDeadline)
        from v_CIAssignment a
        join v_CIAssignmentToCI atc on atc.AssignmentID=a.AssignmentID
        and atc.CI_ID=css.CI_ID
        ) cdl
        WHERE
        css.Status=2
        and fcm.Collectionid= @Collection
        ORDER BY vrs.Name0
        --------------------------------------------
        Dataset2 - Query - to prompt collection Name
        --------------------------------------------

        Select CollectionID, Name from v_Collection Order by Name

        I am stuck at this point and it delays my project deployment... So seeking your help

        Thank you
        Tejas Patel

        Reply
        1. you need to drill down why other servers not showing in the report.the query which i sent works in my lab and production as well.I dont see any issues. You may have to troubleshoot further on this . It will be difficult to guide you without actually looking into the environment .

          Regards,
          Eswar

          Reply
          1. I have found the issue and resolved as well, it was not the query . The report was stuck at somewhere else..

            Thank you so much for your help in this regards....

            Tejas Patel

            Reply
            1. Hey, I ran the update scan report where I found the suspect that my default domain policy was conflicting message appeared (as old WSUS settings still placed under Default policy)

              I have tested by changing the group policy and it worked for me, however it took sometime to populate the report correctly but it did finally

              Thank you so much

              Tejas Patel

  3. Hi Eswar - First off, your blog is amazingly helpful. As a person tasked with moving our environment from vCM to SCCM I have spent many an hour combing this site for information. Thank you.
    Secondly, I have a question. Our business units like to see what updates will be applied to each machine before they sign off on the monthly patch window. Your "Computer Updates Status" report fits very closely to what I need... Is there a way to report on required updates for each server within a collection as a total report other than specifically choosing a server within said collection? I would love to have the formatting of the Computer Updates Status report but have it list each server within the chosen collection.

    Thank you for any advise.
    Justin Keeling

    Reply
    1. Hi Justin,
      sorry for the delay in reply but yes ,it is possible to get to know about what updates needed by which server after the software update scan successfully finished by the client (server) .There is post which i did last month about similar requirement ,have you looked at it ? http://eskonr.com/2016/02/sccm-configmgr-how-to-generate-patch-compliance-report-that-shows-all-updates-for-specific-collection/ take a read,see if you still need such kind of report ,if so , you can use the SQL code to get through the required patches before you deploy.

      Reply

Leave a Reply