Hi guys,
I have a query that I created for reporting on the update status and have added it to my Power Bi report but I would just like to confirm its correct. So normally I just had the WaasupdateStatus and WaasDeploymentStatus tables on their own but I did a join on the 2 tables and would just like to know if my join is correct. The issue I see is that the computer count from the WaasDeploymentStatus seems different to when the 2 are joined.
Below is my query
WaaSUpdateStatus
| join kind=inner WaaSDeploymentStatus on Computer
| project Computer, ComputerID, DeferralDays, DeploymentError, DeploymentErrorCode, DeploymentStatus, DetailedStatus, DownloadMode, ExpectedInstallDate, FeatureDeferralDays, FeaturePauseDays, FeaturePauseState, LastScan, NeedAttentionStatus,NeedAttentionStatusLevel, OriginBuild, OSArchitecture, OSBuild, OSCurrentStatus, OSEdition, OSFamily, OSFeatureUpdateStatus, OSName, OSQualityUpdateStatus, OSRevisionNumber, OSSecurityUpdateStatus, OSServicingBranch, OSVersion, PauseState, QualityDeferralDays, QualityPauseDays, QualityPauseState, RecommendedAction, ReleaseName, SourceSystem, TargetBuild, TargetOSRevision, TargetOSVersion, TimeGenerated, Type, UpdateCategory, UpdateClassification, UpdateReleasedDate
