Hi Kitrine
There are two views with this information
RPT_LicenseDetailsView for licenses, including who assigned it
RPT_UserView with user information
Here's an example query, which may have way too much info, but you can pare it back:
SELECT /* license view */
[ProductName]
,[LicenseTypeName]
,[OwnerUserName] /* who assigned it */
,[AssigneName] /* who it was assigned to */
,[StartDate]
,[ExpiryDate]
,[MaintenanceExpDate]
,[AllowedMoves]
,[CRMLicenseId]
,[Module]
,l.[ModifiedDate]
,[IsAssigned]
/* user view */
[Username]
,u.[Userid]
,[DisplayName]
,[FirstName]
,[LastName]
,[Email]
,[State]
,[CreatedDate]
,u.[ModifiedDate]
FROM [WSEvolveDBGA].[dbo].[RPT_LicenseDetailsView] l, [WSEvolveDBGA].[dbo].[RPT_UserView] u
where u.Userid = l.UserId
Please note I'm on Evolve 24.x. If you are on a different version, your schema may be slightly different.
Hope this helps,
Sigrid
------------------------------
Sigrid Kok
*Precisely Software Inc.
------------------------------