Query to check users who have been logging into the Erwin r9 Mart or who have current sessions running Matt Russo Updated June 30, 2017 20:39 Follow Select a.Username,b.S_Machine,b.S_Start,b.S_EndFrom m9User a,m9Session bWHERE a.UserId = b.U_Id Related articles erwin Data Modeler 9.7 Product Documentation Is there a query that will give me all the library, model, and table names for an r9.6 and later mart? If I have erwin Data Modeler 32-bit and 64-bit, should I have the erwin MartServer 32-bit or 64-bit installed? erwin Data Modeler : you can use the user-defined property (UDP) macro functions to display UDP values in models, triggers, and stored procedures. What kind of macros are available for each model object class that supports UDPs? Documentation to understand the data model and data structures in the r8 Model Manager mart database for SQL querying Comments 0 comments Please sign in to leave a comment.