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
