Hana view usage

[werner_dupreez]

Hi, I 've seen some similar questions posted, but no answers unfortunately.

Similar to BW query stats, we are required to identify which views are being used, how often, when and by which users.

Thanks

Werner

[dvankempen · Accepted solution]

Hi Werner,

That is called auditing.

As documented

• Auditing Activity in SAP HANA

Make sure to check the best practices as this sounds like a "firefighting" policy; auditing everything, everywhere, and everyone.

• Best Practices and Recommendations for Creating Audit Policies

The better the focus of your audit, the more useful it will be

[werner_dupreez · Accepted solution]

Thanks Denys, Yes that is the route we are exploring with the table auditing.