topic Re: Report of Stored Processes currently being used in Administration and Deployment

Report of Stored Processes currently being used

LisaSAS — Mon, 14 Mar 2022 15:54:24 GMT

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

Re: Report of Stored Processes currently being used

AhmedAl_Attar — Mon, 14 Mar 2022 16:40:56 GMT

Hi @LisaSAS

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

SAS Environment Manager Report Center
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

Re: Report of Stored Processes currently being used

AllanBowe — Tue, 15 Mar 2022 09:48:04 GMT

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