Mystery Incorporated
07/30/2021, 8:09 AMseph
SELECT type,state FROM windows_security_products
That should produce two rows, each with two columns.Mystery Incorporated
07/31/2021, 12:48 AM{"snapshot":[{"state":"On","type":"Firewall"},{"state":"Off","type":"Firewall"},{"state":"On","type":"Antivirus"},{"state":"Off","type":"Antivirus"}],"action":"snapshot","name":"pack/Windows Base Pack/fw_av_snapshot","hostIdentifier":"xxx","calendarTime":"Fri Jul 30 06:19:03 2021 UTC","unixTime":1627625943,"epoch":0,"counter":0,"numerics":false,"decorations":{"company":"xxx","host_hostname":"xxx","username":"xxx"}}
seph
Mystery Incorporated
07/31/2021, 12:50 AMSELECT type,state FROM windows_security_products
set as a snapshot query and told to run every 112 seconds{"snapshot":[{"state":"On","type":"Firewall"},{"state":"On","type":"Antivirus"}],"action":"snapshot","name":"pack/Windows Base Pack/fw_av_snapshot","hostIdentifier":"xxx","calendarTime":"Sat Jul 31 00:43:39 2021 UTC","unixTime":1627692219,"epoch":0,"counter":0,"numerics":false,"decorations":{"company":"xxx","host_hostname":"xxxx"}}
seph
select *
do the other columns hint at anything?Mystery Incorporated
07/31/2021, 1:20 AMseph
select *
?Mystery Incorporated
08/01/2021, 1:05 PMseph
Mystery Incorporated
08/01/2021, 1:06 PM