About Author

Hi and Welcome to my blog eskonr.com

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

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/office365/Intune to explore different things and share my experience on my blog.

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

I was awarded by Microsoft with Title ‘Microsoft Most Valuable Professional’ for my technical contributions towards Microsoft technical Forums ,blogging and other forums in year 2017.

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.

 

       

26 Responses to "About Author"

  1. Hi Eswar
    We have deployed a new task sequences and my manager asked me to pull out a report of the task sequence on a particular collection.
    Report which we created is giving the output as below.

    Execution State Number of Computers Percent of Total Deployment ID
    Accepted 54 76.10% GSXXXXX
    Failed 1 1.40% GSXXXXX
    No Status 4 5.60% GSXXXXX
    Running 2 2.80% GSXXXXX
    Succeeded 10 14.10% GSXXXXX

    But the requirement is to get a report as below.

    Computer Name Execution-state Deployment_ID Last_Acceptence_Time LastStatustime

    Client1 Success GS2XXXXXX DD/MM/YYYY HH:MIN:SEC DD/MM/YYYY HH:MIN:SEC

    Client2 Failure GS2XXXXXX DD/MM/YYYY HH:MIN:SEC DD/MM/YYYY HH:MIN:SEC

    Reply
    1. This is more of customized report .need to review the information that is stored in what SQL views/tables and build it.
      I dont have any custom report for it and due to time limitation ,i can add to to-do list which takes time.

      Regards,
      Eswar

      Reply
      1. Thanks Eswar for the Reply!!!
        Below query helped me to achieve this.

        SELECT[Name0]

        ,[Full_Domain_Name0]

        ,[LastStateName]

        ,[LastAcceptanceStatusTime]

        ,[LastStatusTime]

        ,[User_Name0]

        FROM [osdp232a].[dbo].[v_R_System] Hostname

        JOIN [osdp232a].[dbo].[vSMS_ClientAdvertisementStatus] Numbers

        ON Numbers.[ResourceID] = Hostname.[ResourceID]

        where AdvertisementID = 'XXXXXX'

        Order by [LastStateName]

        Reply
  2. Hi Eswar,

    How are you? I'm Asanka from Sri Lanka. It's a nice blog related specially to SCCM. I'm need a help from you and this is not related to any Technical issues. I'm also planing to start a blog and I like your WordPress Theme but coudn't find it from WordPress.com. Possible to share the Theme Name..

    Reply
  3. Hi Eswar,

    i am trying to deploy an application (msi) 'Symantec encription desktop' via sccm application model. the command line is as below
    msiexec /i "PGPDesktop.msi" TRANSFORMS= Symantec_Encryption_Desktop_10.4.1_R01_X64.mst /qn
    but it got stuck as installing and i am getting details in appenforce is as below
    Waiting for process 2328 to finish. Timeout = 120 minutes.
    after 120 minutes its getting failed with timeout error.
    please suggest

    Reply
      1. Hi Eswar, Great reports on MS counts. I downloaded your latest Count of MS office Version and notice that the result of 32 bit and 64 bit got flipped-flopped. Any thoughts? Thank you!! b Gary.

        Reply
        1. what you mean by flipped-flopped ? reverse the count ? Did you check the SQL code for how 32bit and 64bit is calculated have a check to see if the logic wrong or not.
          How do you say the results are not correct ?

          Regards,
          Eswar

          Reply
          1. Thank you for the reply. Yes, 64 bit office has the number count of 32 bit and vice versa (e.g. i have 600 copies of 32bit office but listed under the 64bit row). Will look into the SQL code. Thanks again for your help.

            Reply
            1. where did they installed ? is it under c:\program files or C:\program files(x86) .
              SQL Code used to determine 32 and 64bit is below

              Case substring(sof.SoftwareCode0,21,1)
              When '0' Then '32-bit'
              When '1' Then '64-bit'
              Else 'Unknown'
              End
              from v_GS_INSTALLED_SOFTWARE sof

              Can you pick any one client that is installed with office and find the SoftwareCode0 listed in v_GS_INSTALLED_SOFTWARE as part of troubleshooting.

              Regards,
              Eswar

            2. Will look into it. Your earlier scripts has the right output. Just the latest one that you posted that I am having problem. Will look into your suggestion and keep you posted. Thank you!!

  4. 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
  5. 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

  6. 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