and more in a single search tool across platforms. Read the announcement here. |
01/03/2024 05:00 AM
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.
01/03/2024 05:05 AM
Did you ran import post transactions
01/03/2024 05:23 AM
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.
01/03/2024 11:24 PM
Any pointers on this?
01/04/2024 04:21 AM
Does required table is included during import