pid name tid mod state data
-------------------------------------------------------------------------
39523 srv0051_0001_0 39642 20-10:59:28 Working 820000:500196:500077
43137 srv0051_0005_0 43156 20-10:59:28 Working 820000:4250501:840057
43895 srv0051_0006_0 43903 20-10:59:28 Working 820000:4250501:840057
47523 srv0051_0009_0 47547 20-10:59:28 Working 600005:4250501:4250846
48841 srv0051_0010_0 48851 20-10:59:28 Working 600005:4290000:4290000
58182 srv0051_0020_0 58188 20-10:59:28 Working 820000:4250501:840057
8297 srv0079_0008_0 8316 20-10:59:27 Working 600005:3070001:3050012
pid,name,tid,mod,state,appnbr,request,tasknbr,appctx,username
39523,srv0051_0001_0,39642,09-JUL-2018 12:36:10,Working,820000,500196,500077
43137,srv0051_0005_0,43156,09-JUL-2018 12:36:10,Working,820000,4250501,840057
43895,srv0051_0006_0,43903,09-JUL-2018 12:36:10,Working,820000,4250501,840057
47523,srv0051_0009_0,47547,09-JUL-2018 12:36:10,Working,600005,4250501,4250846
48841,srv0051_0010_0,48851,09-JUL-2018 12:36:10,Working,600005,4290000,4290000
58182,srv0051_0020_0,58188,09-JUL-2018 12:36:10,Working,820000,4250501,840057
8297,srv0079_0008_0,8316,09-JUL-2018 12:36:10,Working,600005,3070001,3050012
通过运行以下命令来收集此数据:
spsmon -state working -snapshot > /root/file.txt
到目前为止,我有:
awk 'BEGIN{print
"pid,name,tid,mod,state,appnbr,request,tasknbr,appctx,username"} NR>5
'!/Process/' '!/ProcessModules/' '!/ProcessEvoke/' {print
$1","$2","$3","$4","$5","gensub(/:/,",","g",$6)}' /root/file.txt >
/root/file.txt
我主要对如何将mod列更改为所需的日期格式感到困惑。
使用GNU Awk,并从当前时间获取缺少的月份和年份:
gawk '
BEGIN{
OFS=","
print "pid,name,tid,mod,state,appnbr,request,tasknbr,appctx,username"
}
NR>2 {
split($4,a,"-")
$4 = a[1] strftime("-%^b-%Y ", systime()) a[2]
gsub(/:/,",",$6)
print
}' /root/file.txt
或忽略文件并在管道中使用
spsmon -state working -snapshot | gawk '...'
前任。
$ gawk '
BEGIN{
OFS=","
print "pid,name,tid,mod,state,appnbr,request,tasknbr,appctx,username"
}
NR>2 {
split($4,a,"-")
$4 = a[1] strftime("-%^b-%Y ", systime()) a[2]
gsub(/:/,",",$6)
print
}' file.txt
pid,name,tid,mod,state,appnbr,request,tasknbr,appctx,username
39523,srv0051_0001_0,39642,20-JUL-2018 10:59:28,Working,820000,500196,500077
43137,srv0051_0005_0,43156,20-JUL-2018 10:59:28,Working,820000,4250501,840057
43895,srv0051_0006_0,43903,20-JUL-2018 10:59:28,Working,820000,4250501,840057
47523,srv0051_0009_0,47547,20-JUL-2018 10:59:28,Working,600005,4250501,4250846
48841,srv0051_0010_0,48851,20-JUL-2018 10:59:28,Working,600005,4290000,4290000
58182,srv0051_0020_0,58188,20-JUL-2018 10:59:28,Working,820000,4250501,840057
8297,srv0079_0008_0,8316,20-JUL-2018 10:59:27,Working,600005,3070001,3050012
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句