HQ issues
Filter : "1279110101474" "'action_type': 'scan'" "'ss': 'In Transit'" "'nsl': 'X-PROM'"
Template RBL:
{ "adapters": [ { "adapter_alive": true, "adapter_config": {
},
"adapter_dyn_conf": [
{
"key": "number",
"path": "$.ph"
}
],
"adapter_type": "SMS",
"templates": [
{
"check": {
"expr1": {
"expr1": {
"expr1": {
"path": "$.cs.nsl"
},
"expr2": {
"val": [
"X-PPOM",
"X-PPONM",
"X-PROM"
]
},
"op": "MATCH"
},
"expr2": {
"expr1": {
"path": "$.cs.st"
},
"expr2": {
"val": "UD"
},
"op": "MATCH"
},
"op": "AND"
},
"expr2": {
"expr1": {
"path": "$.cs.ss"
},
"expr2": {
"val": "In Transit"
},
"op": "MATCH"
},
"op": "AND"
},
"template_alive": true,
"template_paths": [
{
"key": "$.prd",
"size_limit": "20"
},
{
"date_format": "%d-%m-%Y",
"key": "$.action_date",
"type": "epoch",
"TZ": "IST"
},
{
"key": "$.wbn"
},
{
"key": "$.wbn"
}
],
"template_text": "Your %s has been dispatched on %s via Delhivery, AWB No. %s. You can track on https://t.dlhvr.in/p/%s",
"template_type": "FM Incoming",
"version": "V1"
},
{
"check": {
"expr1": {
"expr1": {
"expr1": {
"path": "$.cs.nsl"
},
"expr2": {
"val": [
"EOD-36",
"EOD-37",
"EOD-38",
"ED-100"
]
},
"op": "MATCH"
},
"expr2": {
"expr1": {
"path": "$.cs.st"
},
"expr2": {
"val": "DL"
},
"op": "MATCH"
},
"op": "AND"
},
"expr2": {
"expr1": {
"path": "$.cs.ss"
},
"expr2": {
"val": "Delivered"
},
"op": "MATCH"
},
"op": "AND"
},
"template_alive": true,
"template_paths": [
{
"key": "$.prd",
"size_limit": "20"
},
{
"key": "$.cs.rec_nm"
},
{
"key": "$.wbn"
}
],
"template_text": "Your %s has been delivered to %s via Delhivery AWB No. %s.Know how to get started, click http://bit.ly/2uy2T0N",
"template_type": "Delivered",
"version": "V1"
},
{
"check": {
"expr1": {
"expr1": {
"expr1": {
"path": "$.cs.nsl"
},
"expr2": {
"val": [
"EOD-36",
"EOD-37",
"EOD-38",
"ED-100"
]
},
"op": "MATCH"
},
"expr2": {
"expr1": {
"path": "$.cs.st"
},
"expr2": {
"val": "DL"
},
"op": "MATCH"
},
"op": "AND"
},
"expr2": {
"expr1": {
"path": "$.cs.ss"
},
"expr2": {
"val": "Delivered"
},
"op": "MATCH"
},
"op": "AND"
},
"template_alive": true,
"template_paths": [
{
"key": "$.prd",
"size_limit": "20"
},
{
"key": "$.nm"
},
{
"key": "$.wbn"
}
],
"template_text": "Your %s has been delivered to %s via Delhivery AWB No. %s.Know how to get started, click http://bit.ly/2uy2T0N",
"template_type": "Delivered",
"version": "V1"
}
]
}
], "client_name": "RBLBANK EXPRESS" }
use admin db.createCollection("mms.backup") db.createCollection("system.indexes") db.createCollection("system.users") db.createCollection("system.version") db.mms.backup.insert({ "_id" : "oplog_update", "heartbeat" : { "last_ts" : ISODate("2014-11-06T16:59:06.863Z") } }) db.system.users.insert({ "_id" : "delhivery_db.delhivery_app", "user" : "delhivery_app", "db" : "delhivery_db", "credentials" : { "SCRAM-SHA-1" : { "iterationCount" : 10000, "salt" : "2EkZl1K6A9CcKsRaZM5PGQ", "storedKey" : "/z1iRuD7P6ho7PjgLzESwqQRKZ4=", "serverKey" : "B2oMrr3Qzv34swmquO1kepAQSq4=" } }, "roles" : [ { "role" : "application", "db" : "delhivery_db" } ] }) db.system.users.insert({ "_id" : "admin.delhivery_app", "user" : "delhivery_app", "db" : "admin", "credentials" : { "SCRAM-SHA-1" : { "iterationCount" : 10000, "salt" : "xIcx5XXM769tPnxvP5z/yg", "storedKey" : "BlpEjQYz2raag+utdoq34ZatxF4=", "serverKey" : "Ph5GN2k2Kc6pFgkzWidVc333g+8=" } }, "roles" : [ { "role" : "readWrite", "db" : "delhivery_db" } ] }) db.system.indexes.insert({ "v" : 1, "key" : { "_id" : 1 }, "name" : "id", "ns" : "admin.mms.backup" }) db.system.indexes.insert({ "v" : 1, "key" : { "_id" : 1 }, "name" : "id", "ns" : "admin.system.users" }) db.system.indexes.insert({ "v" : 1, "unique" : true, "key" : { "user" : 1, "db" : 1 }, "name" : "user_1_db_1", "ns" : "admin.system.users" }) db.system.indexes.insert({ "v" : 1, "key" : { "id" : 1 }, "name" : "id", "ns" : "admin.system.version" }) use delhivery_db db.system.indexes.insert({"v" : 1,"key" : {"id" : 1},"name" : "id","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"chn.dt" : 1},"name" : "chn.dt_1","ns" : "delhivery_db.packages","sparse" : true}) db.system.indexes.insert({"v" : 1,"key" : {"cl" : 1,"cs.sd" : 1},"name" : "cl_1_cs.sd_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cn" : 1},"name" : "cn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cs.bs" : 1},"name" : "cs.bs_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cs.dwbn" : 1},"name" : "cs.dwbn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cs.sd" : -1,"cs.ss" : 1},"name" : "cs.sd-1_cs.ss_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cs.sl" : 1,"cs.ss" : 1,"cs.sd" : 1},"name" : "cs.sl_1_cs.ss_1_cs.sd_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cs.ss" : 1},"name" : "cs.ss_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"inv.num" : 1},"name" : "inv.num_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"inv.rnum" : 1},"name" : "inv.rnum_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"ldd" : -1},"name" : "ldd-1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"oid" : 1},"name" : "oid_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"pd" : 1,"cl" : 1,"pt" : 1},"name" : "pd_1_cl_1_pt_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"rcn" : 1},"name" : "rcn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"sbt.ack" : 1},"name" : "sbt.ack_1","ns" : "delhivery_db.packages","sparse" : true}) db.system.indexes.insert({"v" : 1,"unique" : true,"key" : {"wbn" : 1},"name" : "wbn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"zn" : 1},"name" : "zn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"mwn" : 1},"name" : "mwn_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"cnid" : 1},"name" : "cnid_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"rcnid" : 1},"name" : "rcnid_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"pupid" : 1},"name" : "pupid_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"flags.is_vol" : 1},"name" : "flags.is_vol_1","ns" : "delhivery_db.packages"}) db.system.indexes.insert({"v" : 1,"key" : {"pid" : 1},"name" : "pid_1","ns" : "delhivery_db.packages"})
5xx alarms: SELECT elb_status_code, count(elb_status_code) FROM alb_2019_sep_30 WHERE time >= '2019-09-30T06:00:00.844003Z' and time <= '2019-09-30T06:36:00.844003Z' and elb_status_code in ('502', '500', '501', '504', '503') group by elb_status_code
./jmeter -n -t /home/ubuntu/SMS_AIRTEL_old.jmx -l testresults.jtl
./JMeterPluginsCMD.sh --tool Reporter --generate-csv test.csv --input-jtl /home/ubuntu/apache-jmeter-5.1.1/bin/testresults.jtl --plugin-type AggregateReport
Ran a script on manage shell.