Hi
I have an event which has prod and test based on env...if it is test it goes to nsps [{},{} ] object an check for the name say A,B,C,D an get their associate ReadOnlyConsumerNames in tabular format
Output as:
Name ReadOnlyConsumerNames
A Application, Lst,data
B Application, Lst
C Lst
D Lst,Gt,PT
{ [-]
prod: { []
}
test: { [-]
DistinctAdminConsumers: [ [-]
App
pd.
]
DistinctAdminUser: 2
DistinctReadConsumers: [ [-]
Application.
GT.
Technology.
data
]
DistinctReadUser: 4
TotalAdminUser: 20
TotalNSPCount: 10
TotalReadUsers: 13
nsps: [ [-]
{ [-]
AdminConsumerNames: [ [-]
App.
pd.
]
AdminUserCount: 2
Name: A
ReadOnlyConsumerNames: [ [-]
Application
Lst
data
]
ReadonlyUserCount: 3
}
{ [-]
AdminConsumerNames: [ [-]
App
Data
]
AdminUserCount: 2
Name: B
ReadOnlyConsumerNames: [ [-]
Application
Lst
]
ReadonlyUserCount: 3
}
{ [-]
AdminConsumerNames: [ [-]
preprod
pd
]
AdminUserCount: 2
Name: C
ReadOnlyConsumerNames: [ [-]
Lst
]
ReadonlyUserCount: 1
}
{ [-]
AdminConsumerNames: [ [+]
]
AdminUserCount: 2
Name: D
ReadOnlyConsumerNames: [ [-]
Lst
Gt
PT
]
ReadonlyUserCount: 1
}
]
}
}
| spath test.nsps{} output=nsps
| mvexpand nsps
| spath input=nsps Name output=Name
| spath input=nsps ReadOnlyConsumerNames{} output=ReadOnlyConsumerNames
| table Name ReadOnlyConsumerNames