Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
299 views
in Technique[技术] by (71.8m points)

Google AdminReports - How to export admin audit log events description?

I'm trying to make a script to copy the Google Admin Audit Logs to a google sheet. But I don't know how to export the event description. Can someone help?

function generateAdminLogReport() {
  var now = new Date();
  var lastYear = new Date(now.getTime() - 365 * 24 * 60 * 60 * 1000);
  var startTime = lastYear.toISOString();
  var endTime = now.toISOString();

  var rows = [];
  
  var pageToken;
  var page;
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Admin.Logs');
  rows.push(['Date','Event Name','Admin']);
  sheet.getRange("A1:D1").setFontWeight("Bold").setFontColor("Blue").setHorizontalAlignment("center").setVerticalAlignment("middle").setBackground("#beedda").setWrap(true);
  sheet.getRange("A2:D").clear();

  do {
    page = AdminReports.Activities.list('all', 'admin', {
      startTime: startTime,
      endTime: endTime,
      pageToken: pageToken
    });
    var items = page.items;
    if (items) {
      for (var i = 0; i < items.length; i++) {
        var item = items[i];
        var row = [
          new Date(item.id.time),
          item.events[0].name,
          item.actor.email
        ];
        rows.push(row);
      }
    }
    pageToken = page.nextPageToken;
  } while (pageToken);

  if (rows.length > 0) {
    // Append the results.
    sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows).setVerticalAlignment('middle').setWrap(true);

    Logger.log('Report spreadsheet created: %s', sheet);
  } else {
    Logger.log('No results returned.');
  }
}
question from:https://stackoverflow.com/questions/66058815/google-adminreports-how-to-export-admin-audit-log-events-description

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

56.8k users

...