This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

User List

Just started the Phish trial, disappointed to see it doesn't seem to user our current Sophos Cloud user list or sync to AD.



This thread was automatically locked due to age.
  • I agree, I did make a powershell script to help(Edit the server to match  for your SearcheBase OU and AD server:)  Also you will have the fill colum in csv output for language.

    $path = Split-Path -parent "C:\userlists\*.*"

    #Create a variable for the date stamp in the log file

    $LogDate = get-date -f yyyyMMddhhmm

    #Define CSV and log file location variables
    #they have to be on the same location as the script

    $csvfile = $path + "\ALLADUsers_$logDate.csv"

    #import the ActiveDirectory Module

    Import-Module ActiveDirectory


    #Sets the OU to do the base search for all user accounts, change as required.
    #Simon discovered that some users were missing
    #I decided to run the report from the root of the domain

    $SearchBase = "DC=NA,DC=fabrikam,DC=com"

    #Get Admin account credential

    $GetAdminact = Get-Credential

    #Define variable for a server with AD web services installed

    $ADServer = 'myADserver'


    $AllADUsers = Get-ADUser -server $ADServer `
    -Credential $GetAdminact -searchbase $SearchBase `
    -Filter * -Properties * | Where-Object {$_.info -NE 'Migrated'} #ensures that updated users are never exported.

    $AllADUsers |
    Select-Object @{Label = "First Name";Expression = {$_.GivenName}},
    @{Label = "Last Name";Expression = {$_.Surname}},
    @{Label = "Email";Expression = {$_.Mail}},
    @{Label = "Title";Expression = {$_.Title}},
    @{Label = "Department";Expression = {$_.Department}},
    @{Label = "Manager Name";Expression = {%{(Get-AdUser $_.Manager -server $ADServer -Properties DisplayName).DisplayName}}},
    @{Label = "Manager Email";Expression = {%{(Get-AdUser $_.Manager -server $ADServer -Properties mail).mail}}},
    @{Label = "Language";Expression = {EN}} |

    #Export CSV report

    Export-Csv -Path $csvfile -NoTypeInformation

  • Hey Doug, the trial allows you to upload 5 employees to the list and you can upload the details using a .csv file or add people manually for now. The next phase for us is to allow additional import methods such as porting over the users from Central but at the moment Central doesn't capture all of the information needed for Phish Threat. Those features will be in the product soon ;)