Hello,
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
Date | Time | User | SAS Application |
mm-dd-yy | 00:00 | Abc | SAS EG |
mm-dd-yy | 00:00 | Def | SAS FS |
I hope SAS admin experts can help me with this report.
Thanks in Advance.
Hi @pavithra
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:
Using the SAS Environment Manager Report Center to Explore Auditing Data (Youtube video)
Opening Up the SAS Environment Manager Report Center
Auditing using the SAS Environment Manager Report Center– tips and tricks
Hope that helps.
Cheers,
Damo
Hi Damo,
Thanks for the reply.
Can we able to get CPU usage for a particular SAS Job?
Hi @pavithra
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.
Cheers,
Damo
Hello @pavithra,
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.
Kind regards,
Juan
Hello @JuanS_OCS
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?
Thanks.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.