doctor500

Get IAM User activity and Key Activity - Usage

With curl:

bash <(curl -sL https://gist.github.com/doctor500/5b81107d50e685909e1df46038107a29/raw/ab91c2664c32e2a6ee70a71639011ffca7836e45/get_iam_user_and_key_activity.bash)

With wget:

bash <(wget -nv -O - https://gist.github.com/doctor500/5b81107d50e685909e1df46038107a29/raw/ab91c2664c32e2a6ee70a71639011ffca7836e45/get_iam_user_and_key_activity.bash)

doctor500

function insertJenkinsJobList( data_source, sheet_name){
  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName(sheet_name);
  let cell = sheet.getRange('A2');

  let rows = [];
  ss.setFrozenRows(1);
  sheet.getRange('A1:D1').setValues([[
    "Name", "View Name", "Url", "Last Run"
  ]]).setFontStyle('bold')

doctor500

function addJenkinsMenu() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Jenkins')
    .addItem('Get Job list fron Jenkins API', 'myFirstFunction')
    .addItem('Get Job that was run last this week', 'mySecondFunction')
    .addToUi();
}

doctor500

{
    "_class" : "hudson.model.Hudson",
    "jobs" : [
      {
        "_class" : "org.jenkinsci.plugins.workflow.job.WorkflowJob",
        "actions" : [],
        "description" : "",
        "displayName" : "My Fancy Jenkins Job Here",
        "displayNameOrNull" : "My Fancy Jenkins Job Here",
        "fullDisplayName" : "My Fancy Jenkins Job Here",

doctor500

  var sheet_name = Browser.inputBox('Enter Sheet Destination Name','Leave blank to use default name (JenkinsCI)', Browser.Buttons.OK_CANCEL);
  if (sheet_name.match('cancel')){
    return SpreadsheetApp.getUi().alert("Operation abort!");
  }
  sheet_name = sheet_name == '' ? 'JenkinsCI' : sheet_name

doctor500

function insertJobListToSheet(){
  let user_name = "yes_man";
  let user_token = "0293kdj2039dk20e9fj203923k90235ck234mlfg";
  let url_endpoint = "https://your-lovely-jenkins-url.com/api/json?tree=jobs[fullDisplayName,fullName,url,lastBuild[id,timestamp]]&pretty=true";
  let data_source = fetchJenkinsAPI(user_name,user_token, url_endpoint);
  
  insertJenkinsJobList(data_source,"Result")
}

function fetchJenkinsAPI(user_name, user_token, url_endpoint){