Add on user preferences

[Former Member]

hi

On the add-on administration i want to know where the data is stored the add on preferences, we want to find out if the add-ons are set to default, automatic manual or disabled from SQL tables.

Looking forward to the positive answer.

Regards

Nthabiseng

[Former Member · Accepted solution]

Please close your thread since you got your answer.

[Former Member]

Hi Nthabiseng,

The info is saved in the SARI table of SBO-Common. What do you need this table for?

Thanks,

Gordon

[Former Member]

Hi Gordon

i want the info for reporting, i see on the SARI tables shows types of licenses , but what i need is to find out for each user if the addon has been set to default or manual. because we having problems with our clients logging calls that the addons are not running automatically only to find out it's set to manual on SAP B1 so i need the table where all the addons preference for all users is stored.

thanks

Nthabiseng

[Former Member]

That can be found from table ARI1 in company's db. OARI save the default. ARI1 save the exception in case different from default.

[Former Member]

Hi

thanx for the answer, but my concern is it's only stores the data for manager ans support not all the user's available in the database.

thnx

Nthabi

[Former Member]

hi Gordon

thank you very much my bad i checked on one database that has only two users created, after checking on our test database found out that it's showing all the users...... Thank you very much

Thnx

Nthabiseng