question

LeonTaljaard-1502 avatar image
0 Votes"
LeonTaljaard-1502 asked bharathn-msft commented

Azure Update Compliance - Query Help

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
azure-monitor
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @LeonTaljaard-1502 , Requesting you to please review the answer and let us know if you have any further queries. Thank you

0 Votes 0 ·

1 Answer

bharathn-msft avatar image
0 Votes"
bharathn-msft answered

@LeonTaljaard-1502 Apologies for delayed response on this thread.

Seems you are using the inner join, the inner-join function is like the standard inner-join from the SQL world. An output record is produced whenever a record on the left side has the same join key as the record on the right side.

119508-image.png

Unless you have the matching Computer in the WaaSUpdateStatus table with in the same time frame of the query window, the result might not show all the computers of WaaSDeploymentStatus in the overall output of the query based on the inner join function.

Based on your requirement on what needs to be returned , please review the other join operators which you can use and see if that helps.

Please help validate the above information and if you are still seeing an issue. Please circle back and will try to help you to further troubleshoot. Thank you



image.png (4.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.