Computing field for Managedby to Manager.Displayname

To request a new custom report, please post in our Custom Reports Forum and provide the following information:

  1. An overview explaining the report you require.  .   a formula or computed field that transforms the managedby to a manager displayname
  1. What version of Enterprise Reporter is being used?  3.5
  1. What discoveries have been run?   have been using powershell but now developing a few reports using ER.
  • AD   Yes
  • Azure AD   No
  • Azure Resources  No
  • Computers  na
  • Exchange  na
  • Exchange online  na
  • File Storage Analysis  na
  • NTFS  na
  • Registry   na
  • SQL   na
  1. Is there a library report that closely matches what you require?   'users that have never logged on' is close and i added fields but the manager field is the difficulty with converting it to displayname
  1. What fields are required in the report?   username, samaccount, email, managerdisplayname,   lastlogon, password last set, accountexpires 
  1. How does the information in the report need to be sorted?   if there is a twistie available to be tagged to columns that would be great. i can customize for sort myself
  1. What parameters are required for filtering the report?  should be able specify OU and Group wildcard
  1. How will this report be consumed? For example, will the report be viewed in report display, exported to CSV, or exported to PDF?
    This report will both be displayed in report display and exported to CSV. no pdf needed.

    note:  I can create this same report in powershell but not sure of how to convert the CN for the managedby (for the User) to a displayname value.  
    In a report using the Manager.Displayname is preferred for readability rather than using the CN

    Here is a sample from PS for what im talking about
    Get-ADGroupMember -Identity "AAA_SCREENING" | ForEach-Object {
    $user = Get-ADUser $_.SamAccountName -Properties EmailAddress, Manager, DisplayName
    $manager = Get-ADUser $user.Manager -Properties DisplayName
    Name = $user.Name
    NUID = $_.SamAccountName
    Email = $user.EmailAddress
    ManagerDisplayName = $manager.DisplayName


    Name        NUID Email    ManagerDisplayName
    ---- ---- ----- ------------------
    Joe smith abc1234 Michael J Smith