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 2006 for custom reports

    What is new in Configuration Manager 2006 for custom reports

    Eswar KonetiBy Eswar KonetiSeptember 20, 12:04 am2 Mins Read configmgr 1,817 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Microsoft has released Microsoft Endpoint Manager Configuration Manager build 2006 (MEMCM) via the opt-in method (fast-ring) on 8th of August, followed by slow-ring (GA) on 31st Aug.

    If you want to install a new Configuration Manager site (fresh build), you can download the baseline version which is 2003 from the volume licensing portal, and then do an in-console update to 2006.

    For more information about what’s new in Configuration Manager 2006, please refer https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/changes/whats-new-in-version-2006

     And for a step-by-step guide to 2006, https://systemcenterdudes.com/step-by-step-sccm-2006-upgrade-guide/  

    Once you complete the CAS/Primary site server update, you need to manually upgrade any secondary sites by right-clicking on the site and choose the upgrade.

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

    As usual, whenever there is a new configuration manager build released, there are always new SQL views for the newly released/updated features which will help us to generate custom reports without doing any MOF extensions (in case you have done it for these).

    In Configuration Manager 2006, there are few SQL Views added compared to its previous version 2002 listed below for your reference.

    v_ClientEvents
    v_DeviceApplicationTargeting
    v_EventProperty
    vCMGS_InventoryClass
    vCMGS_InventoryClassProperty
    vCMGS_MIResults
    vCMGS_PolicySummary
    vCMGS_PolicySummaryResources
    vSMS_BannerNotificationsLocalization
    What's new in Configuration Manager 2006 Reporting

    Since the Technet gallery is retiring very soon, I have uploaded the Microsoft Endpoint Manager SQL Views for the build 2006 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

    2006 configmgr Configmgr Current Branch Reports SCCM SQL 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.