Community Forums
Results 1 to 4 of 4

Thread: Application Familiy

  1. #1
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51

    Application Familiy

    I'm using WFM 2014 and trying to locate where in the database it stores the Application Family. This is entered when you first submit a new workflow request, and then is displayed on the Project Summary screen, but I can't seem to locate this field in the database to write a custom SQL report. In the attached images, WFM1 shows the Submit Workflow screen and WFM2 shows the Project Summary screen. In my case, the display name for the field has been changed from Application Family to OpCo.
    Attached Images Attached Images   

  2. #2
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51
    I've found the definitions of the families in the AMS_Containers table, but can't seem to figure out where this is tied to AMS_Applications so that I can query on it.

  3. #3
    Join Date
    Oct 2007
    Location
    Schaumburg, IL
    Posts
    318
    Hi,

    The ContainerObjectGUID column in the AMS_ContainerEntries table is the ApplicationID from the AMS_Application table. This should help you to find the family name.

    Hope this helps.

    Thanks!
    Alpesh
    Flexera Software Technical Support

  4. #4
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51
    Perfect!! Thank you Alpesh!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •