Reference ZenDesk Ticket: 1544770

Description: Samara Nour has no reports visible within iZone IRP under the Reporting System Module

Troubleshooting:

--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]'

Solution:

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.

use irp

begin tran

INSERT INTO rstmusertabmapping (USERID, TABNAME, CREATEDBY, CREATEDATE, LASTMODIFIEDBY, LASTMODIFIEDDATE) VALUES

('115957', 'Team', 'slumbania', getdate(),'slumbania', getdate()),

if @@ERROR > 0 or @@ROWCOUNT <> 1

BEGIN

ROLLBACK TRAN

RETURN

END

commit tran

print 'DBCR script completed successfully'

Note:  There are 6 types of reporting tabs available. Each tab will require an individual entry in rstmusertabmapping table

Admin
Team
Supervisor/TL
Internal Audit
Client Services
TPSP