10-23-2017 12:03 PM
I recently got a request from higher authorities to prepare a report on what SAS products are accessible/ available to sas users in a given environment. I did some research on this but didn't find much help. I want a report something like this,
UserName SAS Products
user_xyz SAS Visual Analytics
SAS Enterprise Guide
SAS Data Integration Studio
user_123 SAS Report Viewer
user_abc SAS Business Data Network
SAS DataFlux Data Management Studio
I know there are reports available that lists out the users roles and groups but I didn't find anything close to this one.
Any help would be greatly appreciated.
10-24-2017 02:50 PM
10-23-2017 12:20 PM
One quick one I can think about....
If you look at the Metadata server log, it will show you user x connected from IP 188.8.131.52 using application SAS Enterprise Guide, for example. You can start forming a picture from extracting those entries out of the log.
10-23-2017 02:56 PM
Just bear in mind, there are two dimensions here:
1.) What software users have ACCESS to
2.) What software users actually USE
Your question seems to point to 1.), just make sure which question you're trying to answer since the answers are quite different.
'higher authorities' normally wants to know about 2.) since they want to chop on licencing costs. Techies normally want to know about 1.) since they want to give their users the best possible experience.
10-23-2017 04:03 PM
10-23-2017 03:08 PM
I would start by looking at what SAS products you have licensed versus those that are installed. The SETINIT and PRODUCT_STATUS procedures can provide this info. Users can only use products that are both licensed and installed.
10-23-2017 04:41 PM
10-24-2017 01:23 AM
Also have a look at your licensing agreement with SAS. Regardless of what the user physically have access to, there might be products and features that you are not aware of or have special conditions. Sometimes there are licensing restrictions where product X may only be used in a certain context/use case, although the product can do more technically. Engage with you SAS Account Executive on this.
10-24-2017 03:19 AM - edited 10-24-2017 03:22 AM
what you need is a list of memberships for all your metadata-defined Roles/Capabilities. I can imagine 3 ways to get this information. Let me list them from the most complex/manual to the easiest and automatic.
Hope it helps.
10-24-2017 02:50 PM
10-25-2017 07:02 AM - edited 10-25-2017 07:08 AM
I agree with @JuanS_OCS , Metacoda SMC plug-in for Roles & capabilities is a must-have tool.
As pointed out by @nhvdwalt above, defining the scope of access to SAS software, to any software more generally is sometimes tricky because
there is not a single definition that applies, from broad to narrower :
1. "Local Installation" [in the case of desktop tools] the software is installed locally on the users PC and ready to be used
=> Check with your Desktop Admin team to retrieve the list of installations
2. "Authorization" : the user is authorized by the SAS Administrator to run the SAS client
=> Use Metacoda SMC Plug-In mentioned by @JuanS_OCS
3. "Effective Usage" : the user has already used at least once the SAS client
=> Use SAS platform Audit reports and maybe soon, some Metacoda extended features
The three scopes are never identical, at least in the real world I know
In terms of contract between the user's company and SAS, as far as I know, the 1st definition applies.
Then internally, the company/service might have set up deployment quotas to further restrict the access. Eventually,
some security rule at the Directory level (AD) might also apply : an unused account is automatically revoked for instance if no access has been performed during a certain amont of time etc.
Need further help from the community? Please ask a new question.