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(3.2, 63%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Hello Team,
Please share the SCCM SQL query to check Windows Defender update status and it is version for all the devices
I can see below in the resource explorer for a computer. does this help to check the defender update version
Are the devices not onboarded on Defender portal? It will be so much easier just to pull the data from the default Defender AV reports.
![](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(220.8, 19%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
All of the views are listed within the scheme docs. https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/endpoint-protection-views-configuration-manager
Hi, @Boopathi S
Like Francis mentioned, CMPivot is a easy way to get the status and version.
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".
Just checking if there's any progress or updates?
It is working. thanks.
I do not have that information, but perhaps this will assist you in finding the information:
Use CMPivot in SCCM. Select the appropriate device collection and run the EPStatus command in CMPivot. It will live-query and provide you with all the Defender-related data from the collection of devices that are currently online and reachable. Please note that CMPivot is a live query tool, so do not initiate it on large collections as it may flood the network.