none
Text values for GRP_QUEUE_MESSAGE_TYPE RRS feed

  • Question

  • Hello,

    GRP_QUEUE_MESSAGE_TYPE is a column in the MSP_QUEUE_PROJECT_GROUP and ARCHIVE table. 

    It provides a numeric value for each type of job that appears in the queue. 

    For example, "Project Save from Project Professional" is 1,  "Project Publish" is 24, and "Reporting(Project Publish)" is 39. 

    However, these are only the ones I've been able to guess by looking at what's in the queue currently and what's in the table at that time.  Is there a lookup table for these numerical values that I can join on to get text instead of a numeric code? We are trying to develop an sharepoint report that will show us MSP processing metrics using queue data.

    FYI- Here is what I have already:

    49  - Reporting(Project Sync)
    105 - Project Workflow Check-in
    15  - Project Site Create
    39  - Reporting(Project Publish)
    21  - Project Checkin
    24  - Project Publish
    30  - Project Publish Notifications
    1   - Project Save from Project Professional

    Tuesday, March 6, 2012 8:21 PM

All replies