Query to get all Team names with their member agents in footprints 12.x from SQL database

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    FootPrints


    APPLIES TO:

    FootPrints 12.x - 20.x



    PROBLEM:

    Require a query to get all Team names with their member agents in FootPrints 12.x from SQL database.


    SOLUTION:

    The following query can be used to get the required data - change database name if needed


    select a.user_login,c.team_name, e.string_val as 'User Name' from [fpscdb001_system].[app_user] a
    join [fpscdb001_system].[agent_team] b
    on a.app_user_id=b.app_user_id
    join [fpscdb001_system].[team] c
    on b.team_id=c.team_id
     join fpscdb001_system.app_user_prof_link d on a.app_user_id = d.app_user_id --User Profile
                             join fpscdb001_system.cfg_setting_val e on d.user_prof_id = e.owner_id and e.cfg_setting_id in
                            (select cfg_setting_id from fpscdb001_system.cfg_setting where cfg_setting_const='username')


    Article Number:

    000165292


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles