Our infrastructure has Total of 550+ instance running on AWS both linux and Windows and very Few Amazon linux machine out of that nearly 430 servers (nodes) are registered to AWS provisioned chef-automate server .
My question is that , is there any specific command to pull the information of what are all the software or agents installed on those servers both Linux/Windows , i knew there is Ohai plugin which can pull the information but i gives me all the unwanted data in json which is pain in neck to convert that into CSV format as the file is so huge its like 50Mb and the document could not load full information ,
I required only specific attributes to get the information of
OS Plat Form
SOFTWARE OR AGENT INSTALLED ALONG WITH VERSION ON THAT PARTICULAR SERVER
Please help me on this to get the information.