Zenbleed LQL

zenbleed.yaml

{
       source {
           LW_HE_MACHINES
       }
       filter {
           contains(CPU_INFO, 'vendor_id')
           and contains(CPU_INFO, 'AuthenticAMD')
           and contains(CPU_INFO, 'model name')
           and NOT contains(TAGS, 'GCP')
           and NOT contains(TAGS, 'AWS')
           and ( contains(CPU_INFO, 'EPYC 7232P')
           or contains(CPU_INFO, 'EPYC 7252')
           or contains(CPU_INFO, 'EPYC 7262')
           or contains(CPU_INFO, 'EPYC 7272')
           or contains(CPU_INFO, 'EPYC 7282')
           or contains(CPU_INFO, 'EPYC 7302')
           or contains(CPU_INFO, 'EPYC 7302P')
           or contains(CPU_INFO, 'EPYC 7352')
           or contains(CPU_INFO, 'EPYC 7402')
           or contains(CPU_INFO, 'EPYC 7402P')
           or contains(CPU_INFO, 'EPYC 7452')
           or contains(CPU_INFO, 'EPYC 7502')
           or contains(CPU_INFO, 'EPYC 7502P')
           or contains(CPU_INFO, 'EPYC 7532')
           or contains(CPU_INFO, 'EPYC 7542')
           or contains(CPU_INFO, 'EPYC 7552')
           or contains(CPU_INFO, 'EPYC 7642')
           or contains(CPU_INFO, 'EPYC 7662')
           or contains(CPU_INFO, 'EPYC 7702')
           or contains(CPU_INFO, 'EPYC 7702P')
           or contains(CPU_INFO, 'EPYC 7742')
           or contains(CPU_INFO, 'EPYC 7F32')
           or contains(CPU_INFO, 'EPYC 7F52')
           or contains(CPU_INFO, 'EPYC 7F72')
           or contains(CPU_INFO, 'EPYC 7H12')
           or contains(CPU_INFO, 'EPYC 7R32')
           or contains(CPU_INFO, 'Ryzen 3 3100')
           or contains(CPU_INFO, 'Ryzen 3 3200G')
           or contains(CPU_INFO, 'Ryzen 3 3200GE')
           or contains(CPU_INFO, 'Ryzen 3 3300X')
           or contains(CPU_INFO, 'Ryzen 3 4100')
           or contains(CPU_INFO, 'Ryzen 3 4300G')
           or contains(CPU_INFO, 'Ryzen 3 4300GE')
           or contains(CPU_INFO, 'Ryzen 3 4300U')
           or contains(CPU_INFO, 'Ryzen 3 4500U')
           or contains(CPU_INFO, 'Ryzen 3 4600U')
           or contains(CPU_INFO, 'Ryzen 3 4800U')
           or contains(CPU_INFO, 'Ryzen 3 4900U')
           or contains(CPU_INFO, 'Ryzen 3 5300U')
           or contains(CPU_INFO, 'Ryzen 3 7320U')
           or contains(CPU_INFO, 'Ryzen 4700S')
           or contains(CPU_INFO, 'Ryzen 5 3400G')
           or contains(CPU_INFO, 'Ryzen 5 3400GE')
           or contains(CPU_INFO, 'Ryzen 5 3500')
           or contains(CPU_INFO, 'Ryzen 5 3500X')
           or contains(CPU_INFO, 'Ryzen 5 3600')
           or contains(CPU_INFO, 'Ryzen 5 3600X')
           or contains(CPU_INFO, 'Ryzen 5 3600XT')
           or contains(CPU_INFO, 'Ryzen 5 4500')
           or contains(CPU_INFO, 'Ryzen 5 4500U')
           or contains(CPU_INFO, 'Ryzen 5 4600G')
           or contains(CPU_INFO, 'Ryzen 5 4600GE')
           or contains(CPU_INFO, 'Ryzen 5 4600H')
           or contains(CPU_INFO, 'Ryzen 5 4600HS')
           or contains(CPU_INFO, 'Ryzen 5 4600U')
           or contains(CPU_INFO, 'Ryzen 5 4680U')
           or contains(CPU_INFO, 'Ryzen 5 4800H')
           or contains(CPU_INFO, 'Ryzen 5 4800HS')
           or contains(CPU_INFO, 'Ryzen 5 5500U')
           or contains(CPU_INFO, 'Ryzen 5 7520U')
           or contains(CPU_INFO, 'Ryzen 7 3700X')
           or contains(CPU_INFO, 'Ryzen 7 3800X')
           or contains(CPU_INFO, 'Ryzen 7 3800XT')
           or contains(CPU_INFO, 'Ryzen 7 4700G')
           or contains(CPU_INFO, 'Ryzen 7 4700GE')
           or contains(CPU_INFO, 'Ryzen 7 4700U')
           or contains(CPU_INFO, 'Ryzen 7 4800H')
           or contains(CPU_INFO, 'Ryzen 7 4800HS')
           or contains(CPU_INFO, 'Ryzen 7 4800U')
           or contains(CPU_INFO, 'Ryzen 7 4900H')
           or contains(CPU_INFO, 'Ryzen 7 4900HS')
           or contains(CPU_INFO, 'Ryzen 7 4980U')
           or contains(CPU_INFO, 'Ryzen 7 5700U')
           or contains(CPU_INFO, 'Ryzen 9 3900')
           or contains(CPU_INFO, 'Ryzen 9 3900X')
           or contains(CPU_INFO, 'Ryzen 9 3900XT')
           or contains(CPU_INFO, 'Ryzen 9 3950X')
           or contains(CPU_INFO, 'Ryzen 9 4800H')
           or contains(CPU_INFO, 'Ryzen 9 4800HS')
           or contains(CPU_INFO, 'Ryzen 9 4900H')
           or contains(CPU_INFO, 'Ryzen 9 4900HS')
           or contains(CPU_INFO, 'Ryzen Threadripper 3960X')
           or contains(CPU_INFO, 'Ryzen Threadripper 3970X')
           or contains(CPU_INFO, 'Ryzen Threadripper 3980X')
           or contains(CPU_INFO, 'Ryzen Threadripper 3990X')
           or contains(CPU_INFO, 'Ryzen Threadripper Pro 3945WX')
           or contains(CPU_INFO, 'Ryzen Threadripper Pro 3955WX')
           or contains(CPU_INFO, 'Ryzen Threadripper Pro 3975WX')
           or contains(CPU_INFO, 'Ryzen Threadripper Pro 3995WX')
          )
       }
       return distinct {
           BATCH_START_TIME,
           BATCH_END_TIME,
           TAGS,
           CPU_INFO,
           HOSTNAME,
           KERNEL,
           KERNEL_RELEASE,
           KERNEL_VERSION,
           OS,
           MID,
           SOURCE_TYPE
       }
   }