Here is what I need to generate: So far I have this search to generate everything but the right-most column: index=Production sourcetype=df host="host*" MountedOn="/b1"
| stats latest(...
See more...
Here is what I need to generate: So far I have this search to generate everything but the right-most column: index=Production sourcetype=df host="host*" MountedOn="/b1"
| stats latest(Size) as "Allocation", latest(Used) as "Usage"
| eval Environment="Production",
"Server info (LDOM)"="host1,host2",
"Mount Point"="/export/backups",
"Backup Filesystem"="/backup01",
"Local mount"="/b1"
| table Environment, "Server info (LDOM)", "Mount Point", "Backup Filesystem", "Local mount", "Allocation", "Usage" Results: And this search generates the contents for the right-most column in the spreadsheet: index=DB sourcetype=db_size
| table source, TotalSizeGB
| eval TotalSizeGB=round(TotalSizeGB,2)
| sort -TotalSizeGB Results: How can I get the results of search #2 to appear in the final right-most column of search #1's results? Thank you!