Help with Powershell piping query

All replies

• 

  

  0

  Sign in to vote

  You can directly query AD using get-qadobject -identity objectguid

  Get-QADObject -Identity "d9cd9083-cb47-4f63-bfc2-1a7670ef511e"

  
  

  ---

  Shaba

  Sunday, March 11, 2012 8:49 PM
• 

  

  0

  Sign in to vote

  If you have a CSV file with GUID,

  Import-Csv .\guid.csv |ForEach-Object {Get-QADObject $_.guid}

  The CSV file I used is as below.

  [PS] C:\Users\exadmin>Import-Csv .\guid.csv
  
  Guid
  ----
  82185384-3399-4357-bd0e-7fe651bfd3bc
  9ba314aa-54e9-465a-8bba-4b912b119461
  

  Good luck !

  
  

  ---

  Shaba

  Sunday, March 11, 2012 8:52 PM
• 

  

  0

  Sign in to vote

  Hello

  No, this command doesn't work:

  get-qadobject -identity objectguid

  It works for GUID, but not objectGUID (two different values in our case).

  Sunday, March 11, 2012 9:08 PM
• 

  

  0

  Sign in to vote

  PS > (Get-QADUser kazun).objectGUID
  1B89525A63CA2248BF68DA5F68A9101E
  PS > Get-QADUser -LdapFilter "(objectGUID=\1B\89\52\5A\63\CA\22\48\BF\68\DA\5F\68\A9\10\1E)"
  
  Name                           Type            DN
  ----                           ----            --
  Kazun                          user            CN=Kazun....
  
  
  PS > Get-QADUser -LdapFilter "(objectGUID=\1B\89\52\5A\63\CA\22\48\BF\68\DA\5F\68\A9\10\1E)" | fl
  displayname
  
  DisplayName : Kazun
  
  Convert objectguid from Get-QADUser to LDAP:
  PS >  "1B89525A63CA2248BF68DA5F68A9101E" -replace "(\w{2})",'\$1'
  \1B\89\52\5A\63\CA\22\48\BF\68\DA\5F\68\A9\10\1E
  
  or second variant using param Identity
  
  PS > (Get-QADUser kazun).objectGUID
  1B89525A63CA2248BF68DA5F68A9101E
  
  #Show nothing,because you must reverse byte order in array
  PS > Get-QADUser -Identity 1B89525A63CA2248BF68DA5F68A9101E
  
  PS >  $guid = "1B89525A63CA2248BF68DA5F68A9101E"
  PS >  -join (([GUID]$guid).ToByteArray() |% {"{0:x}" -f $_})
  5a52891bca634822bf68da5f68a9101e
  
  PS > Get-QADUser -Identity 5a52891bca634822bf68da5f68a9101e | fl  displayname
  
  DisplayName : Kazun
  

  
  

  Sunday, March 11, 2012 9:11 PM
• 

  

  0

  Sign in to vote

  Thanks, but do you know how I would run that second variant in a script if I have a bunch of objectGUID's?

  Also, would it not be easier to write a query that says:

  i. get-qaduser where objectGUID is equal to first objectGUID in csv file

  ii. for the value returned, give DisplayName

  Sunday, March 11, 2012 9:23 PM
• 

  

  0

  Sign in to vote

  #For all guids
  
  Import-Csv C:\objectguid.csv | Foreach {
  	Get-QADUser -Identity (-join (([GUID]$_.objectguid).ToByteArray() |% {"{0:x}" -f $_}))
  } | Format-Table DisplayName
  
  #First only
  
  Import-Csv C:\user.csv | Select -First 1 | Foreach {
  	Get-QADUser -Identity (-join (([GUID]$_.objectguid).ToByteArray() |% {"{0:x}" -f $_}))
  } | Format-Table DisplayName

  
  

  • Proposed as answer by Yan Li_ Monday, March 12, 2012 2:28 AM
  • Unproposed as answer by Neil4933 Tuesday, March 13, 2012 12:54 AM

  Sunday, March 11, 2012 9:30 PM
• 

  

  0

  Sign in to vote

  Shorter I thing:

  $guid = get-QADuser 'user' |%{$_.DirectoryEntry.objectGuid} | convert-QADAttributeValue -outputTypeName 'Guid'

  $u = get-qaduser -identity $guid

  • Proposed as answer by Yan Li_ Monday, March 12, 2012 2:28 AM
  • Unproposed as answer by Neil4933 Tuesday, March 13, 2012 12:54 AM

  Sunday, March 11, 2012 11:26 PM
• 

  

  0

  Sign in to vote

  Hi Kazun

  So I ran the below:

  Import-Csv C:\guid.csv | Foreach {Get-QADUser -Identity (-join (([GUID]$_.objectguid).ToByteArray() |% {"{0:x}" -f $_}))} | Format-Table DisplayName

  But I am not getting any results back? Even though the objectGUID listed in the CSV file definately matches that of an AD user?

  Tuesday, March 13, 2012 1:03 AM
• 

  

  0

  Sign in to vote

  Hi,

  I would like suggest you refer to the below links for more information about changing objectGUID to GUID:

  http://www.powergui.org/thread.jspa?threadID=7680

  And

  Using objectGUID to Bind to an Object

  http://msdn.microsoft.com/en-us/library/windows/desktop/ms677985(v=vs.85).aspx

  Best Regards,

  Yan Li

  ---

  Yan Li

  TechNet Community Support

  

  
  

  • Edited by Yan Li_ Friday, March 16, 2012 7:42 AM
  • Marked as answer by Yan Li_ Monday, March 19, 2012 1:55 AM

  Friday, March 16, 2012 7:41 AM