Here's a quick example for how to query advertisements from a remote (or local) system. Just replace "myComputerName" with the computer name to query. Provided you have proper rights to that system, advertisement information will be exported to "ClientAdverts.csv"
gwmi ccm_softwaredistribution -namespace `
root\ccm\policy\machine\actualconfig -computer `
myComputerName | export-csv `
ClientAdverts.csv -notypeinformation
You can then import the .csv into Excel. The information in this .csv could prove to be very valuable when troubleshooting client issues. Here are a few of my favorite properties: ADV_MandatoryAssignments, ADV_ExpirationTime, ADV_RCF_InstallFromLocalDPOptions, ADV_RCF_InstallFromRemoteDPOptions, PRG_PRF_AfterRunning, and many others. Refer to the ConfigMgr SDK for more information about the CCM_SoftwareDistribution Client WMI Class.
Greg