Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Patching report sccm

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

 

Report Server

1 Reply

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    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!