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.'); } }
2.1m questions
2.1m answers
60 comments
56.8k users