
There are many different users who access iVend HO MC from different machines & their machine regional settings are different but it is difficult to identify which machines are casusing or generating incorrect licenses information
There is below SQL Trigger which can be used to find the same
1.CREATE TABLE [dbo].[Custom_Customer_tblTriggerAuditRecord]([HostName] [varchar](100) NULL,
[UpdatedDate] [datetime] NULL,[UpdatedBy] [varchar](100) NULL) ON [PRIMARY]
2.ALTER TABLE [dbo].[Custom_Customer_tblTriggerAuditRecord] ADD DEFAULT (getdate()) FOR [UpdatedDate]
3.create trigger Custom_Customer_trgTriggerAuditRecord on SysSystemInformation after update, insert as
begin
insert into Custom_Customer_tblTriggerAuditRecord (HostName, UpdatedBy) Select Host_Name(), SUSER_SNAME()
end