Trigger on License information

Trigger on License information

------------------This article is for only internal use ------------------------

Product version:          

iVend 6.6 With SAPB1 10

Problem statement:

User got the license expiry message however licenses were valid with their date.

Symptoms:

There are many different users who access iVend HO MC from different machines & their machine regional settings are different.

Proposed Solution/Workaround:


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

It should be deployed after discussing with L3 team