Report generate from SCCM how many servers are patched and how many missing.

Dinesh Negi 66

Hi,

Anybody know how to generate Report from SCCM how many servers are patched and how many missing.

5 answers

piotrlapkowski 5 Reputation points

2023-03-27T19:20:27.4333333+00:00

To verify the SCCM database has the Windows updates you need, run this query:

SELECT v_Update_ComplianceStatusAll.ResourceID, Client_Version0, Distinguished_Name0, Name0, Netbios_Name0, BulletinID, ArticleID, Title

FROM v_r_system

inner join v_Update_ComplianceStatusAll ON v_Update_ComplianceStatusAll.ResourceID=v_r_system.resourceid

inner join v_UpdateInfo ON v_UpdateInfo.CI_ID=v_Update_ComplianceStatusAll.CI_ID

AND v_Update_ComplianceStatusAll.Status IN (2, 3)

More on https://docs.flexera.com/csionprem/Content/helplibrary/Configuring_SCCM_to_Report_Windows_Update_Information.htm
Please sign in to rate this answer.

1 person found this answer helpful.
Dinesh Negi 66 Reputation points

2023-03-29T10:37:31.1633333+00:00

Here is my query.

Anybody know how to generate Report from SCCM how many servers are patched and how many missing.
Sign in to comment
Garth 411 Reputation points

2023-03-07T14:42:10.32+00:00

What is wrong with the built in reports for this?
Please sign in to rate this answer.
Dinesh Negi 66 Reputation points

2023-03-09T03:42:40.26+00:00

Build reports means? I don't have much experience but want to generate list of missing patch servers.

Garth 411 Reputation points

2023-03-09T15:58:24.95+00:00

This book will give you a guide on creating your own custom reports. https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811
Sign in to comment
CherryZhang-MSFT 6,481 Reputation points

2023-03-09T09:22:05.9133333+00:00
Hi @Chotudin,

Hope the following reports can help you.

Management 5 - Deployments that target a computer: Displays all software update deployments that are deployed to a specified computer.

Management 8 - Computers missing content (secondary): Displays all computers requiring the specified software update, but the associated content isn't yet distributed to a distribution point.

States 3 - States for a deployment and computer: Displays the states for all software updates in the specified deployment for a specified computer.

Troubleshooting 4 - Computers failing with a specific deployment error (secondary): Displays a list of the computers on which the deployment of update is failing because of a specified error.

Thanks for your time.

Best regards,
Cherry
Please sign in to rate this answer.
Dinesh Negi 66 Reputation points

2023-03-11T11:59:35.97+00:00

Thanks for your update.

We have around 600+ servers in SCCM and created group by customer name. So, I want to generate the report, servers which are never patched or may be not patched from last 1 year.

CherryZhang-MSFT 6,481 Reputation points

2023-03-14T09:42:15.55+00:00

Hi @Chotudin,

We can check the client last patched time by check the database. To do it please refer to the following steps:

1, Collect relevant information through hardware inventory. The screenshot for your reference:

2, We can get the client update installed time from the table v_GS_QUICK_FIX_ENGINEERING in database.

Thanks for your time.

Best regards,
Cherry

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.

Dinesh Negi 66 Reputation points

2023-03-15T10:45:32.53+00:00

I got above screen shot.

So what's need to next

CherryZhang-MSFT 6,481 Reputation points

2023-03-22T04:48:20.7733333+00:00

Hi,

select v_R_System.ResourceID, v_R_System.Name0, Description0, HotFixID0, InstalledBy0, InstalledOn0 Into Temporary from v_GS_QUICK_FIX_ENGINEERING, v_R_System where v_GS_QUICK_FIX_ENGINEERING. ResourceID = v_R_System. ResourceID

select * from Temporary

Through the above query, you can get the date when the client installed the update. To do it please open your SQL Server Management Studio> Right-click CM_XXX> New Query.

Thanks for your time and patience!

Best regards,
Cherry
Sign in to comment
Dinesh Negi 66 Reputation points

2023-03-27T15:12:31.3333333+00:00

I can see only
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Dinesh Negi 66 Reputation points

2023-03-27T15:23:57.2733333+00:00

no data is showing .
Please sign in to rate this answer.
CherryZhang-MSFT 6,481 Reputation points

2023-03-28T02:43:01.0366667+00:00

Hi,

For Hardware Inventory Classes, have you checked them and deployed this Client Settings to collect the relevant information?
Sign in to comment