Pyxis DB Data questions

* tmpcfg_View - What is the significance of the ViewType column - What are the values and their meaning? 

* tmpcfg_Screen - What is the significance of the ScreenType column- What are the values and their meaning?

* DeviceID - Is there a reference table that translates the DeviceID values in to a device name please?

* tmpsys_UserSession - Is there any way I can link tmpsys_UserSession to TMPMON_MONITOR and match a session's distinct event to its monitor activities?

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    smilliken

    Hi Jeff,

    * tmpcfg_View: Here are the values that are associated with your ViewTypes
    1: Form
    2: List
    4. Dashboard

    *tmpcfg_Screen: Here are the values that are associated with your ScreenTypes
    1: Form
    4: Add
    6: Find
    7: List
    10: Comparison
    11: Calendar
    12: Report
    16: Dashboard
    18: Global Search Results
    20: Upload Status

    *DeviceID: There is currently no table that can translate the DeviceID into a deviceName. Your tmpcfg_User table however does give you the UserID, First Name, Last Name, and platform used.

    *tmpsys_UserSession - If you are looking to monitor a single user's activities you can Join the tmpmon_Monitor table with the tmpmon_UserProfileID. Here is a sample query I created for the user mpdemo:

    select m.RowID, m.UserProfileID, u.UserID, m.ScreenID, m.ViewID, m.ServiceType, m.ScreenHostID, m.RequestDTM
    from dbo.tmpmon_Monitor m
    Join dbo.tmpmon_UserProfile u on u.UserProfileID = m.UserProfileID
    where s.UserID = 'mpdemo'

    Thanks,
    Scott

Please sign in to leave a comment.
Powered by Zendesk