William Guilherme
10/05/2020, 9:12 PM*SELECT* firewall, autoupdate, antivirus, antispyware, internet_settings, windows_security_center_service, user_account_control *FROM* windows_security_center *WHERE* firewall *LIKE 'Good' AND* autoupdate *LIKE 'Good' AND* antivirus *LIKE 'Good' AND* antispyware *LIKE 'Good' AND* internet_settings *LIKE 'Good' AND* windows_security_center_service *LIKE 'Good' AND* user_account_control *LIKE 'Good';*
zwass
10/05/2020, 9:22 PMGood
state. Is that intentional? I would think you probably want just SELECT firewall, autoupdate, antivirus, antispyware, internet_settings, windows_security_center_service, user_account_control FROM windows_security_center
.sundsta
10/05/2020, 9:30 PMSELECT * from windows_security_center
William Guilherme
10/05/2020, 9:30 PMzwass
10/05/2020, 9:39 PMSELECT 'Good' AS windows_security_center_status FROM windows_security_center WHERE firewall = 'Good' AND autoupdate = 'Good' AND antivirus = 'Good' AND antispyware = 'Good' AND internet_settings = 'Good' AND windows_security_center_service = 'Good' AND user_account_control = 'Good';
William Guilherme
10/05/2020, 11:16 PM