Forum Discussion
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...
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!