Comments on: Find Antimalware Software Status using CMPivot Query in SCCM https://www.prajwaldesai.com/find-antimalware-software-status-using-cmpivot-query/ SCCM | ConfigMgr | Intune | Windows 11 | Azure Tue, 07 Mar 2023 13:10:37 +0000 hourly 1 https://wordpress.org/?v=6.4.1 By: RemyF https://www.prajwaldesai.com/find-antimalware-software-status-using-cmpivot-query/#comment-43126 https://www.prajwaldesai.com/?p=314452#comment-43126 In reply to Prajwal Desai.

It is available, I did some more digging and trying and found out that you can query this information:

select SMS_G_System_AntimalwareHealthStatus.Version, SMS_R_System.Name from SMS_R_System inner join SMS_G_System_AntimalwareHealthStatus on SMS_G_System_AntimalwareHealthStatus.ResourceID = SMS_R_System.ResourceId where SMS_G_System_AntimalwareHealthStatus.Version > “0” order by SMS_G_System_AntimalwareHealthStatus.Version

I set the version to greater then “0” here to see all but you can specify a version.
Also later I found out the AMversion is also visible in device view (or in a collection view of devices better said) by adding a column “Antimalware Client Version”.

]]> By: Prajwal Desai https://www.prajwaldesai.com/find-antimalware-software-status-using-cmpivot-query/#comment-43092 https://www.prajwaldesai.com/?p=314452#comment-43092 In reply to RemyF.

I don’t think that information is available with SCCM hence you cannot query.

]]> By: RemyF https://www.prajwaldesai.com/find-antimalware-software-status-using-cmpivot-query/#comment-43078 https://www.prajwaldesai.com/?p=314452#comment-43078 Hi Prajwal. Good learn about the CMPivot function. What I miss there though is AMProductVerion and AMEngineVersion. So far I can’t find that information in SCCM besides the Definition versions. One would like to know also the current version of Defender thus AMProductVersion itself. Now I know you could do that with powershell but still ain’t that information really available in SCCM itself?

]]>