lcc:debugLevel	1	Program start/finish
	lcc:debugLevel	2	Logic File Records
	lcc:debugLevel	3	Logic File Key/Values
	lcc:debugLevel	4	Logic File Valid Key/Values
	lcc:debugLevel	5	Logic File Skips
lcc:debugLevel	6	Output File - Filename
lcc:debugLevel	7	Running Command
	lcc:debugLevel	8	Start/End Date Checks
	lcc:debugLevel	9	Valid records
	
lcc:sourceEncryptedPasswordHash	s0m3C00lPhr@$e
lcc:sourceEncryptedSaltKey	s0m3C00lPhr@$e
lcc:sourceEncryptedVIKey	s0m3C00lPhr@$e12

lcc:connectionDriver	{MySQL ODBC 5.3 ANSI Driver}
lcc:connectionServer	[...your server...]
lcc:connectionServerPort	3306
lcc:connectionDatabase	ORG1
lcc:connectionUser	[lcc:encrypted][...your encrypted user id...]
lcc:connectionPassword	[lcc:encrypted][...your encrypted user password...]

lcc:command	SELECT C.TABLE_NAME,CONCAT(C.TABLE_NAME, '.', C.COLUMN_NAME) AS PRIMARY_KEYS FROM INFORMATION_SCHEMA.COLUMNS C WHERE TABLE_SCHEMA = 'ORG1' AND COLUMN_KEY = 'pri';
lcc:outputFile	kaceData-baselinePrimaryKeys.txt

lcc:command	SHOW TABLES;
lcc:outputFile	kaceData-tables.txt

lcc:command	SHOW FULL TABLES IN ORG1 WHERE TABLE_TYPE LIKE 'VIEW';
lcc:outputFile	kaceData-views.txt

lcc:command	SHOW PROCEDURE STATUS;
lcc:outputFile	kaceData-procedures.txt

lcc:command	SHOW FUNCTION STATUS;
lcc:outputFile	kaceData-functionStatus.txt

lcc:command	SELECT * FROM USER;
lcc:outputFile	kaceData-user.txt

lcc:command	SELECT * FROM ASSET;
lcc:outputFile	kaceData-asset.txt

lcc:command	SELECT * FROM HD_TICKET;
lcc:commandFlag	1	HD_TICKET	// retrieve and display column names
lcc:outputFile	kaceData-hd_ticket.txt

lcc:command	SHOW COLUMNS FROM ORG1.HD_TICKET;
lcc:outputFile	kaceData-hd_ticket-columns.txt

lcc:command	SELECT * FROM HD_WORK;
lcc:outputFile	kaceData-hd_work.txt

lcc:command	SELECT * FROM MACHINE_ACTIONS;
lcc:outputFile	kaceData-machine_actions.txt

lcc:command	SELECT C.TABLE_NAME,
lcc:commandAppend	(CASE WHEN PK.PRIMARY_KEYS IS NULL THEN 'N/A'
lcc:commandAppend	ELSE GROUP_CONCAT(DISTINCT PK.PRIMARY_KEYS ORDER BY 1 SEPARATOR '\n') END) AS PRIMARY_KEYS,
lcc:commandAppend	(CASE WHEN FK.FOREIGN_KEYS IS NULL THEN 'N/A'
lcc:commandAppend	ELSE GROUP_CONCAT(DISTINCT FK.FOREIGN_KEYS ORDER BY 1 SEPARATOR '\n') END) AS FOREIGN_KEYS
lcc:commandAppend	FROM INFORMATION_SCHEMA.COLUMNS C
lcc:commandAppend	LEFT JOIN
lcc:commandAppend	 (SELECT C.TABLE_NAME,
lcc:commandAppend	  CONCAT(C.TABLE_NAME, '.', C.COLUMN_NAME) AS PRIMARY_KEYS
lcc:commandAppend	  FROM INFORMATION_SCHEMA.COLUMNS C
lcc:commandAppend	  WHERE TABLE_SCHEMA = 'ORG1'
lcc:commandAppend	  AND COLUMN_KEY = 'pri')
lcc:commandAppend	PK ON PK.TABLE_NAME = C.TABLE_NAME
lcc:commandAppend	LEFT JOIN
lcc:commandAppend	 (SELECT C.TABLE_NAME,
lcc:commandAppend	  CONCAT(C.TABLE_NAME, '.', C.COLUMN_NAME) AS FOREIGN_KEYS
lcc:commandAppend	  FROM INFORMATION_SCHEMA.COLUMNS C
lcc:commandAppend	  WHERE TABLE_SCHEMA = 'ORG1'
lcc:commandAppend	  AND COLUMN_KEY != 'pri'
lcc:commandAppend	  AND COLUMN_NAME rlike '_ID')
lcc:commandAppend	FK ON FK.TABLE_NAME = C.TABLE_NAME
lcc:commandAppend	WHERE TABLE_SCHEMA = 'ORG1'
lcc:commandAppend	GROUP BY C.TABLE_NAME
lcc:commandAppend	ORDER BY C.TABLE_NAME, PK.PRIMARY_KEYS, FK.FOREIGN_KEYS
lcc:outputFile	kaceData-keysRelationships.txt