Restituisci
-
Titolo
How to generate a report to get list of users along with Account CREATION Date? -
Descrizione
We would like to generate a report with the list of Stat users along with their account CREATION DATE rather than the account password change or last updated time. Is there any way to generate that report in Stat 5.8.0? -
Causa
Unfortunately Stat has not that field information in statuser table. -
Risoluzione
Solution 1:Log an enhancement request for this feature, visiting the Stat Community Idea portal at http://communities.quest.com/community/stat?view=idea.Solution 2:Try to extract that information querying the Stat_audit table. For example:select regexp_substr(to_value,'([A-Z]+)',1,2) as stat_user, run_dtfrom stat_auditwhere tbl_name = 'STATUSER'and run_action = 'I'