topic Re: Reporting SAS system utilization data in Administration and Deployment

Reporting SAS system utilization data

DanielleCW — Wed, 25 Nov 2020 22:07:58 GMT

I need to be able to report regularly on data like number of users, jobs run, reports, and dashboards and do so a regular intervals for management's insight into utilization of the SAS systems. I'd like to hear more about what others are reporting and how.

The installs are SAS 9 Grid and Viya 3.3. Select products installed are BI Dashboard, DI Studio, Energy Forecasting, Enterprise Miner, QAS, VA and Workload Orchestrator.

Re: Reporting SAS system utilization data

sagar2 — Thu, 26 Nov 2020 05:35:47 GMT

We have enabled CPU Usage, lsload , bhosts utilization.

Re: Reporting SAS system utilization data

JuanS_OCS — Thu, 26 Nov 2020 09:34:03 GMT

Hello @DanielleCW ,

I like very much the systems you have got, SAS Grid and Viya are a perfect match!

For SAS 9.4 Grid, I would say:

If possible, upgrade to latest maintenance to get additional reporting possibilities. As I read you have SWO, I assume you are min in M6. Good!
Exploit the usage of SAS Environment Manager and VAAR (you should have it): in SASEVM you can enable the Extended Monitoring (which will expand the data logged in WIP Auditing and provide you with many APM and ACM reports). In VAAR you can enable the VA Auditing and Administration reports - which, of course you can copy and modify (never modify originals) and distribute as PDF.
For SWO, the best is to use the RestAPI CLI interfaces: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=gridref&docsetTarget=n1mnrcnge82saln1q2tnerrpvclr.htm&locale=en
Furthermore, if you are interested, you could always query WIP or the SASEVM DataMart to build your own reports

For SAS Viya:

I strongly recommend to update to 3.5. If you are in Azure you could give a go to Viya 4 (2020.1) 🙂 The improvements could be sang.
In SAS Viya you have a multitude of pre-built reports already. You can simply publish some or distribute as PDF.
Furthermore, you can always query the internal data of Viya with sas-admin CLI or Rest APIs! https://documentation.sas.com/api/docsets/calcli/3.4/content/calcli.pdf?locale=en

Does it help?

Re: Reporting SAS system utilization data

DanielleCW — Thu, 26 Nov 2020 15:12:12 GMT

Thank you, I will look into this when I am back in after the US holiday.

To clear a couple points: it's currently 9.4M5 and 3.3. There are imminent plans to upgrade with SAS Professional Services handling the 9.4 upgrade to M7 and to be determined who will do the Viya upgrade but there is a good chance I'll be handling that.

Envrionment Manager is one of those products that I used to only ensure was running but otherwise ignored when I worked for SAS Global Hosting so it's interesting to get into it more now (I work for a solutions partner and on contract to a SAS customer.)