October 2018

If you do not have a SAMPLE DB create one in the system manager. DELETE FROM ExactMAXyourdb..MAX_Security where USERNAME_82 = ‘MANAGER’ INSERT INTO ExactMAXYOURdb..MAX_Security ( [USERNAME_82] ,[PASSWORD_82] ,[MODULE_82] ,[LOGIN_82] ,[FEATURES_82] ,[SYNUSER_82] ,[SYNPASSW_82] ,[CONVERT_82] ,[CreatedBy] ,[CreationDate] ,[ModifiedBy] ,[ModificationDate] ,[DOMAINNAME_82]) SELECT * FROM ExactMAXSAM..MAX_Security

Here it is. Create a SQL Job that executes this to clear users that have logged off. USE ExactMAX DELETE FROM ERMUD where MachineName not in (select distinct(hostname) from master.dbo.sysprocesses where program_name=’Exact MAX’) AND MachineName not like ‘%##Terminal##%’ and CompanyName not like ‘%-##-%’