Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»Download SCCM Configmgr 2012 R2 SQL Views

    Download SCCM Configmgr 2012 R2 SQL Views

    Eswar KonetiBy Eswar KonetiOctober 29, 7:28 pm1 Min Read CM2012 4,522 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/.

    SQL Views are very useful while working with reports and it saves lot of time in searching the particular information if you are unsure where it resides.

    SQL Views provides the information help you in creating custom reports, determine which configmgr 2012 R2 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them.

    With the release of Configmgr 2012 R2,there has been some SQL Views added extra from its previous version (i.e Configmgr 2012 SP1),with this,i would like to share the updated spread sheet with the available SQL Views.

    Total number of SQL Views in Configmgr 2012 R2:1434 and columns :21104,for list of total sql views,its column and its datatype (int,varchar,varbinary etc) Download the spreadsheet from TechNet gallery

    Configmgr 2012 R2 SQL Views Document R2 SCCM 2012 SQL views SQL Views for SCCM 2012 R2 Views
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

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

    February 11, 9:50 pm

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    Investigating Co-Management Issues with Windows Endpoints in SCCM/Intune

    October 26, 10:45 pm

    1 Comment

    1. Pingback: SQL query to obtain list of SCCM SQL views for report building. | System Center Guru

    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.