阿里云日志下载以及awk处理日志巧计

最新推荐文章于 2023-02-27 09:02:09 发布

little sky

最新推荐文章于 2023-02-27 09:02:09 发布

阅读量627

点赞数 1

文章标签：阿里云日志下载 awk

本文链接：https://blog.csdn.net/zhutianrong520/article/details/98840135

版权

我们可以下载阿里云日志，命令如下：可以先阅读：https://aliyun-log-cli.readthedocs.io/en/latest/README_CN.html?spm=5176.2020520112.0.0.5eb634c0Nim7cV#安装

aliyunlog log get_log_all --project="fs2hf" --logstore="bankliquidation-huifu-callback" --query="step4.0  and 调用PPC收银台取现失败" --from_time="2019-07-31 17:16:02+08:00" --to_time="2019-08-07 17:16:02+08:00" --region-endpoint="cn-shanghai.log.aliyuncs.com" --format-output=no_escape --jmes-filter="join('\n', map(&to_string(@), @))" --access-id="" --access-key=""  >> ./dakuan.txt

下载日志是带""的json，如下所示：

{"__source__":"10.130.18.169","__tag__:__hostname__":"10-130-18-169","__tag__:__pack_id__":"9B03F3F55AFAB1EE-4AF1","__tag__:__path__":"/home/devjava/logs/bankliquidation-huifu-callback/bankliquidation-huifu-callback.log","__tag__:__receive_time__":"1564567335","__time__":"1564567334","__topic__":"","content":"[INFO ][2019-07-31 18:02:14,808][HuifuCallbackController:256] step4.0 hfpayNotify >> 通知渠道方结果，request = {\"amount\":0.22,\"bankCard\":\"6230910100*****\",\"notifyStatus\":2,\"sign\":\"bnMv9BVzJHmC+e7PVuKQX9LcfPbow95y7k5v5b8eh9917u+D5BWWSVtZgS3kanAvgCgWWZxud4XjAV2hzQmOzArmsPW0d7iJNruPW9CMYyFt70ioWrHx5KiYZAfSK1cDPMGWjqxK+SQB09hymB+9qA3vHOkjSm95UunGPW0aVNs=\",\"bankName\":\"杭州银行\",\"updateTime\":\"2019-07-31 18:02:14\",\"storeId\":\"201907291936400****\",\"appId\":\"20160921085633894\",\"billId\":\"JS190731050000570703283764\",\"bankNo\":\"313331000820\",\"payDay\":20190730,\"failReason\":\"调用PPC收银台取现失败:交易失败,回账成功,账号或卡号不存在\",\"isAcct\":0,\"sign_type\":\"RSA\"}, response = 0"}

然后用awk处理，命令如下：

cat ./dakuan.txt  | awk -F '>>' '{print $2}'  | awk '{gsub(/\\/,"");print}' | awk -F 'request = ' '{print $2}' | awk -F ', response' '{print $1}'  >> settlement.txt

处理之后就成你想要的json数据，json格式如下：

{
    "amount":0.22,
    "bankCard":"623091019906******",
    "notifyStatus":2,
"sign":"bnMv9BVzJHmC+e7PVuKQX9LcfPbow95y7k5v5b8eh9917u+D5BWWSVtZgS3kanAvgCgWWZxud4XjAV2hzQmOzArmsPW0d7iJNruPW9CMYyFt70ioWrHx5KiYZAfSK1cDPMGWjqxK+SQB09hymB+9qA3vHOkjSm95UunGPW0aVNs=",
    "bankName":"**银行",
    "updateTime":"2019-07-31 18:02:14",
    "storeId":"201907291936400*****",
    "appId":"201609210856****",
    "billId":"JS190731050000570703283764",
    "bankNo":"313331000820",
    "payDay":20190730,
    "failReason":"调用PPC收银台取现失败:交易失败,回账成功,账号或卡号不存在",
    "isAcct":0,
    "sign_type":"RSA"
}