System Views

SYS_AccessGroups

Returns information about all Access Groups.

Example

SELECT [AccessGroupID]
      ,[Name]
      ,[Type]
  FROM [SYS_AccessGroups]

SYS_Objects

Returns information about Solution objects.

Example

SELECT [ObjectID]
      ,[Name]
      ,[SolutionID]
      ,[ObjectType]
      ,[ObjectSubType]
      ,[WorkProcess_ID]
      ,[WorkProcess_Name]
      ,[WorkProcessVersion_ID]
      ,[WorkProcessVersion_Name]
  FROM [SYS_Objects]

SYS_ObjectPermissions

Returns information about published user permissions on Solution objects.

Example

SELECT [UserUID]
      ,[UserName]
      ,[ObjectID]
      ,[ObjectName]
      ,[ObjectType]
      ,[SolutionID]
      ,[HasAccess]
  FROM [SYS_ObjectPermissions]

Example

SELECT HasAccess 
FROM SYS_ObjectPermissions 
WHERE UserUID = 'user id' AND ObjectID = 'object id'

SYS_WorkProcessVersions

Returns information about Work Processes and Work Process Versions.

Example

SELECT [WorkProcess_ID]
      ,[WorkProcess_Name]
      ,[WorkProcessVersion_ID]
      ,[WorkProcessVersion_Name]
  FROM [SYS_WorkProcessVersions]

SYS_Solutions

Returns information about Solutions.

Example

SELECT [SolutionID]
      ,[Name]
      ,[WorkProcess_ID]
      ,[WorkProcess_Name]
      ,[WorkProcessVersion_ID]
      ,[WorkProcessVersion_Name]
  FROM [SYS_Solutions]

SYS_Tables

Returns information about all tables and views in Solutions.

Example

SELECT [TableName]
      ,[ObjectID]
      ,[SolutionID]
      ,[MetaType]
      ,[TableType]
      ,[WorkProcess_ID]
      ,[WorkProcess_Name]
      ,[WorkProcessVersion_ID]
      ,[WorkProcessVersion_Name]
  FROM [SYS_Tables]