1. xMatters
  2. Community
  3. General Q&A

SQL table names for group data

Hiep Banh
Not Yet Reviewed

I'm on Version 4.1.  I got in the SQL DB and want to run a query to list group data (name, membership, schedule).  I could use some help on the table/view names that have the data.  Thanks in advance.

0

Comments

4 comments
Date Votes

Please sign in to leave a comment.

  • Kim Jue

    The names and members should not be too hard, but the schedules are a but deeper

    0
  • Kim Jue

    select g.GRP_ID
    ,g.DESCRION
    ,g.COMPLETE


    ,r.TARGET_NAME
    ,r.RECIPIENT_CAT
    from GRP g
    inner join TM t
    on t.GRP_ID = g.GRP_ID
    inner join TM_MBRSHIPS tm
    on t.TM_ID = tm.TM_ID
    inner join RECIPIENTS r
    on r.RECIPIENT_ID = tm.RECIPIENT_ID

    where g.DELETED_ID = '-1'

    0
  • Kim Jue

    you can get group names in a bit

    0
  • Kim Jue

    this will get the group names:

    select g.GRP_ID
    ,g.DESCRION as "Description"
    ,g.STATUS
    ,r.TARGET_NAME as "Group Name"
    from GRP g
    inner join RECIPIENTS r
    on g.GRP_ID = r.RECIPIENT_ID
    where g.DELETED_ID = '-1'

    0

Didn't find what you were looking for?

New post