Mismatch in SAP usage data report in Saviynt and SAP

[reshma_sonawane]

Hi Team,

We have configured SAP usage data report in Saviynt using analytics. When we compared data with report from SAP, we found mismatch of data and also data missing. Can you please help to understand what is missing in this.

We are using below query in the analytics to get this data.

query:

select distinct (select a.name from accounts a where a.accountkey=ua.accountkey) as 'SAP USER ID',
CASE
WHEN et.endpointkey=13 THEN 'SAP ECC QA'
END AS 'Endpoint',
eu.STARTDATE, eu.ENDDATE,ev.entitlement_value,eu.USAGEVALUE,eu.USAGE_PERIOD,u.username from entitlement_usage eu
join user_accounts ua on ua.accountkey = eu.accountkey
join users u on u.userkey = ua.userkey
join entitlement_values ev on ev.entitlement_valuekey= eu.entitlement_valuekey
join entitlement_types et on et.entitlementtypekey=ev.entitlementtypekey
WHERE et.endpointkey=13 and eu.startdate >= date_sub(NOW(),interval 1 MONTH)

For comparison we asked customer to perform some transaction in SAP which can be captured in SAviynt report. However when we ran the report, those transactions were missing in the report.

[rushikeshvartak]

Did you ran import post transactions 

[reshma_sonawane]

Yes. Import job is schedule to run daily. Transaction was executed on 27th Dec and when we executed report today, we still dint see entry for 27th Dec.

[reshma_sonawane]

Any pointers on this?

[rushikeshvartak]

Does required table is included during import