I have a script that revokes logon on firecall users after X days. It will then drop the user 14 days after that. I am looking for the table that contains the flag/field that shows the user was revoked. I want to use this as a check to do a compare.
Hi wambli, DBC.LogonRules view has a column named LogonStatus which contains the flag whether user is granted (G) or revoked (R) logon access.
This view uses information from real table DBC.LogonRuleTbl.
Hi,We have checked in DBC.LogonRules but we are unable to retrieve the information for all users,can you or anyone can help me how to get the information
You typically don't have LogonRules for every user; there are generic / "wild card" rules as well. The search order is: