Patching report sccm

[Anonymous]

Hi,

I need help. I would like to create reports on PowerBi from Sccm.

I would like to know about my servers 3 things:

• Check if the last search date was not older than 30 days
• Check if the last patch date is not older than 36 days
• Check if the last patch date was successful

Can someone help me i am new to PowerBI?

Thank you in advance,

Kind regards

[KBO]

Hi @Anonymous ,

do you already connected to the sccm db? 🙂

How your sccm db is build? Look around and make yourselfe familiar with all the tables and columns. An then If you found the tables/columns you need you can build your report.

I uses for Buttons with time ranges this : https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive , you can also create a seperate time table and use this for Buttons with time ranges ;).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!