pvl_ad_inactive_users
Purpose
This table stores the data of the inactive users above the threshold gathered by the script Audit - Inactive AD Users - X Days. It also collects information about the inactive user accounts that were enabled or disabled using the scripts Enable - Inactive Disabled AD Users - X Days and Disable - Inactive AD Users - X Days respectively.
Dependencies
- Script - Audit - Inactive AD Users - X Days
- Script - Enable - Inactive Disabled AD Users - X Days
- Script - Disable - Inactive AD Users - X Days
- Solution- Inactive AD Users Disable/Enable
Table
- pvl_ad_inactive_users
pvl_ad_inactive_users
| Column | Type | Explanation |
|---|---|---|
| Computerid | Int | Computerid of the agent |
| UserName | VARCHAR | Inactive username information that hasn't logged in above X days |
| UserSID | VARCHAR | Inactive user SID information that hasn't logged in above X days |
| LastLogonDate | DATETIME | User's last login date in the domain environment |
| DistinguishedName | VARCHAR | It stores the inactive user's uniquely identifying information that is an entry within a directory service |
| Enabled | VARCHAR | It stores the information about the inactive user's state, whether it is enabled or disabled |
| IsExcluded | VARCHAR | It stores the information of the inactive user's that are excluded or not in the Automate |
| UserStatus | VARCHAR | It contains the information of each inactive user that were disabled or enabled. |
| ScriptRanDate | DATETIME | This has the information of the last script run date when the information was collected via scripts . |