Send CSV to Microsoft OneDrive
  • 2 Minutes To Read
  • Print
  • Share
  • Dark
    Light

Send CSV to Microsoft OneDrive

  • Print
  • Share
  • Dark
    Light

The Send CSV to Microsoft OneDrive action takes the saved query supplied as a trigger (or entities that have been selected in the asset table), creates a CSV file, and sends it to a specific path on Microsoft OneDrive.

To configure the Send CSV to Microsoft OneDrive action, from the Action Library, click Notify, and then click Send CSV to Microsoft OneDrive.

image.png

image.png

Connection Settings

  1. User name and Password (required) - The credentials for a Microsoft Azure AD user account that has read and write permissions to the supplied OneDrive account.
    NOTE

    Axonius does not use the application authentication, as application permissions provides access to all files in the organization.

  2. Tenant ID (required) - Microsoft Azure Active Directory ID.
  3. Client ID (required) - The Application ID of the Axonius application.
  4. Folder path (optional, default: empty) - Specify a folder path.
    • If supplied, the file will be created under the specified folder path.
    • If not supplied, the file will be created under the user's root drive.
  5. File name (required, default: axonius_data) - The file name.
  6. Append date and time to file name (required, default: True)
    • If enabled, the date and time (in UTC) of enforcement action execution will be added as a suffix to the generated CSV file name. For example, axonius_data_2020-01-06-16:48:13.csv.
    • If disabled, the CSV file will be stored based on the specified/default file name.
  7. Verify SSL (required, default: True) - Verify the SSL certificate offered by Microsoft OneDrive. For more details, see SSL Trust & CA Settings.
    • If enabled, the SSL certificate offered by Microsoft OneDrive will be verified against the CA database inside of Axonius. If the SSL certificate can not be validated against the CA database inside of Axonius, the connection will fail with an error.
    • If disabled, the SSL certificate offered by Microsoft OneDrive will not be verified against the CA database inside of Axonius.
  8. HTTPS proxy (optional, default: empty) - A proxy to use when connecting to Microsoft OneDrive.
    • If supplied, Axonius will utilize the proxy when connecting to Microsoft OneDrive.
    • If not supplied, Axonius will connect directly to Microsoft OneDrive.

Required Permissions

The value supplied in User Name must be a Microsoft Azure AD user account that has read and write permissions to the supplied OneDrive account.

  1. In Azure AD, create a user for Axonius.
  2. Login as the user and create an application. A user can register an application by default.
  3. Copy the Client ID and Tenant ID from the application page.
  4. In the Request API permission section, add GraphAPI and provide the following permissions:
    1. Delegated Permissions
    2. Files.ReadWrite.Al

These permissions will allow the application an access only to the files that the user can access.
image.png

  1. Go to the Authentication section and enable the Allow public client flow.
    image.png
Was This Article Helpful?