labtech Database

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
v_usageperiods	View	(MINUTE(dateexecuted) DIV 5)	INT	10	√		null
v_extradatalocations	Table	1 - Patch Day VM Host Role	LONGTEXT	2147483647			null
v_extradatalocations	Table	2 - Patch Day SBS Role	LONGTEXT	2147483647			null
v_extradatalocations	Table	3 - Patch Day Domain Controller Role	LONGTEXT	2147483647			null
inv_systemslots	Table	3.3Volts	TINYINT	3			null
v_extradatalocations	Table	4 - Patch Day Exchange/MSSQL Roles	LONGTEXT	2147483647			null
v_extradatalocations	Table	5 - Patch Day Other Window Server Roles	LONGTEXT	2147483647			null
inv_systemslots	Table	5.0Volts	TINYINT	3			null
inv_processor	Table	64bit	TINYINT	3			null
v_processors	View	64bit	TINYINT	3			null
inv_operatingsystem	Table	64Bit	TINYINT	3			null
patchjobs	Table	Aborted	INT	10			null
patchjobreboots	Table	Aborted	INT	10			null
automate_api_security	Table	AbsoluteExpirationDate	DATETIME	19			null	UTC
v_extradatacomputers	Table	Access Control	LONGTEXT	2147483647			null
mobiledeviceinfo	Table	Accessibility	TINYINT	3			null
networkdevices	Table	AccessPasswordId	INT	10			0
mobileconfigclassvpn	Table	Account	VARCHAR	254			null
config	Table	AccountFlags	INT	10			0
mobileconfigclassexchange	Table	AccountName	VARCHAR	50			null
mobileconfigclassemail	Table	AccountName	VARCHAR	100			null
mobileconfigclassemail	Table	AccountType	INT	10			null
agentcommands	Table	ACID	INT	10		√	null
ltantivirusthreats	Table	Ack	INT	10	√		null
inv_bios	Table	ACPISupport	TINYINT	3			null
signupdata	Table	Action	INT	10	√		null
computermenus	Table	Action	VARCHAR	15			null
v_setpatches	View	Action	INT	10			null
h_apps	Table	Action	INT	10			null
patchapprovalsettings	Table	Action	INT	10			null
v_softwarehistory	View	Action	INT	10			null
hotfix	Table	Action	INT	10			-1
cacheactions	Table	Action	INT	10			null
h_processes	Table	Action	INT	10			null
scriptsteps	Table	Action	INT	10			null
ltantivirusthreats	Table	Action	VARCHAR	150	√		null
patchhistory	Table	ActionDate	DATETIME	19			null
h_agentsignup	Table	ActionDate	DATETIME	19			null
signupdata	Table	ActionDate	DATETIME	19	√		null
auditactions_plugins	Table	ActionID	INT	10			null
h_license	Table	ActionId	INT	10			null
auditactions	Table	ActionID	INT	10		√	null
l_licenseaction	Table	ActionId	INT	10			null
l_licenseaction	Table	ActionName	VARCHAR	50			null
antivirusthreats	Table	ActionTaken	VARCHAR	1000			null
v_ltcr_avthreatevents	View	ActionTaken	TEXT	65535	√		null
v_xr_avthreatevents	View	ActionTaken	TEXT	65535	√		null
antivirusthreats	Table	ActionTakenLookupCategoryID	INT	10			null
antivirusthreatactiontakenlookup	Table	ActionTakenLookupID	INT	10			null
antivirusthreatactiontakenlookup	Table	ActionTakenLookupName	VARCHAR	50			null

Showing 1 to 50 of 8,355 entries