Business Intelligence (BusinessObjects)
Page tree
Skip to end of metadata
Go to start of metadata

All users

Document2

This report extracts these info about users: Name, ID, FullName, Last Logon Timestamp, Last Timestamp, Email, Aliases properties (SI_DISABLED and SI_NAME), Psw Never expire or subject to expiry, Is Named User

With Input Control on hidden column "DisabledCount" to filter only by SI_DISABLED property and count all DISABLED users (true) or ENABLED users (false).

 

Below screenshots of every query (two in total) used to extract data:

Query1 (All Users):

SELECT
int(Properties.si_id),
flag(Properties.SI_FORCE_PASSWORD_CHANGE),
datetime(Properties.si_update_ts),
flag(Properties.SI_CHANGEPASSWORD),
Properties.si_name,
Properties.si_userfullname,
flag(Properties.si_passwordexpire),
Properties.SI_EMAIL_ADDRESS,
datetime(Properties.si_lastlogontime),
flag(Properties.si_nameduser)
FROM
Properties
WHERE
Properties.si_kind = 'user'

 

Query2 (Tech_info):

SELECT
int(Properties.si_id),
Property(Properties.technical),
PropertyPath(Properties.technical),
PropertyValue(Properties.technical)
FROM
Properties
WHERE
(
int(Properties.si_id) IN (<Id from query All Users>)
AND
Property(Properties.technical) = 'si_id,si_aliases'
)

I use the first query "Environment" in each webi document to obtain the name of the CMS environment I'm exploring :

SELECT
Properties.si_name
FROM
Properties
WHERE
Properties.si_kind = 'EnterpriseNode'

Document biar: Biar_Users_20171127

Guide to construct the document: Users_extraction.docx

  • No labels