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.

Cmdlets for SAP BusinessObjects BI

Users

Select

Delete

Columns