Hi @paoloromagnoli, try this | rest splunk_server=local /services/deployment/server/clients
| table hostname ip utsname *.restartSplunkd
| eval temp=hostname."#".ip."#".utsname
| table temp *.restartSplunkd
| eval application.NoApp.restartSplunkd=0
| untable temp apps count
| eval Apps=if(like(apps,"app%"),mvindex(split(apps,"."),1),null())
| eval ServerClass=if(like(apps,"server%"),mvindex(split(apps,"."),1),null() )
| rex field=temp "(?<Host>.*)#(?<Host_IP>.*)#(?<Machine_Type>.*)"
| table Host Host_IP Machine_Type Apps ServerClass
| stats Values(*) as * dc(Apps) AS dc_apps by Host Host_IP Machine_Type
| eval Apps=if(dc_apps=1,Apps,mvindex(Apps,1,10))
| nomv Apps
| nomv ServerClass
| fillnull value="NoSC" ServerClass Ciao. Giuseppe
... View more