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

Get-QADUser returns blank values

In the process of upgrading our v6.9 to the latest version but there is a burning issue for which our Operations team is looking for a report. The requirement is to gather the list of all user accounts in AD with their EmployeeIDReference and Division (of which EmployeeIDReference is a virtual attribute. Division is exposed and available using AD PowerShell Modules too)

If I run

Get-QADUser <identity> -IncludedProperties EmployeeIDReference,Division,samAccountName | Select EmployeeIDReference,Division,samAccountName 

It works fine, displays the table correctly.

But If I run 

Get-QADUser -sizeLimit 0 -IncludedProperties EmployeeIDReference,Division,samAccountName | Select EmployeeIDReference,Division,samAccountName

I get all blank attributes for everything except samAccountName.

If I run Get-QADUser -sizeLimit 0 -IncludeAllProperties | Select EmployeeIDReference,Division,samAccountName

it takes forever to run (as each user has about ~200 attributes) but gets there eventually and so is not really desirable. I had a look at the half built data and the info we were looking for is there.

(P.S.: I've already run the connect-qadservice <Servername> -proxy at the beginning>

 

Any thoughts or alternate suggestions?

Parents
  • Suggest you change the second line as follows:

    Get-QADUser -Proxy -sizeLimit 0 -IncludedProperties $Attributes -DontUseDefaultIncludedProperties | Select DisplayName,SamAccountName,division,Department,Company,employeeid,employeeidreference,employeeNumber,employeeType,AccountIsDisabled,PasswordIsExpired,AccountExpires | Export-Csv $outputfilename -NoTypeInformation
Reply
  • Suggest you change the second line as follows:

    Get-QADUser -Proxy -sizeLimit 0 -IncludedProperties $Attributes -DontUseDefaultIncludedProperties | Select DisplayName,SamAccountName,division,Department,Company,employeeid,employeeidreference,employeeNumber,employeeType,AccountIsDisabled,PasswordIsExpired,AccountExpires | Export-Csv $outputfilename -NoTypeInformation
Children
No Data