Users
Query users for a SAP Business Objects BI instance.
To create Users make use of the CreateUser stored procedure.
Select
The following queries are processed server-side:
SELECT * FROM USERS
SELECT Id, Name FROM Users ORDER BY ID
SELECT Id, Name FROM Users ORDER BY ID DESC
SELECT * FROM Users WHERE ParentId=18
SELECT * FROM Users WHERE ParentId=19 AND FullName='test'
SELECT * FROM Users WHERE Updated > '2025-02-06T08:35:00.000-05:00'
SELECT * FROM Users WHERE Updated >= '2025-02-06T08:35:00.000-05:00'
Delete
DELETE FROM Users WHERE ID=8596
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | False |
The user ID. |
| CUID | String | False |
The user cluster unique ID. |
| Name | String | False |
The name of the user. |
| FullName | String | False |
The full name of the user. |
| Description | String | False |
The description of the user. |
| Type | String | False |
The type of the user. |
| OwnerId | String | False |
The user owner ID. |
| ParentId | String | False |
The user parent ID. |
| Updated | Datetime | False |
The date time when the user was last updated. |