What/ Who is using LASR server tables?

[Alok_Pal]

We have a lot of table sitting on LASR server and we obviously want to do some clean up. But, before we go about cleaning up LASR server I would like to know what jobs, procs, programs, person or object is using those LASR tables. It would help us making decision about what tables can be dropped from LASR. I tried bunch of stuffs and for some of the LASR tables I got the list of jobs that are using them. But there are still a lot of tables for which I believe there's no DIS job that are using them. Just wondering if there's a easy way to answer following questions about these LASR tables. Who created these tables? What objects are using these tables (i.e. DIS job, stored procedure, sas program etc.) ? How frequently they are referenced/ used? What tables are never referenced/ used by anyone?

Any help will be greatly appreciated.

Thank you.

[alexal]

@Alok_Pal,

That can be easily identified if you started the LASR server with a "logging" option. In that case, you can examine the LASR server log file and see who, when, and how often started the actions on the LASR tables. A while ago I've built the utility for parsing the LASR logs, I can upload it to GitHub if you want.

[Alok_Pal]

Yes, please do that. That would really help.

Thank you.

[alexal]

@Alok_Pal,

LASRLog.py

[Alok_Pal]

Thanks alexal. I may be asking for too much but is it possible to get a readme file or any documentation about how to execute this code.

[alexal]

@Alok_Pal,

For example:

python3.6 lasrlog.py /Users/alexal/Downloads/LASR.1332805759.98431.saslasr.log 20

This command prints 20 actions from the log sorted by run time. 

usage: lasrlog.py [-h] [-c HOWMANY]
[-s {id,pid,sastime,time,user,rawcmd,tablename,statusmsg,runtime}]
[-r REVERSE] [-g GREATERTHAN] [-coloring COLORING]
file

positional arguments:
file The path to actions file

optional arguments:
-h, --help show this help message and exit
-c HOWMANY, --howmany HOWMANY
How many actions needs to be printed after sorting? By
default 10.
-s {id,pid,sastime,time,user,rawcmd,tablename,statusmsg,runtime}, --sortby {id,pid,sastime,time,user,rawcmd,tablename,statusmsg,runtime}
Sort by specific field. By default sorting by runtime.
Possible values are: id, pid, sastime, time, user,
rawcmd, tablename, statusmsg, runtime
-r REVERSE, --reverse REVERSE
This is using to flag descending sorts (boolean
value), by default True.
-g GREATERTHAN, --greaterthan GREATERTHAN
Print actions with run time greater or equals
specified value
-coloring COLORING, --coloring COLORING

[BrunoMueller]

Hi

Also have a look at the VA Admin Guide http://support.sas.com/documentation/onlinedoc/va/7.3/en/vaag.pdf on page 121 it gives you more information about predefined admin reports and how to switch on the data collection.

[Alok_Pal]

Thanks Bruno_SAS. That was really helpful.