Built off the open source project Osquery
Description: Status of Windows Defender firewall.
What The Data Shows: This query can assist in compliance audits.
SQL:
SELECT display_name,status,start_type
FROM services
WHERE LOWER(name) = "mpssvc";
Copyright © 2005-2023 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.