This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 96%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Hello there.
In our organisation, we've moved from an old Configuration Manager server (A) to a new one (B).
Some computers are still pointing to A so their Windows Update status is unknown.
What's the query for the collection which identifies all such computers?
Thanks in advance.
Best regards.
Luis.
You can try pulling the information using CMpivot by querying the wsus registry as well.
Hi, @Luis Larrubia
Thank you for posting in Microsoft Q&A forum.
Like Rahul Jindal mentioned, it's easy to use CMpivot by querying the WSUS registry, check the values in the results to see if it points to the correct WSUS server.
Registry('HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate') | where Property == 'WUServer'
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".
You might be able to, Or at least see the ones without the right details. The lastscanpackagelocation should do the trick.
Select * from [dbo].[v_UpdateScanStatus]
Hi Garth. Thanks a lot!!
Thank you all for your answers. I didn't know about CMPivot capabilities, very useful. Luis.
Keep in mind that it will only show you for those devices that are online and it used network bandwidths.
Pretty clear @Garth Jones The advantage is that I can create collections or execute scripts directly from CMPivot results. The disadvantage is that, as you've said, only online devices will be shown in that results. Thanks a lot.