Active Directory CSV Active Directory CSV

Configure the Active Directory connector to import users and computer inventory via CSV

This guide explains how to configure the Active Directory (AD) connector to import users and computer inventory via CSV files.

Objective

The AD connector allows you to import user and computer inventory information from a CSV file generated by PowerShell commands. These files are then integrated via a CSV connector on our platform.

Prerequisites

  • Administrative access to Active Directory.
  • PowerShell installed on the administrator's machine.
  • Necessary permissions to run PowerShell commands and access AD information.

Steps to Generate CSV Files

1. Export Users

To export user information, run the following command in PowerShell:

Get-ADUser -Filter * -Properties * |
Select-Object UserPrincipalName, GivenName, sn, Title, ObjectGUID, objectSid, PasswordExpired, PasswordLastSet, PasswordNeverExpires, PasswordNotRequired, DistinguishedName, samAccountName, Enabled, Created, LastlogonDate |
Export-Csv -Path C:\DESTINATIONFOLDER\ExportADusers.csv

Destination Folder: Replace C:\DESTINATIONFOLDER\ with the path where you want to save the CSV file.

2. Export Computer Inventory

To export computer inventory information, run the following command in PowerShell:

Get-ADComputer -Filter * -Properties * |
Select-Object Name, DNShostname, DistinguishedName, ObjectGUID, objectSid, Created, LastLogonDate, enabled, OperatingSystem, OperatingSystemVersion |
Export-CSV C:\DESTINATIONFOLDER\ExportADcomputers.csv

Destination Folder: Replace C:\DESTINATIONFOLDER\ with the path where you want to save the CSV file.

Notes

Ensure that the destination folder exists before running the commands. Check access permissions to avoid errors during data export. CSV files should be updated regularly to reflect changes in AD.

Conclusion

By following these steps, you will be able to configure the AD connector and integrate the necessary data into your platform. For any questions or additional assistance, please contact our technical support.

Uploading files through DropPoint

Files for the Active Directory connector are stored in a dedicated S3 bucket named activedirectory. Drop your CSV (or JSON) files at the root of s3://activedirectory/: OverView automatically detects new files and imports them on the next synchronization.

Where do the files go?

Bucket : s3://activedirectory/

Example : s3://activedirectory/ExportADusers.csv

Several ways to send your files

You can populate your bucket in several ways:

  • OverView web interface — import your files, configure the mapping, then click “Replace” to refresh the data without redoing the mapping.
  • AWS CLI — for a one-off or scripted upload.
  • S3 SDK (boto3, etc.) — to fully automate recurring imports.

Using the AWS CLI

# Upload a file to the activedirectory bucket
aws s3 cp ExportADusers.csv s3://activedirectory/ExportADusers.csv --profile ovs_your_org

# Or sync a whole local folder
aws s3 sync ./exports/ s3://activedirectory/ --profile ovs_your_org

Automating the import via S3

import boto3

s3 = boto3.client(
    "s3",
    endpoint_url="https://s3.oversoc.com",
    region_name="fr-par",
    aws_access_key_id="YOUR_ACCESS_KEY",
    aws_secret_access_key="YOUR_SECRET_KEY",
)

# Push the export into the activedirectory bucket
s3.upload_file("ExportADusers.csv", "activedirectory", "ExportADusers.csv")

Pair this script with a scheduled task (cron on Linux, Task Scheduler on Windows) to push your exports automatically at a regular interval. Each upload triggers a new import on the OverView side.

Prerequisite: generate your S3 credentials and configure your client (endpoint, profile) as described in the OverView DropPoint guide. The profile and endpoint used here are explained there.

← PreviousFortiEMSNext →Microsoft EntraID