我一直在尝试使用jq从下面的json文件中提取一个csv,但到目前为止还无法实现。这里有专家可以帮忙吗?
{
"values": [
{
"resourceId": "xxxx-xxxx-xxx-8b16-xxxxxx","property-contents": {
"property-content": [
{
"statKey": "config|name","timestamps": [
1517591034069
],"values": [
"somebname.UNIVERSE.test.com"
]
},{
"statKey": "summary|guest|ipAddress","values": [
"100.xx.5.xx"
]
},{
"statKey": "summary|parentCluster","timestamps": [
1551120506024
],"values": [
"UFO-UFO"
]
},{
"statKey": "summary|parentDatacenter","timestamps": [
1551120806021
],"values": [
"GALAXY-D123"
]
},{
"statKey": "summary|parentVcenter","timestamps": [
1517591334271
],"values": [
"X-RAY123"
]
},{
"statKey": "summary|runtime|powerState","values": [
"Powered On"
]
}
]
}
},..
...
xxx-xxxx-xxx-8b16-xxxxxx,somebname.UNIVERSE.test.com,100.xx.5.xx,UFO-UFO,GALAXY-D123,X-RAY123,Powered On
预期o / p为:
xxx-xxxx-xxx-8b16-xxxxxx,Powered On