{"columns":[{"name":"Hostname","type":"string"},{"name":"agent_ids","type":"list<element: string>"},{"name":"os_family","type":"string"},{"name":"first_seen","type":"timestamp[us, tz=UTC]"},{"name":"last_seen","type":"timestamp[us, tz=UTC]"},{"name":"os","type":"string"},{"name":"num_os","type":"int64"},{"name":"os_version","type":"string"},{"name":"num_os_version","type":"int64"},{"name":"arch","type":"string"},{"name":"num_arch","type":"int64"},{"name":"processor_count","type":"int32"},{"name":"num_processor_count","type":"int64"},{"name":"processor_speed","type":"int64"},{"name":"num_processor_speed","type":"int64"},{"name":"has_battery","type":"bool"},{"name":"num_has_battery","type":"int64"},{"name":"ad_domain","type":"string"},{"name":"num_ad_domain","type":"int64"},{"name":"domain_role","type":"string"},{"name":"num_domain_role","type":"int64"},{"name":"last_boot","type":"int64"},{"name":"num_last_boot","type":"int64"},{"name":"wintap_version","type":"string"},{"name":"num_wintap_version","type":"int64"},{"name":"etl_version","type":"string"},{"name":"num_etl_version","type":"int64"},{"name":"num_rows","type":"int64"}],"n_rows":23,"rows_kept":23,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"DuckDB version v1.1.3 (build 19864453f7)","schema":{"fields":[{"name":"Hostname","type":"string","nullable":true,"metadata":null,"children":null},{"name":"agent_ids","type":"list<element: string>","nullable":true,"metadata":null,"children":[{"name":"element","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"os_family","type":"string","nullable":true,"metadata":null,"children":null},{"name":"first_seen","type":"timestamp[us, tz=UTC]","nullable":true,"metadata":null,"children":null},{"name":"last_seen","type":"timestamp[us, tz=UTC]","nullable":true,"metadata":null,"children":null},{"name":"os","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_os","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"os_version","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_os_version","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"arch","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_arch","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"processor_count","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"num_processor_count","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"processor_speed","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"num_processor_speed","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"has_battery","type":"bool","nullable":true,"metadata":null,"children":null},{"name":"num_has_battery","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"ad_domain","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_ad_domain","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"domain_role","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_domain_role","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"last_boot","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"num_last_boot","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"wintap_version","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_wintap_version","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"etl_version","type":"string","nullable":true,"metadata":null,"children":null},{"name":"num_etl_version","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"num_rows","type":"int64","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 duckdb_schema {\n  optional binary field_id=-1 Hostname (String);\n  optional group field_id=-1 agent_ids (List) {\n    repeated group field_id=-1 list {\n      optional binary field_id=-1 element (String);\n    }\n  }\n  optional binary field_id=-1 os_family (String);\n  optional int64 field_id=-1 first_seen (Timestamp(isAdjustedToUTC=true, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional int64 field_id=-1 last_seen (Timestamp(isAdjustedToUTC=true, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 os (String);\n  optional int64 field_id=-1 num_os (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 os_version (String);\n  optional int64 field_id=-1 num_os_version (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 arch (String);\n  optional int64 field_id=-1 num_arch (Int(bitWidth=64, isSigned=true));\n  optional int32 field_id=-1 processor_count (Int(bitWidth=32, isSigned=true));\n  optional int64 field_id=-1 num_processor_count (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 processor_speed (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 num_processor_speed (Int(bitWidth=64, isSigned=true));\n  optional boolean field_id=-1 has_battery;\n  optional int64 field_id=-1 num_has_battery (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 ad_domain (String);\n  optional int64 field_id=-1 num_ad_domain (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 domain_role (String);\n  optional int64 field_id=-1 num_domain_role (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 last_boot (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 num_last_boot (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 wintap_version (String);\n  optional int64 field_id=-1 num_wintap_version (Int(bitWidth=64, isSigned=true));\n  optional binary field_id=-1 etl_version (String);\n  optional int64 field_id=-1 num_etl_version (Int(bitWidth=64, isSigned=true));\n  optional int64 field_id=-1 num_rows (Int(bitWidth=64, isSigned=true));\n}\n"},"kv_metadata":[]}
["ACME-HH-WHS",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T16:56:10.000000Z","2024-08-19T19:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724086546,1,"6.1.0.0",1,"2.0.1.0",1,3]
["ACME-HH-OUL",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T19:30:00.000000Z","2024-08-19T19:30:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724095777,1,"6.1.0.0",1,"2.0.1.0",1,1]
["ACME-HH-TSD",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:26:08.000000Z","2024-09-16T17:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383044,2,"6.1.0.2",2,"2.0.1.0",1,489]
["ACME-HH-ZAX",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:27:49.000000Z","2024-09-04T21:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725463418,3,"6.1.0.2",2,"2.0.1.0",1,202]
["WIN-DAUVDKQOO9L",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:07:18.000000Z","2024-08-27T02:07:18.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"WORKGROUP",1,"Standalone Server",1,1724724401,1,"6.1.0.0",1,"2.0.1.0",1,1]
["ACME-DC1",["fe437745-98c3-4d17-8e19-b8ba145caced",null],"windows","2024-08-19T12:00:09.000000Z","2024-09-22T23:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,2,1,2300000000,1,false,1,"acme.com",1,"Primary Domain Controller",1,1725404004,4,"6.1.0.3",4,"2.0.1.0",2,588]
["ACME-HH-EUO",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:27:47.000000Z","2024-09-16T17:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383044,2,"6.1.0.2",2,"2.0.1.0",1,471]
["ACME-WS-PLU",["f9ac46c8-0959-4bce-82d9-556a971e7f1a",null],"windows","2024-08-19T00:00:00.000000Z","2024-09-22T23:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383053,2,"6.1.0.2",3,"2.0.1.0",2,535]
["ACME-HH-BKQ",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T19:31:32.000000Z","2024-08-19T19:56:27.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724097367,2,"6.1.0.0",1,"2.0.1.0",1,2]
["ACME-HH-EVP",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T20:17:12.000000Z","2024-08-19T22:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724098607,1,"6.1.0.0",1,"2.0.1.0",1,3]
["ACME-HH-YVU",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T16:55:36.000000Z","2024-08-19T19:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724086513,1,"6.1.0.0",1,"2.0.1.0",1,2]
["ACME-HH-WPU",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T23:19:53.000000Z","2024-09-16T16:48:17.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383042,3,"6.1.0.2",2,"2.0.1.0",1,632]
["ACME-HH-DXJ",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:14:33.000000Z","2024-09-22T23:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383043,2,"6.1.0.2",2,"2.0.1.0",1,627]
["ACME-HH-CHT",["1a71328c-a00b-4e3f-a386-1f99f695c1aa"],"windows","2024-08-19T00:00:00.000000Z","2024-08-19T15:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1723741139,1,"6.1.0.0",1,"2.0.0.1",1,16]
["ACME-HH-HUJ",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T21:00:01.000000Z","2024-08-19T23:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1724098567,1,"6.1.0.0",1,"2.0.1.0",1,3]
["WIN-I5PGK7TI0R7",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:07:17.000000Z","2024-08-27T02:07:17.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"WORKGROUP",1,"Standalone Server",1,1724724401,1,"6.1.0.0",1,"2.0.1.0",1,1]
["WIN-9A517LL9MQ4",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T20:09:57.000000Z","2024-08-19T20:09:57.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"WORKGROUP",1,"Standalone Server",1,1724098156,1,"6.1.0.0",1,"2.0.1.0",1,1]
["ACME-HH-ZYQ",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:15:08.000000Z","2024-09-16T17:41:01.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383044,2,"6.1.0.2",2,"2.0.1.0",1,475]
["ACME-HH-CWQ",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:26:16.000000Z","2024-09-22T23:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383046,5,"6.1.0.2",2,"2.0.1.0",1,625]
["ACME-HH-UIR",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-19T23:32:08.000000Z","2024-09-17T15:58:06.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1726588668,3,"6.1.0.2",2,"2.0.1.0",1,480]
["ACME-HH-ESO",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:26:18.000000Z","2024-09-16T17:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",1,"Member Server",1,1725383042,2,"6.1.0.2",2,"2.0.1.0",1,472]
["EC2AMAZ-R9HHULK",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:14:57.000000Z","2024-09-22T21:00:00.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"acme.com",2,"Member Server",2,1725639598,7,"6.1.0.0",1,"2.0.1.0",1,641]
["WIN-UAV472MUK1J",["baa6d56b-daab-414f-bfd5-4ffafb247689"],"windows","2024-08-27T02:07:17.000000Z","2024-08-27T02:07:17.000000Z","Windows Server 2022 Datacenter",1,"Microsoft Windows NT 6.2.9200.0",1,"64-bit",1,8,1,2200000000,1,false,1,"WORKGROUP",1,"Standalone Server",1,1724724401,1,"6.1.0.0",1,"2.0.1.0",1,1]