A custom query report showing users who have not logged and changed their password in the last 90 days.
The implemented filters:
Account Disabled equals 'FALSE' AND
Password Can Expire equals 'TRUE' AND
(Last Password Change is null OR…
A custom query report showing users who have not logged and changed their password in the last 90 days.
The implemented filters:
Account Disabled equals 'FALSE' AND
Password Can Expire equals 'TRUE' AND
(Last Password Change is null OR…
It is just an example of creating a custom query report that uses OR in the WHERE clause. The current 2.5 (and apparently 2.6) version of ER does not support an automatic OR clause. That is why a custom query report may have come in handy to overcome…
This Custom query report has been created to display "Domain Users" information for all the users with Employee ID as NULL or Empty String or any User Supplied Value.
You will need to run the SQL queries inside the "SQL_To_Execute.txt" file…