Knowledge Base

cancel
Showing results for 
Search instead for 
Did you mean: 

How do I export a spreadsheet of monitored servers?

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.

 

 Servers Dashboard.png

 

 

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

 

Screen Shot 2017-03-24 at 12.10.27 PM.png

 

 

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

 

Network Tab.png

 

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

 

 

Specific Request.png 

 

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.

 

hostscsv.png

Version history
Revision #:
5 of 5
Last update:
‎02-20-2019 10:15 AM
Updated by:
 
Labels (1)
0 Kudos
Comments

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