Home > Forum > Data sources > Active BPS Users

Active BPS Users

0

Marza Mihai

15.12.2023

14:58

Marza Mihai

Hello,

I created a few BPS users and I found out that they are saved in BPS_Config instead of BPS_Content.
From the Administration tab I activated license for some users, but I have no idea in what table I can see this information.
I want to make a calculated column in a dictionary report where I can see witch user has license.
So in what table I can find if a BPS user has license or not?

Thank you,
Best regards!

Reply

15.12.2023

15:30

Hi Marza,

you can take a look at these table in the BPS Config database

dbo.[UsersCals]
dbo.[SingleSolutionCals]

The last one is only relevant, if you have "Single solution access".

Depending on your environment you may not be able to execute the sql query with the "Current BPS Database" data source option.
If the query is working find in management studio but doesn't execute in WEBCON, create a custom data connection and use this one. The "new" environments use the "application user" "bps_user" which can not read data from another database.
You can read up on this here:
https://community.webcon.com/forum/thread/3448?page=1#m3464

Best regards,
Daniel

Reply

Solution (0)

Helpful (0)

Wrong answer (0)