Close Menu
    Facebook X (Twitter) Instagram
    Sunday, October 12
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»configmgr»What is new in Configuration Manager 2002 reporting

    What is new in Configuration Manager 2002 reporting

    Eswar KonetiBy Eswar KonetiMay 06, 3:05 pm2 Mins Read configmgr 1,678 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2002 (MEMCM) via the opt-in method (fast-ring) which will is now available for you to install and also baseline version however the baseline media is not yet available for the download. The baseline version will be released when the build is made available to the console via slow-ring.

    If you want to install a new Configuration Manager sites (fresh build), you can download 1902 as a baseline from the volume licensing portal until 2002 is released.

    For more information about how to perform the in-console update for configuration manager update 2002, please refer here

    After the in-console update, you need to manually upgrade any secondary sites by right click on the site and choose the upgrade.

    You also need to update your Configuration Manager clients to the latest version (2002) to avail the new client features that were added.

    With this update 2002 build, there are a bunch of new features added. This means, there are also a number of SQL tables/views added which will help us to create some great custom reports.

    The following are the newly added SQL views/tables/functions for custom reporting.

    v_Applications
    v_BoundaryGroup
    v_CIRemediationHistory
    v_ConsoleDistinctLatestStartUpDuration
    v_ConsoleLatestStartUpDuration
    v_ConsoleLatestStartUpDurationPerUser
    v_DefaultBrowserData
    v_DeviceApplicationState
    v_GS_BROWSER_USAGE
    v_HS_BROWSER_USAGE
    vApp_TSDTAssignmentReferences
    vApp_TSDTReferences
    vCMGS_AppProgramSyncData
    vCMGS_CollectionSyncData
    vSMS_Azure_CloudServiceHist
    vSMS_CM_FeatureStatusAll

    Since the Technet gallery is retiring very soon, I have uploaded the Microsoft Endpoint Manager SQL Views for the build 2002 and also the previous builds to Github for your reference.

    Download the SQL views for reporting from Github

    Happy reporting!

    Recommended reading:

    SQL Server views in Configuration Manager

    Creating custom reports by using SQL Server views in Configuration Manager

    configuration Manager Custom reporting endpoint manager MEMCM Reporting SCCM SQL views
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    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-2025 Eswar Koneti, All rights reserved.

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