SCCM Sql query to find servers

Anonymous
2023-03-02T07:36:44.24+00:00

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
    2023-03-02T13:35:20.6333333+00:00

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

    https://damgoodadmin.com/2018/01/24/yet-another-software-update-dashboard/

    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
    2023-03-02T11:17:44.8233333+00:00

    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
    2023-03-02T13:36:13.4166667+00:00