-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathby-inservice-env.js
More file actions
59 lines (56 loc) · 1.32 KB
/
by-inservice-env.js
File metadata and controls
59 lines (56 loc) · 1.32 KB
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
50
51
52
53
54
55
56
57
58
59
// mongodb file
use dcit
db.systemdbs.aggregate([
{$match:
{$or: [
{'systemStatus': 'Production App'},
{'systemStatus': 'Production DB'},
]},
},
{$lookup:
{ from: 'equipment',
localField: 'systemEquipSN',
foreignField: 'equipSN',
as: 'equip',
},
},
{$match:
{ $or: [
{'equip.equipStatus': 'In Service'},
{'equip.equipStatus': 'In Service with issues'},
]},
},
/*{$group:
{
_id: {
E: '$systemEnviron',
S: '$systemStatus',
},
'count': {$sum: 1},
},
}, */
{$group:
{
_id: '$systemEnviron',
countApp: {$sum: { $cond: [{$eq: [ '$systemStatus', 'Production App' ]}, 1, 0]}},
countDb: {$sum: { $cond: [{$eq: [ '$systemStatus', 'Production DB' ]}, 1, 0]}},
dcAbbr: equip.dcAbbr,
},
},
{ $sort:
{
'countApp': -1,
'countDb': -1,
},
},
{ $project:
{
'_id': 0,
'env': '$_id',
'countApp': '$countApp',
'countDb': '$countDb',
'dcAbbr': '$dcAbbr',
},
},
]);
it