custom_proval_computer_new_accounts

Purpose

The table named: custom_proval_computer_new_accounts is built to store all information about the newly created accounts on the server. It is created by a script named: User Management - New Local Account Audit And Disable [DV, Autofix, Global].

Dependencies

• ProVal - Submitted - New Account Detection
• User Management - New Local Account Audit And Disable [DV, Autofix, Global]
• New Account Audit and Disable For Approve [Script]
• User Management - Approved New User - Activate [DV, Param]

Table

custom_proval_computer_new_accounts

Column	Type	Explanation
computerid	INT	Stores the computer ID of the computer.
Creator UserName	VARCHAR	Stores the username of the person who created the new account.
Creator LocalUser	TINYINT	Indicates whether the creator of the new account is local or domain (1 - Local, 0 - Domain).
Creator LocalAdmin	TINYINT	Indicates whether the creator of the new account is an admin or non-admin (1 - Admin, 0 - Non Admin).
Creator LastLogon	DATETIME	Records the creator's last logon date.
Creator Password	TINYINT	Indicates whether the creator has a password set (1 - Yes, 0 - No).
Created Username	VARCHAR	Stores the newly created user account name.
Created LocalUser	TINYINT	Indicates whether the newly created account is local or domain (1 - Local, 0 - Domain).
Created LocalAdmin	TINYINT	Indicates whether the newly created account is an admin or non-admin (1 - Admin, 0 - Non Admin).
Created LastLogon	DATETIME	Records the last logon date of the newly created account. (If the date is 1970-01-01 00:00:00, it means the account has never logged in.)
Created Password	TINYINT	Indicates whether the newly created account has a password set (1 - Yes, 0 - No).
Account Creation Date	DATETIME	Stores the date the account was created.
Disable Status	TINYINT	Indicates whether the newly created account is disabled (0 - New Account Approved, 1 - Disabled, 2 - No Action). Here, 2 means the script that creates this table did not choose to disable the newly created account; it is only meant for auditing the new account.
Approve Status	TINYINT	Indicates whether the account is approved to be enabled (0 - Not Approved, 1 - Approved and Enabled, 2 - No Action).
Approve Date Status	DATETIME	Represents when the newly created account was approved to be enabled. (If the date is 1970-01-01 00:00:00, it means the account is not approved.)