• Home
  • News
  • Documentation
  • Try for free
  • Buy your licence
  • Downloads
  • Contact us
  • Login

1. Feature Demo Databases

  • 00 Latest demo updates
  • 01 VBAuth Free Demo Manual
  • 02. VBAuth Complete Feature Demo Manual
  • VBAuth GraphAPI Integration Guide part 1
  • VBAuth GraphAPI Integration Guide part 2

2. New Outlook just broke my app – now what?

  • 01. Getting Started
  • 02. Send Email
  • 03. Create Calendar Event

3. Graph API Security Papers

  • 01. VBAuth WhitePaper Series Intro
  • 02. VBAuth WhitePaper Permissions
  • 03. VBAuth WhitePaper Scopes
  • 04. VBAuth WhitePaper AppRoles
  • 05. VBAuth Practical Security Guide
  • 06. VBAuth Token Lifetime Management
  • 07. VBAuth Sign-In Persistence
  • Supplement A. VBAuth Log File Reference v1.0.0.3

4. FAQ

  • Can I have multiple licence files?
  • Creating the first Entra App for VBAuth
  • Registering an Azure Entra Application
  • Remembering a Sign-In
  • VBAuth – a long term view
  • VBAuth Security Assurance
  • What is VBAuth
  • Why does VBAuth install to Program Files

5. Common VBA Module Code

  • Create the local admin table
  • JSON converter module (third party)
  • Making Sure Your Token‑Expiry Check Is Timezone‑Correct
  • modStartup.bas v2
  • modVBAuthGlobalConstants.bas v2
  • modVBAuthTesting.bas v2
  • README Shared Modules
  • README Startup v2
  • VBAuth Upgrade Guide Token Caching v2

Audit Trail

  • Form Code for Audit Trail
  • modGetAuditTrail.bas
  • README Audit Trail
  • README AuditTrail Tables

Checked Out Files

  • Form Code for Checked Out Docs
  • modCheckedOutFiles.bas
  • README Checked Out Files

Create Calendar Event

  • Form Code for Create Calendar Event
  • modCreateCalendarEvent.bas
  • README Create Calendar Event

Create Contact

  • Form Code for Create Contact
  • modCreateContact.bas
  • README Create Contact

Create Entra App

  • Form Code for Create Entra App
  • modCreateEntraApp.bas
  • modPopulateMissingObjectIDs.bas
  • modResetAndDelete.bas
  • README Create All Entra Apps
  • README Create Entra App
  • README Populate Missing ObjectIDs
  • README Reset And Delete

Create Task

  • Form Code for Create Task
  • modCreateToDoTask.bas
  • README Create Task

Download Scope Claims

  • Form Code for Scope Claims
  • modScopeClaims.bas
  • README Scope Claims

Licence Docs for VBAuth

  • MIT Licence for Feature Demo accdb
  • VBAuth EULA

List My Bookings (note MS limitations)

  • Form Code for List My Bookings
  • modGetBookingAppointments.bas
  • README List Bookings

List My Group Membership

  • Form Code for Get My Groups
  • modGetMyGroups.bas
  • README List My Group Membership

List Planner Tasks

  • Form Code for Planner Tasks
  • modListPlannerTasks.bas
  • README List Planner Tasks

List Tasks

  • Form Code for List Tasks
  • modListToDoTasks.bas
  • README List Tasks

List Teams Channels

  • Form Code for List My Channels
  • modListMyChannels.bas
  • README List My Channels

List Unread Emails

  • Form Code for List Unread Emails
  • modListUnreadEmails.bas
  • README List unread emails

Manage Entra App Roles

  • Form Code for Manage Entra App Roles
  • modManageEntraAppRoles.bas
  • README Manage Entra App Roles

Non-standard Microsoft 365 Tenants

  • Does VBAuth work with all Microsoft 365 environments?
  • How do I find my M365 environment

OneNote

  • Form Code for OneNote Notebooks
  • modListOneNoteNotebooks.bas
  • README OneNote Notebooks

Organisation Chart

  • Form Code for Organisation Chart
  • modOrgChart.bas
  • README Organisation Chart

Search OneDrive

  • Form Code for Search OneDrive
  • modSearchFilesDriveAPI.bas
  • README Search OneDrive

Search SharePoint and OneDrive

  • Form Code for Search SP & OD
  • modSearchFilesSearchAPI.bas
  • README Search SharePoint and OneDrive

Send As Email

  • Form Code Send As Email
  • modSendAsEmail.bas
  • README Send Email As

Send Email by Draft For Tracking

  • Form Code for Send Email by Draft for Tracking
  • modSendEmailDraft.bas
  • README Send Email Draft

Send Email With Attachments

  • Form Code for Send Email with Attachments
  • modSendEmailWithAttachments.bas
  • README Send Email with attachments

Send Email Without Attachments

  • Form Code for Send Email Without Attachments
  • modSendEmail.bas
  • README Send Email Without Attachments

Send HTML Email

  • Form Code for Send HTML Email
  • modSendEmailHTML.bas
  • README Send HTML Email

Sites

  • Form Code for SharePoint Site
  • modListSharePointSites.bas
  • README Sites and Subsites

Validate Contacts

  • Form Code for Validate Contacts
  • modValidateContacts.bas
  • README Validate SMTP Addresses

Who Am I (Current User)

  • Form Code for Who Am I (Current User)
  • modCurrentUser.bas
  • README Who Am I (Current User)
  • Home
  • Docs
  • M365 Administrative Functions
  • Audit Trail
  • README Audit Trail

README Audit Trail

Table Of Contents
  • VBAuth — Get Audit Trail
    • Overview
    • Table Structure
    • VBAuth Admin Table Configuration
    • Azure App Registration
    • How It Works
      • What replaces vs. what accumulates
      • Date parsing
      • Initiator parsing
    • Module: modGetAuditTrail.bas
      • Public functions
      • Private functions
    • Behaviour Notes
    • Querying the Data
    • Dependencies
You need to be logged in to view this content. Please Log In.
modGetAuditTrail.basREADME AuditTrail Tables
Updated on April 3, 2026