Reports2017-11-18T12:27:27+00:00

DIS Users

Description
Categories: Application, Enginatics
Discoverer end user layer users of different types (application user, responsibility, database user)

select
eeu.eu_id,
xxen_util.disco_user_type(eeu.eu_username) type,
xxen_util.disco_user_name(eeu.eu_username) name,
eqs.access_count,
eqs.last_accessed,
xxen_util.disco_user_name(eeu.eu_created_by) created_by,
eeu.eu_created_date creation_date,
xxen_util.disco_user_name(eeu.eu_updated_by) last_updated_by,
eeu.eu_updated_date last_update_date
from
&eul.eul5_eul_users eeu,
(
select
eqs.qs_created_by,
count(*) access_count,
max(eqs.qs_created_date) last_accessed
from
&eul.eul5_qpp_stats eqs
where
2=2
group by
eqs.qs_created_by
) eqs
where
1=1 and
eeu.eu_username=eqs.qs_created_by(+)
order by
eeu.eu_updated_date desc

Parameter Name SQL text Validation
Show Active Only
eqs.qs_created_by is not null
LOV
End User Layer
<parameter_value>
LOV
Access Count within x Days
eqs.qs_created_date>sysdate-:days
Number

By continuing to use the site, you agree to the use of cookies. Accept