SCCM Sql query to find servers


I want a sccm report or query output which has list of all servers which are non-compliant due to failed Office and Visual Studio updates.

Columns should have : Servername | Failed update Title| KB number

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
816 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Sherry Kissinger 3,801 Reputation points

    May I suggest importing these reports, authored by Bryan Dam?

    One of them seems to be close to what you want.

    1 person found this answer helpful.
    0 comments No comments

  2. Garth 5,801 Reputation points

    First off have you looked at the built in reports for this.

    Secondly, if you want a custom report, what do you have for a query now and what isn't working with it?

  3. Sherry Kissinger 3,801 Reputation points