PENDING Missing Reports in ConfigMgr Console

[Ase]

Hi,

I thought I would try to reach out for help here because I have not found the solution elsewhere.
I am missing 2 relevant reports for me in SCCM and would need some guidance, maybe these are already existing, but I have not found them.

Trying to explain them below:

Report 1 Example:
Computer 1 = 90% Compliant
Computer 2 = 50% Compliant
And so on.

Report 2 Example:
Computer 1 Missing Update:
SQL Server 2019 RTM Cumulative Update (CU) 19 KB5023049
Security Update for SQL Server 2019 RTM GDR (KB5021127)

Computer 2 Missing Update:
Windows 11……..
And so on.

Would be nice to have these 2 reports every morning in the mail.

Can anyone guide me forward?

Thanks,
Ase

 

[Garth]

I would start by looking at the built-in reports. Then setting up a subscription. https://askgarth.com/blog/how-to-set-up-an-email-subscription-in-ssrs/

 

[Ase]

I would start by looking at the built-in reports. Then setting up a subscription. https://askgarth.com/blog/how-to-set-up-an-email-subscription-in-ssrs/

Thanks for your fast reply Garth,

Setting up the mail subscription is not the issue, I just have not found any built-in reports that can give me the reports I would like to have.

There is a ton of built-in reports, but non that I could find could give me what I am searching for.

If I missed the obvious reports (as I see it) please guide with report name that I should check.

Thanks,
Ase

 

[Garth]

if you don't like the built-in reports you will have to write your own reports. Here are the supported SQL views that you can use. https://learn.microsoft.com/en-us/m...lviews/sql-server-views-configuration-manager