AD User Initials Report

[eandm]

Is there any way to create a report seeing all user AD Initials? I may have just missed it but cant seem to find the option...

[Susan_A · Accepted solution]

We don't specifically scan the Initials attribute - I've added this to the wish list - but you could isolate the first letters of the user's first and last name within a report. I've included a sample report below, which you can add to your Lansweeper installation by following these instructions.

Select Top 1000000 tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Firstname,
  tblADusers.Lastname,
  SubString(tblADusers.Firstname, 1, 1) + '. ' + SubString(tblADusers.Lastname,
  1, 1) + '.' As Initials
From tblADusers
Order By tblADusers.Userdomain,
  tblADusers.Username