UCServiceUpdateStatus

Update Compliance - Update Event that comes directly from the service-side, and only tells the "service-side" of the story, for one device (client), and one update, in one deployment. As such, this event is stripped of certain fields in favor of being able to show data in near real-time.

Solutions

  • Update Compliance

Columns

Column Type Description
AzureADDeviceId string A GUID corresponding to the AAD Tenant to which the device belongs.
AzureADTenantId string A GUID corresponding to this device's AAD Device ID
DeploymentId string The identifier of the Deployment that is targeting this update to this device, else empty.
DeploymentIsExpedited bool Whether this content is being expedited by WUfB DS.
GlobalDeviceId string Microsoft internal Global Device Identifier
OfferReadyTime datetime DateTime of OfferReady transition. If empty, not yet been Offered.
ProjectedOfferReadyTime datetime Projected time update will be Offered to device. If empty, unknown.
ServiceState string High-level state of update's status relative to device, service-side.
ServiceSubstate string Last-known state of this update relative to the device, from the client (the device's WDD).
ServiceSubstateRank int Ranking of Substates for sequential ordering in funnel-type views. The rankings between ServiceSubstate and ClientSubstate can be used together.
ServiceSubstateTime datetime DateTime of last ServiceSubstate transition.
SourceSystem string
TargetBuild string The full build of the content this DeviceUpdateEvent is tracking. For Windows 10 updates, this would correspond to the full build (10.0.14393.385).
TargetVersion string The target OS Version - eg, 1909.
TenantId string
TimeGenerated datetime Time at which this event is generated.
Type string The name of the table
UpdateCategory string The type of content this DeviceUpdateEvent is tracking.
UpdateClassification string Whether this content is an Upgrade (FU), Security (QU), NonSecurity (QU).
UpdateDisplayName string The long-form display name for the given update. Varies on content type (FU/QU).
UpdateManufacturer string Manufacturer of update. Microsoft for WU FU/QU, for D&F name of driver manufacturer e.g. NVIDIA.
UpdateReleaseTime datetime DateTime of update's release date.