Macromedia breeze-managing external breeze reports User Manual
14
Using Breeze Reporting Views
EXT_USERS
This view lists users and associated profile attributes. The EXT_USERS view uses data listed
in the following table:
in the following table:
Data is generated in this view whenever a user creates, updates or deletes a user.
EXT_USERS sample entries
Constraints
The EXT_USERS view excludes the following fields:
■
Password, which is not stored in plain text
■
Time zone and language, which are not available in human readable form. For example,
PST is 323.
PST is 323.
■
Last login, which is too resource-intensive to calculate. Instead, you can retrieve this data
using a max(date_visited) query from the EXT_TRANSACTIONS view.
using a max(date_visited) query from the EXT_TRANSACTIONS view.
■
Active session, which is data from the EXT_TRANSACTION view. Instead, you can
retrieve this data by executing a STATUS='IN-PROGRESS' query.
retrieve this data by executing a STATUS='IN-PROGRESS' query.
Column name
Data type
Description
LOGIN
NVARCHAR
Unique user identifier.
NAME
NVARCHAR
Unique user name.
EMAIL
NVARCHAR
User’s unique email address.
MANAGER
NVARCHAR
The login of the user’s manager. Manager is always
set to NULL in version 5.1.
set to NULL in version 5.1.
TYPE
NVARCHAR
User or guest. Type is always set to user in version 5.1.
LOGIN
NAME
EMAIL
MANAGER
TYPE
brice@adobe.com
system admin
brice@adobe.com
(null)
user
ccarr@adobe.com
IT manager
ccarr@adobe.com
(null)
user
NO
T
E
Deleted users do not appear in the EXT_USERS view. Deleted users continue to exist in
the EXT_TRANSACTION view.
the EXT_TRANSACTION view.