Need to pull out all EC2 properties from AWS management console? This script can help, will dump a csv, really usefull as a jumpstart for inventory/documentation Instructions: * Navigate the region you want to extract, e.g. https://console.aws.amazon.com/ec2/v2/home?region=eu-west-1 * Launch script in console (or maybe create a scriptlet?) credi…

extractAllEC2Properties.js

var jquerySelector = "#instances_datatable_hook > div:nth-child(3) "
var columns = $(jquerySelector + 'thead th').map(function() {
  return $(this).text();
});

var tableObject = $(jquerySelector + 'tbody tr').map(function(i) {
  var row = {};
  $(this).find('td').each(function(i) {
    row[columns[i]] = $(this).text();
  });
  return row;
}).get(); 

console.log(columns);
console.log(tableObject);
window.open("data:text/csv;charset=utf-8," + escape(JSON2CSV(columns, tableObject)))

function JSON2CSV(columns, array) {
    var str = '';
    var line = '';

    for (var index in columns[0]) {
        var value = index + "";
        line += '"' + value.replace(/"/g, '""') + '",';
    }

    str = line + '\r\n';

    for (var i = 0; i < array.length; i++) {
        var line = '';

        for (var index in array[i]) {
            var value = array[i][index] + "";
            line += '"' + value.replace(/"/g, '""') + '",';
        }
        line = line.slice(0, -1);
        str += line + '\r\n';
    }
    return str;
    
}