Forum Discussion

Olivierln's avatar
Olivierln
Frequent Visitor
3 years ago

Documentationt - TMSCHEMA_ROLE_MEMBERSHIPS - Value description

Hi Community,   I working on automatic documentation using DMV (such as Data Marc and Data gods did), and working on the role part, there is something I am wondering :  On the TMSCHEMA_ROLE_MEMBER...
Need Help
Olivierln's avatar
Olivierln
Frequent Visitor
3 years ago

Hi,

when querying the schema with the following sql 

= AnalysisServices.Database(
    Server,
    DBName,
    [
      Query
        = "Select [ID], [RoleID], [MemberName], [MemberID], IdentityProvider, MemberType, ModifiedTime from $SYSTEM.TMSCHEMA_ROLE_MEMBERSHIPS"
    ]
  )

 

On the column MemberType, i do have an integer as a result

 

I would like to get the meaning of the id since this is not documented

 

 

Best Regards

 

Olivier