Automate

 View Only

  • 1.  Report in Evolve - User history in Evolve

    Posted 06-17-2025 10:58

    Hi, I need a report that can pull user information as: Username, email, creation date in evolve site, license assigned to the user, Assigned date of the license to user and which user did this operation in evolve.



    ------------------------------
    Ketrine Giha
    Consultant
    PepsiCo (Business Solutions Group)
    Winston Salem
    ------------------------------


  • 2.  RE: Report in Evolve - User history in Evolve

    Employee
    Posted 06-17-2025 11:41

    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.
    ------------------------------

    Original Message