An alias is a short name to identify the user on list pages, reports, or other places where their entire name doesn’t fit.

By default, the alias is the first letter of the user’s first name and the first four letters of their last name.

Sample SOQL:

SELECT Id, Name, Alias
FROM User
WHERE IsActive = true
AND  Profile.UserLicense.Name = 'Salesforce'