Report of Stored Processes currently being used

[LisaSAS]

How can I create a list of current stored processes that indicates when they were last accessed and all the tables that are being used for each of the stored processes?  I'm needing;

name & location of SP

Date and user that last executed SP

All tables used within the SP

[AhmedAl_Attar]

Hi @LisaSAS 

I think the answer to requirements could be achieved by looking at what you can combine from

• SAS Environment Manager Report Center 
  • Understanding SAS Environment Manager Service Architecture 
  • https://video.sas.com/detail/video/5028160451001/using-the-sas-environment-manager-report-center-to-...
  • https://youtu.be/AYhhhOC9JJk
• SAS Audit Logging
  • https://www.lexjansen.com/nesug/nesug12/ff/ff09.pdf
  • SAS® 9.4 Logging: Configuration and Programming Reference, Second Edition

Hope this helps,

Ahmed

[AllanBowe]

It doesn't solve the table access requirement, but the following could be a helpful 'shot gun' approach to STP logging:  https://rawsas.com/event-logging-of-stored-process-server-sessions/

If you'd like to track and control (manual) changes to tables in SAS, our team also produces this product, which is free for 5 users:  https://datacontroller.io