none
OR Query RRS feed

  • Frage

  • Hallo

    und täglich grüßt das Murmeltier. ich stele jeden Tag aufs neue fest wie beschrnkt SCCM arbeitet. JEden Tag macht es mir das leben ein bisschen schwerer.

    Heute habe ich festgestellt das es zu dumm ist eine simple OR Query zu regeln.

    select SMS_R_System.Name, SMS_R_System.FullDomainName, SMS_G_System_BATTERY.DeviceID, SMS_R_System.LastLogonUserName, SMS_G_System_COMPUTER_SYSTEM.Model from  SMS_R_System inner join SMS_G_System_BATTERY on SMS_G_System_BATTERY.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_BATTERY.DeviceID like "%G71C000AW210%" or SMS_G_System_BATTERY.DeviceID like "%G71C000D4110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000D7110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000DD110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000FQ110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000FS110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000FS210%" or SMS_G_System_BATTERY.DeviceID like "%G71C000G3110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000GN110%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BD510%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE310%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE410%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE510%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE710%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE810%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BE910%" or SMS_G_System_BATTERY.DeviceID like "%G71C000CE210%" or SMS_G_System_BATTERY.DeviceID like "%G71C000BED10%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%R700%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%830%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%X70-B%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C50-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C55D-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C70-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C70-B%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C70D-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C70D-B%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C850%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C870%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C875%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%C875D%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%L70-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%A50-A%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%L830%" or SMS_G_System_COMPUTER_SYSTEM.Model like "%R840%"

    Hat jemand eine Idee warum einträge OHNE Battery Wert komplett rausfallen OBWOHL Sie dem Model entsprechen?

    Danke schonmal. Bin absolut frustriert.

    Grüße


    ooGDoo

    Mittwoch, 3. Februar 2016 12:22

Antworten

Alle Antworten