Close Menu
    Facebook X (Twitter) Instagram
    Monday, June 23
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»configmgr»What’s new in SCCM ConfigMgr 1902 Reporting

    What’s new in SCCM ConfigMgr 1902 Reporting

    Eswar KonetiBy Eswar KonetiMarch 28, 10:37 am2 Mins Read configmgr 4,166 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Microsoft has released SCCM ConfigMgr Current Branch build version 1902 and is available as in-console update and baseline version. You can apply this update on sites that runs on 1710,1802,1806 and 1810.

    If you want to install new site ,you can download 1902 as baseline . Download baseline version of 1902 from volume licensing or

    Once you update your existing version to 1902 ,you need to upgrade your secondary sites manually by right click on secondary site and upgrade.

    You also need to update your configmgr clients to latest version to newly supported client features.

    With 1902, there are bunch of new features added .Which means ,there is also number of SQL tables/views added which will help us to create custom reports.

    Following are the newly added SQL views for custom reporting.

    v_CH_ClientHealth
    v_ClientActionResultOfTaskSummary
    v_ClientActionResultSummary
    v_ConsoleAdminsData
    v_GS_OFFICE_ADDIN
    v_GS_OFFICE_DOCUMENTMETRIC
    v_GS_OFFICE_VBASUMMARY
    v_GS_PHYSICALDISK
    v_GS_SYSTEMBOOTDATA
    v_GS_SYSTEMBOOTSUMMARY
    v_Office_AdoptionStatus
    v_Office_EntityLookup
    v_Office_ValueLookup
    v_OfficeProplusReadinessStrings
    v_PhasedDeploymentOperationalDataCI
    v_PhasedDeploymentOperationalDataPkgProgram
    vSMS_CMPivotResult
    vSMS_OfficeProplusReadiness

    we can make use of these SQL views and create variety of dashboards.

    Looking at some of the office SQL views like v_GS_OFFICE_ADDIN,v_GS_OFFICE_VBASUMMARY,_GS_OFFICE_DOCUMENTMETRIC etc, it is now easier to take decision to move to 64bit proplus from 32bit.

    SCCM Configmgr 1902 build comes with following office 365 client management dashboard report and this dashboard is being made from these SQL tables/views.

    NewOffice365MgmgDashbord.png

    Microsoft recommends to install 64bit proplus for many reasons .If you look at this article ,Microsoft default option to install proplus from office 365 is 64bit. https://support.office.com/en-us/article/Choose-between-the-64-bit-or-32-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261#32or64Bit=Newer_Versions

    If you still want to go with 32bit then Read the reasons to choose 32bit version. The decision factor for choosing 32bit depends on the data that you get from SQL Views above (Office).

    We can now create some nice dashboards to monitor the system boot time for different models and take action against those causing trouble with long time boot.

    When creating client health reports, we can now use V_CH_ClientHealth as it contains almost all info about client health like last policy request,LastDDR,Lastonline time,last offline time,OS ,member of what collection etc.

    we can now monitor the CMPivot results executed by users and how much time does it take to run specific query. All this info stored in vSMS_CMPivotResult .Though it is not SQL view ,access to this table not permitted to all RBAC users/sccm console access unless you are SCCM Admin/SQL admin access provided.

    Download SCCM Configmgr SQL views documentation for 1902 from TechNet  https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

    Happy reporting!

    1902 Boot summary cmpivot configmgr console admin data console connected sessions Current branch office addin proplus readiness SCCM SQL reporting SQL views system boot time
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Troubleshooting Windows Hello for Business PIN Reset Issues – Something went wrong

    March 06, 9:48 pm

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.