Query.txt

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Rules must be processd in this order
Version 18.05.08
 
Tablet
select * from Win32_ComputerSystem where Model like "Latitude 10%"
select * from Win32_ComputerSystem where Model like "Venue%"
         
Latitude5
select * from Win32_ComputerSystem where Model like "Latitude 5%"
select * from Win32_ComputerSystem where Model like "Latitude E5%"
select * from Win32_ComputerSystem where Model like "Precision 3%"
 
Latitude6
select * from Win32_ComputerSystem where Model like "Latitude 6%"
select * from Win32_ComputerSystem where Model like "Latitude E6%"
 
Latitude7
select * from Win32_ComputerSystem where Model like "Latitude 7%"
select * from Win32_ComputerSystem where Model like "Latitude E7%"
select * from Win32_ComputerSystem where Model like "XPS 9250"
 
Latitude
select * from Win32_ComputerSystem where Model like "Latitude%"
 
PrecisionM
select * from Win32_ComputerSystem where Model like "Precision M%"
 
PrecisionR
select * from Win32_ComputerSystem where Model like "Precision R%"
select * from Win32_ComputerSystem where Model like "%Rack%"
 
PrecisionT
select * from Win32_ComputerSystem where Model like "Precision T%"
 
Precision
select * from Win32_ComputerSystem where Model like "Precision%"
 
OptiPlexAIO
select * from Win32_ComputerSystem where Model like "%AIO%"
 
OptiPlex
select * from Win32_ComputerSystem where Model like "OptiPlex%"
 
XPS
select * from Win32_ComputerSystem where Model like "XPS%"
 
Cloud
select * from Win32_ComputerSystem where Model like "Wyse%"