Reference ZenDesk Ticket: 1544770
Description: Samara Nour has no reports visible within iZone IRP under the Reporting System Module
--Confirm in IRP DB that the user has an entry in RSTMUserTabMapping.
--In this scenario the user did not have record in the table
select * from RSTMUserTabMapping where userid='[AD_Account]'
Reviewed users initial SAR request by searching Zendesk and found ticket 1493095 which stated to mirror Michelle Brunets access.
-- Checked Michelle's access and can see she has access to the "Team" reports which is specified in the TabName column.
select * from RSTMUserTabMapping where userid='114155'
To insert a record for the user submit the DBCR below.
INSERT INTO rstmusertabmapping (USERID, TABNAME, CREATEDBY, CREATEDATE, LASTMODIFIEDBY, LASTMODIFIEDDATE) VALUES
('115957', 'Team', 'slumbania', getdate(),'slumbania', getdate()),
if @@ERROR > 0 or @@ROWCOUNT <> 1
print 'DBCR script completed successfully'
Note: There are 6 types of reporting tabs available. Each tab will require an individual entry in rstmusertabmapping table