GUEST/IDM/CONNECT

Warning

Customer Notice – Upcoming Infrastructure Change for IDM (Effective from Release 2.3.0)

Warning

This release requires additional Release steps:

USE CONNECT 
GO 


CREATE NONCLUSTERED INDEX
 IX_identity_access_group_audit_group_campaign_status  
ON [projection].[identity_access_group_audit] (group_id, 
audit_campaign_agg_root_Id, [status])  
INCLUDE (department)

Warning

This release requires additional rollback steps:

USE [vms]
GO

-- 1. Recreate the TableCREATE TABLE [projection].[compliance_fips201_report](	
[id] [bigint] IDENTITY(1,1) NOT NULL PRIMARY KEY,	
[group_id] [uniqueidentifier] NOT NULL,	
[visit_id] [uniqueidentifier] NOT NULL,	
[hostid] [uniqueidentifier] NOT NULL,	
[visitor_id] [uniqueidentifier] NOT NULL,	
[site_code] nvarchar NOT NULL,	
[change_date] [datetime] NOT NULL,	
[change] nvarchar NOT NULL,	
[change_details] nvarchar NULL,	
[visitor_first_name] nvarchar NOT NULL,	
[visitor_last_name] nvarchar NOT NULL,	
[active_date] [datetime] NOT NULL,	
[inactive_date] [datetime] NOT NULL,	
[authorized_by] nvarchar NULL,	
[authorizor_company] nvarchar NOT NULL,
[access_code_name] nvarchar NOT NULL,	
[sequence] nvarchar NOT NULL,	
[aggregate_root_id] [uniqueidentifier] NOT NULL,	
[visitor_company] nvarchar NULL,	
[visit_badge_template] nvarchar NULL,	
[visitor_credential_number] varchar NULL,
)
GO
-- 2. Recreate IndexesCREATE NONCLUSTERED INDEX [IX_access_code_name] ON [projection].
[compliance_fips201_report]
(
    [access_code_name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX 
[IX_compliance_fips201_update_inactive_covering] ON [projection].
[compliance_fips201_report]
(	
    [group_id] ASC,
    [visit_id] ASC,	
    [access_code_name] ASC,	
    [inactive_date] DESC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

Warning

Customers who utilize firewalls for their Amag.Symmetry.Client will be required to update rules to allow TCP port 5671, 5672 & 443.