SELECT
sr.RequestID,
sr.RequestTime,
ru.UserName,
ru.UserDomain,
rt.RequestTypeName
FROM
[Service Request] AS sr
JOIN
[Request User] AS ru ON sr.RequestUserID = ru.RequestUserID
JOIN
[Request Type] AS rt ON sr.RequestTypeID = rt.RequestTypeID
WHERE
rt.RequestTypeName = 'AcquireLicense'
ORDER BY
sr.RequestTime DESC;