List all users and associated session variables

Mahesh KR

Hello Experts,

Is there any way to list-out the users and its associated session variables (with value) information in OBIEE 11G/12C.

Please post your suggestions if anyone came across this similar requirement.

Thanks in advance,

[Deleted User]

Lowest-hanging fruit: OBI system variables overview – Dimensionality

Gianni Ceresa

Hi,

Christian's answer is more for you as the current user.

For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.

If you mean for all the users in general of course it isn't possible as a session variable only exists if there is a session, so you can't list variables which doesn't exist.

[Deleted User]

One reason I also didn't want to go into more detail is that if you script that you are pulling quite a bit of information in a programmatic way which may be security-sensitive so I wouldn't necessarily productize it

Mahesh KR

Thanks for your inputs..

But my requirement is get the session values for all users in a time.Let me check if any way to find the solution.

Thanks.

Gianni Ceresa

Gianni Ceresa wrote:For the current active users connected to the system you can look in the Admintool in the Manage > Sessions menu.

[Deleted User]

Mahesh KR wrote:But my requirement is get the session values for all users in a time.Let me check if any way to find the solution.

That will only work if your program something which logs on a s each users at a time, dumps out all variables, logs on as the next, dumps out variables,... and loops through all users.

Also I find that approach questionable since most variables are totally dynamic in nature. Meaning they can change from login to login even for one given user.

Gianni Ceresa

That's what you get out of the box: take it or leave it (because of all the reasons already posted above)

[Deleted User]

Mahesh KR wrote:But my requirement is get the session values for all users in a time

The OP probably implicitly doesn't mean one by one but in bulk.

Your comment is 1000% valid and what I would do / use too but he probably targets something more global and "less effort" as so often

Gianni Ceresa

I know, but that's why I added the "That's what you get out of the box: take it or leave it" ...

As you said above and I also said: nowhere you find that list in a nicely accessible way. Sessions variable are based on sessions, so to get them all at once it means to code a lot by hand.

And here is the question is: why? Why does someone want the list of variables? Take the init blocks with the queries and problem solved: at any point in time you can get the value of any given variable for any given user. So the need itself has no or little use case also because it depends on the users currently connected.

So out of the box there is that screen for one by one analysis of what are the variables, for all take the init block queries and execute them. Of course if VPD or other strict security is in place then it doesn't work anymore, but here is't maybe better to not have access to that list ...

All in all we are looping again and again: out of the box is one by one, anything else is done by hand.

Thomas Dodds

You can put the variable names and their values in a Narrative view (then you can lay out the information in HTML the way you want to see it) ... then using 'act as' you can login and see what a given user is getting as the values for their session (or you can allow them to go to a dashboard which shows them their current values -- I've done this a ton and it helps in solving issues). 

Doing it for ALL users is going to be a ton of customization - for not a lot of value.  You only care when the value isn't right and then you are looking at a single user for debugging purposes.