How do I export a spreadsheet of monitored servers?

[Michael.Perlstein]

As of 4.2.x, it is not possible to export a CSV file from the controller UI for all of the servers being monitored.

As a workaround, a user must capture the raw data and format it using Google Chrome browser, a text editor (our team recommends using TextWrangler or BBEdit, but any text editor with "Find and Replace" capability is fine), and your computer's terminal. The following instructions apply to any Unix-based operating system such as Mac OS X. 

In Google Chrome, access the server monitoring user interface from the controller UI.

 

Launch Chrome Developer Tools (ALT+CMD+I) by clicking on View > Developer > Developer Tools in the browser toolbar.

Click on the network tab of Developer Tools, then check the box labeled "Preserve Log". 

Refresh the controller UI in the browser and network tab will populate with all the page requests.

Once the page is fully loaded, search for a particular network request in the following format:

https://[CONTROLLER-URL]/controller/sim/v2/user/machines?appIds=&tierIds=&nodeIds=&format=LITE

 

Double-click on the request to open a new tab with the desired data in a JSON format. Alternatively, you could select the response tab for this specific request to see the JSON data.

Copy the JSON data and paste in a text editor. Use "Find and Replace" to change the data into a CSV spreadsheet using the following steps.

1. Find "," and Replace with "\n,\n"
2. Find },{ and Replace with }\n,\n{\n
   
3. Find {" and Replace with {\n"
4. Save the file in the text editor as hosts.txt
5. Open a terminal window and run the following command:

cat hosts.txt | grep hostId | sed 's/"hostId":"//g' | sed 's/"/,/g' > hosts.csv

The resulting hosts.csv file will contain a column of hostIDs from your controller's list of servers.

[Daniel.Odievich]

These steps are no longer necessary.

https://www.appdynamics.com/community/exchange/extension/appdynamics-dexter-data-extraction-enhanced... will allow you to get all detected entities anywhere in a CSV and XLSX format