MECM Reporting

Question

Hi,

After server patching with latest updates, possible to generate report to show which updates been applied together with those server been updated as well. As i don't see from default reporting able to do it. How to go about to use sql report builder?

Answer 1

If the built-in reports do not fulfill your needs. the SQL views are listed within the docs and you and create your own. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/software-updates-views-configuration-manager

Understand that SU reports are hardest reports to get right.

Answer 2

What exactly are you trying to get? What wrong with comp 5 report?

Answer 3

If you are want to learn about reporting. This book will help. https://www.informit.com/store/system-center-configuration-manager-reporting-unleashed-9780134466811

Answer 4

@Garth Jones

I'm trying to gathering a report to display around 300 servers to show latest updates been applied. In the report shall display hostname, software updates and installed status