{"id":9834,"date":"2022-07-05T16:24:59","date_gmt":"2022-07-05T16:24:59","guid":{"rendered":"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/?p=9834"},"modified":"2022-07-05T22:22:45","modified_gmt":"2022-07-05T22:22:45","slug":"monitor-windows-update-installation-progression","status":"publish","type":"post","link":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/","title":{"rendered":"Monitor Windows Update Installation Progression"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One of the most common requests that we hear from our Endpoint Manager reporting solutions BI for SCCM and BI for Intune customers is that they would like to have the ability to track the progression of deployments. This can be any type of deployment such as a new application or Windows Updates. This is not a new request, I&#8217;ve heard similar requests from management for the 20 or so years that I have been working with ConfigMgr and Intune. Sadly, the answer has always been the same, &#8220;This is just not something that the product(s) were built to do&#8221;. I can tell you how many devices have something installed today, but seeing the progression of the installs has historically not been something that we could provide. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>This is just not something that ConfigMgr was built to do.<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Well, we couldn&#8217;t easily do it until now&#8230; With the introduction of scorecards and the <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-goals-is-now-metrics-and-is-moving-to-ga\/\" target=\"_blank\" rel=\"noreferrer noopener\">general availability of metrics<\/a> in Power BI now you can leverage BI for SCCM and\/or BI for Intune to track the progression of any deployment type. In a nutshell the scorecard takes a snap-shot of the data that you want to track at intervals you define. To quote the Microsoft documentation, &#8220;Metrics in Power BI let customers curate their metrics and track them against key business objectives, in a single pane.&#8221; These capabilities open a new world of possibilities in terms of producing, and taking action upon, Key Performance Indicators (KPI) that have tremendous business value. We can even automate <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-goals-power-automate\" target=\"_blank\" rel=\"noreferrer noopener\">actions based upon the data<\/a> in the scorecard using Power Automate. For example, you might want to send out notifications if your updates compliance does not reach a particular milestone. Or, you might want to pause the next update ring. Again, the possibilities are endless. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is not my intention to describe a one-size fits all solution in this blog. This blog intends to provide information about these new Power BI features and to plant a seed that you can grow into solutions that fit your organization&#8217;s unique needs.<\/p>\n\n\n\n<hr class=\"wp-block-separator aligncenter has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites:<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Power BI Pro license.<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-roles-new-workspaces\" target=\"_blank\" rel=\"noreferrer noopener\">Admin, Member, or Contributor role<\/a> in a workspace.<\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-datasets-build-permissions\" target=\"_blank\" rel=\"noreferrer noopener\">Build permission<\/a> for the dataset.<\/li><li>Basic knowledge of creating reports in Power BI.<\/li><li>A paid or trial subscription to BI for SCCM or BI for Intune. <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a scorecard<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Sign-in to Power BI (app.powerbi.com)<\/li><li>Select <strong>Metrics<\/strong> in the navigation pane.<\/li><li>Select <strong>New scorecard<\/strong>.<\/li><li>Name your scorecard, provide a description, and select the BI for SCCM or BI for Intune workspace.<\/li><li>Select <strong>Create<\/strong>.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-3 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/metrics_hub_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"936\" data-id=\"9876\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/metrics_hub_2.png\" alt=\"\" class=\"wp-image-9876\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_hub_2.png 850w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_hub_2-272x300.png 272w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_hub_2-768x846.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/new_scorecard_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"936\" data-id=\"9875\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/new_scorecard_2.png\" alt=\"\" class=\"wp-image-9875\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/new_scorecard_2.png 850w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/new_scorecard_2-272x300.png 272w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/new_scorecard_2-768x846.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/create_scorecard_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"850\" height=\"963\" data-id=\"9874\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/create_scorecard_2.png\" alt=\"\" class=\"wp-image-9874\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/create_scorecard_2.png 850w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/create_scorecard_2-265x300.png 265w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/create_scorecard_2-768x870.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/create_scorecard_2-530x600.png 530w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Create Metrics<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First you need a source to define your metrics. The metrics that you select can be anything that you want to measure. In this example I will use a simple page that I created in BI for Intune to count the number of devices on given versions of Windows 10. Once I have setup my metrics I come back and set the page as hidden since it&#8217;s not page that I want anyone to interact with directly. It&#8217;s purpose is simply to provide the data used for the scorecard metrics. I will use the count of devices on the June 2022 Windows 10 cumulative update as the current value and the total number of devices as the target value in the scorecard.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/metrics_source_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1967\" height=\"643\" data-id=\"9882\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/metrics_source_2.png\" alt=\"\" class=\"wp-image-9882\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_source_2.png 1967w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_source_2-300x98.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_source_2-1024x335.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_source_2-768x251.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/metrics_source_2-1536x502.png 1536w\" sizes=\"auto, (max-width: 1967px) 100vw, 1967px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Name your metric, provide the start and dues dates.<\/li><li>Select <strong>Connect to data<\/strong> in the <strong>Current<\/strong> field.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-3 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_current_value.png\"><img loading=\"lazy\" decoding=\"async\" width=\"3496\" height=\"636\" data-id=\"9883\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_current_value.png\" alt=\"\" class=\"wp-image-9883\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value.png 3496w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value-300x55.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value-1024x186.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value-768x140.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value-1536x279.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value-2048x373.png 2048w\" sizes=\"auto, (max-width: 3496px) 100vw, 3496px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the report that has the data you want to track.<\/li><li>Select <strong>Next<\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-4 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data.png\"><img loading=\"lazy\" decoding=\"async\" data-id=\"9884\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-1024x247.png\" alt=\"\" class=\"wp-image-9884\" width=\"1024\" height=\"247\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-1024x247.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-300x72.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-768x186.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-1536x371.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_data-2048x495.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the report page that contains the data that you would like to track. <\/li><li>Select the visual that contains the data that contains the item that you would like to track. In this example I have select a visual that shows the number of devices currently on the June 2022 Windows 10 cumulative update.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-5 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"602\" data-id=\"9885\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-1024x602.png\" alt=\"\" class=\"wp-image-9885\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-1024x602.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-300x176.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-768x451.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-1536x902.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_current_value_visual-2048x1203.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select <strong>Connect to data<\/strong> in the <strong>Final target<\/strong> field.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-6 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_select_target.png\"><img loading=\"lazy\" decoding=\"async\" data-id=\"9886\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_select_target-1024x180.png\" alt=\"\" class=\"wp-image-9886\" width=\"1024\" height=\"180\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_select_target-1024x180.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_select_target-300x53.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_select_target-768x135.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_select_target-1536x270.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_select_target-2048x361.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the report page that contains the data that you would like to track. <\/li><li>Select the visual that contains the data that contains the item that you would like to track. In this example I have select a visual that shows the total number of Windows 10 devices.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-7 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_target_value.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"602\" data-id=\"9887\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_target_value-1024x602.png\" alt=\"\" class=\"wp-image-9887\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_target_value-1024x602.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_target_value-300x176.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_target_value-768x452.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_target_value-1536x903.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_target_value-2048x1205.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select <strong>Save<\/strong>.<\/li><li>You might consider automating the status of the item being tracked, for example if you have reached a given percentage of compliant devices within a given number of days you might set the status to &#8220;At Risk&#8221;. You might also consider setting submetrics. For example, you might want to track each of your update rings individually.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-8 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics.png\"><img loading=\"lazy\" decoding=\"async\" data-id=\"9888\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-1024x173.png\" alt=\"\" class=\"wp-image-9888\" width=\"1024\" height=\"173\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-1024x173.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-300x51.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-768x130.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-1536x260.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_save_metrics-2048x347.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the metric that you&#8217;ve just created.<\/li><li>On the <strong>Settings<\/strong> tab select the <strong>Frequency<\/strong> that you&#8217;d like to track the change.<\/li><li>Select <strong>Track<\/strong>.<\/li><li>You have complete the steps to create a basic scorecard.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-9 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"205\" data-id=\"9889\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-1024x205.png\" alt=\"\" class=\"wp-image-9889\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-1024x205.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-300x60.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-768x154.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-1536x307.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_tracking_frequency-2048x410.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As the data in the report changes the changes are tracked by the scorecard. Once you have collected some data you can view the progression in the scorecard details.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-10 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_details.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"241\" data-id=\"9890\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_details-1024x241.png\" alt=\"\" class=\"wp-image-9890\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_details-1024x241.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_details-300x71.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_details-768x180.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_details-1536x361.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_details-2048x481.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>You might chose to add your scorecard to a page in a report to make it easier to access.<\/li><li>You might chose to create a flow to take actions based upon the data in the scorecard.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-gallery aligncenter has-nested-images columns-default is-cropped wp-block-gallery-11 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_report.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"527\" data-id=\"9891\" src=\"http:\/\/ec2-34-223-90-224.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2022\/07\/scorecard_report-1024x527.png\" alt=\"\" class=\"wp-image-9891\" srcset=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_report-1024x527.png 1024w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_report-300x154.png 300w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_report-768x395.png 768w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_report-1536x790.png 1536w, https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/scorecard_report-2048x1053.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">References and more reading:<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/powerbi.microsoft.com\/en-us\/blog\/power-bi-goals-is-now-metrics-and-is-moving-to-ga\/\" target=\"_blank\" rel=\"noreferrer noopener\">Goals in Power BI is becoming \u2018metrics\u2019 and is moving to GA!<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-goals-create\" target=\"_blank\" rel=\"noreferrer noopener\">Create scorecards and manual metrics in Power BI<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-goals-create-connected\" target=\"_blank\" rel=\"noreferrer noopener\">Create connected metrics in Power BI<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-goals-power-automate\" target=\"_blank\" rel=\"noreferrer noopener\">Use Power Automate to update metrics automatically<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to monitor installation progression of Windows Updates and other deployment types using Power BI.<\/p>\n","protected":false},"author":1,"featured_media":9836,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[117,118,116],"tags":[],"class_list":["post-9834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-for-intune","category-bi-for-sccm","category-power-bi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Monitor Windows Update Installation Progression - PowerStacks<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Monitor Windows Update Installation Progression - PowerStacks\" \/>\n<meta property=\"og:description\" content=\"How to monitor installation progression of Windows Updates and other deployment types using Power BI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\" \/>\n<meta property=\"og:site_name\" content=\"PowerStacks\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-05T16:24:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-05T22:22:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"John Marcum\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MEM_MVP\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#organization\",\"name\":\"PowerStacks\",\"url\":\"https:\/\/srrafi.com\/wp\/july\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/ec2-35-86-188-144.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2021\/12\/logo2-sticky.png\",\"contentUrl\":\"http:\/\/ec2-35-86-188-144.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2021\/12\/logo2-sticky.png\",\"width\":800,\"height\":400,\"caption\":\"PowerStacks\"},\"image\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#website\",\"url\":\"https:\/\/srrafi.com\/wp\/july\/\",\"name\":\"PowerStacks\",\"description\":\"Power BI for Endpoint Manager Intune and SCCM\",\"publisher\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/srrafi.com\/wp\/july\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage\",\"url\":\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png\",\"contentUrl\":\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png\",\"width\":600,\"height\":400},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\",\"url\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\",\"name\":\"Monitor Windows Update Installation Progression - PowerStacks\",\"isPartOf\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage\"},\"datePublished\":\"2022-07-05T16:24:59+00:00\",\"dateModified\":\"2022-07-05T22:22:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/srrafi.com\/wp\/july\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Monitor Windows Update Installation Progression\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\"},\"author\":{\"name\":\"John Marcum\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/4e4b6b8f6c1f30c6773821dcd8a4b412\"},\"headline\":\"Monitor Windows Update Installation Progression\",\"datePublished\":\"2022-07-05T16:24:59+00:00\",\"dateModified\":\"2022-07-05T22:22:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/\"},\"wordCount\":875,\"publisher\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#organization\"},\"image\":{\"@id\":\"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png\",\"articleSection\":[\"BI for Intune\",\"BI for SCCM\",\"Power BI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/4e4b6b8f6c1f30c6773821dcd8a4b412\",\"name\":\"John Marcum\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb7ceb38de1242de6c482b5cea8519362062970c2069573b282d5bc7bec27785?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb7ceb38de1242de6c482b5cea8519362062970c2069573b282d5bc7bec27785?s=96&d=mm&r=g\",\"caption\":\"John Marcum\"},\"description\":\"ohn Marcum is a Technical Architect and Program Manager for PowerStacks BI products for Endpoint Manager residing in Alabama. John is an active blogger and he participates regularly in the Configuration Manager and Intune forums on Reddit as well as Twitter and LinkedIn. John devotes much of his time to conquering device management challenges. When he is not blogging, answering questions online, expanding his skill sets or working, he enjoys spending time on the lake where he lives.\",\"sameAs\":[\"https:\/\/twitter.com\/MEM_MVP\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Monitor Windows Update Installation Progression - PowerStacks","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/","og_locale":"en_US","og_type":"article","og_title":"Monitor Windows Update Installation Progression - PowerStacks","og_description":"How to monitor installation progression of Windows Updates and other deployment types using Power BI.","og_url":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/","og_site_name":"PowerStacks","article_published_time":"2022-07-05T16:24:59+00:00","article_modified_time":"2022-07-05T22:22:45+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png","type":"image\/png"}],"author":"John Marcum","twitter_card":"summary_large_image","twitter_creator":"@MEM_MVP","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/srrafi.com\/wp\/july\/#organization","name":"PowerStacks","url":"https:\/\/srrafi.com\/wp\/july\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/srrafi.com\/wp\/july\/#\/schema\/logo\/image\/","url":"http:\/\/ec2-35-86-188-144.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2021\/12\/logo2-sticky.png","contentUrl":"http:\/\/ec2-35-86-188-144.us-west-2.compute.amazonaws.com\/wordpress\/wp-content\/uploads\/2021\/12\/logo2-sticky.png","width":800,"height":400,"caption":"PowerStacks"},"image":{"@id":"https:\/\/srrafi.com\/wp\/july\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/srrafi.com\/wp\/july\/#website","url":"https:\/\/srrafi.com\/wp\/july\/","name":"PowerStacks","description":"Power BI for Endpoint Manager Intune and SCCM","publisher":{"@id":"https:\/\/srrafi.com\/wp\/july\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/srrafi.com\/wp\/july\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage","url":"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png","contentUrl":"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png","width":600,"height":400},{"@type":"WebPage","@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/","url":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/","name":"Monitor Windows Update Installation Progression - PowerStacks","isPartOf":{"@id":"https:\/\/srrafi.com\/wp\/july\/#website"},"primaryImageOfPage":{"@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage"},"datePublished":"2022-07-05T16:24:59+00:00","dateModified":"2022-07-05T22:22:45+00:00","breadcrumb":{"@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/srrafi.com\/wp\/july\/"},{"@type":"ListItem","position":2,"name":"Monitor Windows Update Installation Progression"}]},{"@type":"Article","@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#article","isPartOf":{"@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/"},"author":{"name":"John Marcum","@id":"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/4e4b6b8f6c1f30c6773821dcd8a4b412"},"headline":"Monitor Windows Update Installation Progression","datePublished":"2022-07-05T16:24:59+00:00","dateModified":"2022-07-05T22:22:45+00:00","mainEntityOfPage":{"@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/"},"wordCount":875,"publisher":{"@id":"https:\/\/srrafi.com\/wp\/july\/#organization"},"image":{"@id":"https:\/\/srrafi.com\/wp\/july\/monitor-windows-update-installation-progression\/#primaryimage"},"thumbnailUrl":"https:\/\/srrafi.com\/wp\/july\/wp-content\/uploads\/2022\/07\/trending_up.png","articleSection":["BI for Intune","BI for SCCM","Power BI"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/4e4b6b8f6c1f30c6773821dcd8a4b412","name":"John Marcum","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/srrafi.com\/wp\/july\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eb7ceb38de1242de6c482b5cea8519362062970c2069573b282d5bc7bec27785?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb7ceb38de1242de6c482b5cea8519362062970c2069573b282d5bc7bec27785?s=96&d=mm&r=g","caption":"John Marcum"},"description":"ohn Marcum is a Technical Architect and Program Manager for PowerStacks BI products for Endpoint Manager residing in Alabama. John is an active blogger and he participates regularly in the Configuration Manager and Intune forums on Reddit as well as Twitter and LinkedIn. John devotes much of his time to conquering device management challenges. When he is not blogging, answering questions online, expanding his skill sets or working, he enjoys spending time on the lake where he lives.","sameAs":["https:\/\/twitter.com\/MEM_MVP"]}]}},"_links":{"self":[{"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/posts\/9834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/comments?post=9834"}],"version-history":[{"count":21,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/posts\/9834\/revisions"}],"predecessor-version":[{"id":9899,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/posts\/9834\/revisions\/9899"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/media\/9836"}],"wp:attachment":[{"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/media?parent=9834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/categories?post=9834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/srrafi.com\/wp\/july\/wp-json\/wp\/v2\/tags?post=9834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}