Share via

SCCM SQL Queries

ACallisto 21 Reputation points
2020-09-24T02:38:14.267+00:00

Hello,

Was wondering if anyone has posted a recent list of SCCM SQL Queries?

There was one posted by A, Karthikeyan, but this was created in 2017

Regards

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
462 questions
Microsoft Configuration Manager
0 comments
Accepted answer
  1. AllenLiu-MSFT 41,611 Reputation points Microsoft Vendor
    2020-09-24T07:21:09.133+00:00

    @ACallisto
    Thank you for posting in Microsoft Q&A forum.
    These are just some of the commonly used queries that the author has compiled for us, most of them should still be applicable to the current SCCM version, only a few views may have been changed, here is the views of each version of SCCM collected by Eswar koneti:
    https://gallery.technet.microsoft.com/SCCM-Configmgr-2012-R2-SQL-5fefdd3b

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Eswar Koneti 2,201 Reputation points
    2020-09-24T03:19:54.32+00:00

    SQL queries is something can be created in infinite based on the requirements.
    What is that you looking for in the query? there are tons of default reports available in ConfigMgr and if there is something you need out of the box, you can start cloning the existing report or create a new based on the needs.

    0 comments
  2. ACallisto 21 Reputation points
    2020-09-24T04:19:08.68+00:00

    Hello,

    Something similar to the attached27885-ti091-sccm-sql-queries-2.pdf

    0 comments
  3. Garth Jones 2,076 Reputation points
    2020-09-24T11:04:45.52+00:00

    Since vary little has change with cm view structure since sms 2003. Just about anything you find should work. The thing to remember is that not all queries are created equal. There are a ton of configmgr queries put there that use unsupported views and are poorly written.

    All of this is to say be careful with what you find.