01-08-2018 02:51 PM
I am trying to get Monthly report of all sas users with access to SAS and installed sas tools and utilization of all the SAS application, when do they run, how often, by whom information. I have been looking & googling SAS documents & could not able to find the answer except these below 3 options,
1. Enable SAS environment manager extended monitoring.
2. Metacoda plug-in
3. Enterprise Session Monitor
When i enable SAS Environment manager extended monitor most of the reports from report center are not straight forward.
All i am trying is to get report something like below
I hope SAS admin experts can help me with this report.
Thanks in Advance.
01-09-2018 04:52 AM
The SAS Environment Manager might definitively help you, the list of default reports is available here.
The ARM report Server Usage By User could be a strating point.
You would also have to create your own report as per Adding Reports to the Report Center.
Contents build by @DaveNaden might assist you:
Hope that helps.
01-10-2018 03:33 AM
From the first link I provided, you'll find the list of existing "out of the box" reports.
One is about "Top 5 Ranked on CPU Usage" so starting from that one, you should be able to get what you want.
01-10-2018 04:13 AM
to achieve the task you are aiming for, you probably will need a mix of solutions, depending on what you would like to monitor.
Based on resources usage by job, probably you should go for Enterprise Session Monitor by @boemskats or SAS Environment Manager. Just remember that the SAS Environment Manager is a great tool for analysis on performance, more for SAS services than SAS jobs, but it probably should not be your main monitoring tool since it depends on metadata, WIP and Middle tier to be UP.
I will also give you some additional tips.
Again, I think for your purposes, the quickest solution will probably be a mix of solutions. Environment Manager and EMI Framework can be set up within half of a day, and ESM (Enterprise Session Monitor) in another day, then you can customize them as much as you want.
PS. You mentioned Metacoda. While a great tool, very recommended, It is metadata based, it won't help you with the monitor of jobs, only visibility on metadata and audit the metadata, hence, not answering this particular question.
Hope it helps.
01-10-2018 09:17 AM
SAS Environment manager can be setup to get the reports. But i believe Enterprise Session Monitor tool is additional license cost.
As you mentioned using Environment manger report center I can't get data for EG/FS application jobs. For this reports i have to phrase the logs from workspace server.
Do you have experience to query workspace server/metadata server logs?