Active Directory 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.