Find Antimalware Software Status using CMPivot Query in SCCM

 In this article, I will show you how to find antimalware software status using CMPivot query in SCCM (ConfigMgr). Using CMPivot, you can get the status of antimalware software installed on the computer(s), which is usually gathered by the Get-MpComputerStatus cmdlet.


CMPivot is a new in-console utility in SCCM that now provides access to the real-time state of devices in your environment. Pivot's KQL-based queries make it easier for administrators to find important data from the clients. All these CMPivot queries can be safely run on the ConfigMgr production server, and you can also export the results or output to a file.

http://biowong.freehostia.com/phpbb2/viewtopic.php?t=627249

http://biowong.freehostia.com/phpbb2/viewtopic.php?p=1260050

http://biowong.freehostia.com/phpbb2/viewtopic.php?p=1216242

https://forofoil.com/viewtopic.php?t=2038

https://forofoil.com/viewtopic.php?t=6527

https://forofoil.com/viewtopic.php?t=2345

https://forofoil.com/viewtopic.php?t=2296

https://forofoil.com/viewtopic.php?t=5083

https://www.conservationconversation.co.uk/post/a-turtelly-awesome-phd-stuart-negus

https://gtjaifans.net/fluxbb/viewtopic.php?id=100016

https://gtjaifans.net/fluxbb/viewtopic.php?id=66453

https://www.smartfun.fr/forum/yuri-girl-f90/xogjjq-put-yxwycg-t18884.html

https://www.smartfun.fr/forum/yuri-girl-f90/kbwakq-put-figifx-t60976.html

https://www.smartfun.fr/forum/yuri-girl-f90/xatjae-attitude-cgbwls-t18885.html

https://www.smartfun.fr/forum/yuri-girl-f90/gqxejv-plat-pkfhkh-t18997.html

http://bolshakovo.ru/index.php?topic=23565.0

http://bolshakovo.ru/index.php?topic=13659.0

https://australiantravelforum.com/travel/showthread.php?tid=75344

https://shishoninfood.ru/forum/viewtopic.php?t=52044

https://shishoninfood.ru/forum/viewtopic.php?t=214315

With CMPivot, you can run some basic queries to check the antimalware status on a single computer or on an entire SCCM device collection. If you aren’t using Configuration Manager in your setup, you can find the status of antimalware software by running the Get-MpComputerStatus command.


I have been exploring the CMPivot queries from sometime and I find it very intriguing. The amount of information that you can gather from remote machines is simply outstanding. If you are interested in exploring CMPivot, you can check out all my posts on ConfigMgr CMPivot queries.


Take a look at some interesting CMPivot queries that you can use in SCCM:


  • Find Serial Number of Computer using CMPivot
  • Find Recently Used Applications using SCCM CMPivot Query
  • Use CMPivot Query to Find WSUS Server Details in SCCM
  • Easily Find Dot Net Version using SCCM CMPivot Query
  • Find Default Browser using SCCM CMPivot Query
  • Run Get-MpComputerStatus command to find Antimalware Status

The Get-MpComputerStatus is a simple command with which you can check the status of antimalware software on the computer. If you don’t have access to CMPivot, finding the antimalware status can be achieved by running a simple command on the computer.


This command needs to be run locally in the PowerShell window and works on almost all the Windows operating systems with defender running. To get the status of the antimalware software, open the PowerShell and run the below command.

https://shishoninfood.ru/forum/viewtopic.php?t=445460

https://forum.fulltimewin.com/viewtopic.php?t=369520

https://forum.fulltimewin.com/viewtopic.php?t=366398

https://forum.fulltimewin.com/viewtopic.php?t=48809

http://support-groups.org/viewtopic.php?t=20307

https://ordemdospsicologos.org/forum/showthread.php?tid=1655

http://communitylaminasstarterkit.omelak.com/showthread.php?tid=250&pid=2094#pid2094

https://myanimelist.net/profile/shinu90

https://cloudsolutions7.livejournal.com/profile

https://www.reddit.com/user/Complete_Carob_7967

https://www.tripadvisor.in/Profile/shinu452

https://www.gta5-mods.com/users/ComputerCargo

https://www.prestashop.com/forums/profile/1791062-computercapers/

https://coub.com/cricut.comsetup

http://moi.nabchelny.ru/user/89453

The output of the Get-MpComputerStatus command is pasted below. We see that output includes all the details about the antimalware software properties such as engine version, antivirus component status, RealTimeProtectionEnabled etc.


Find Antimalware Software Status using CMPivot in SCCM

Let’s look at the steps to find antimalware software status using CMPivot query in SCCM. Launch the SCCM console and go to Assets and Compliance > Overview > Device Collections. Choose the device collection against which you want to run the CMPivot query. Right-click the device collection and select Start CMPivot.


In the CMPivot tool, select the Query tab. Enter the query “Estates” and click on Run Query. The CMPivot query output includes a list all the details about the antimalware software including the status and signature updates. The output will include several details, and you might have to export the list to a CSV file and review the results.


Comments

Popular posts from this blog

The 10 Best Apartment Websites of 2019

The most effective method to Add an Alarm on the Apple Watch

How to Upgrade Windows 11 Home to Pro Edition