是否可以从Active Directory的member返回单个值并插入到SQL表中?

我试图从memberof列中获取单个值,是否可以解析该值并只返回该字符串的一部分,如值0012? 这是类别成员的输出。

CN=Active VMS Users,OU=VMS,DC=evilcorp,DC=net CN=JOJOE\, MOE- 0012,
OU=Site Groups,OU=VMS,DC=evilcorp,DC=net

这是我下面的代码

$ADARRAY= Get-ADGroupMember -Identity "Domain Users" -Recursive | 
Get-ADUser -Filter "Mail -like '*'" -and "MemberOf -like '*'"| 
Get-ADUser -Properties ('Mail','MemberOf')

<# this was my first try #>
    # $CN = $CN -split '^CN=(.+?-,\),(?:OU|CN)=.+','$1'

ForEach($OBJECT in $ADARRAY){ 

    $NAME = $OBJECT.Name 
    $USER = $OBJECT.SamAccountName
    $EMAIL = $OBJECT.Mail

<# this was my second try #>
    ForEach($OBJECT in $ADARRAY.Memberof){
          $CN = New-Object PSCustomObject -Property @{'CN' = $CN}

        $CN.OBJECT = $CN.Split(',')[0]

    $INSERT = "INSERT INTO $TABLE VALUES ('$USER','$CN','$EMAIL', '$NAME');"
        $SQL.CommandText = $INSERT 

        $SQL.ExecuteNonQuery()

    } 
  }
}

$SQLCON.Close()