karlovac
27th June 2003, 09:18
How to find out tools table in company 000 in which I have to change User properties - Worktop tree.
I have to do it for over 200 users which could be easy to do thrue General table maintenence (modify rows) if I know table for it.
(It isn't tools table ttaad200)

Thanks

OmeLuuk
27th June 2003, 09:48
I performed the actions: switch on WorkTop/Webtop tree, and the options below one by one, with DBSLOG=010:R_UPD on ttadv999000
Key values index 1:
Col pacc : string : ' '
Col keyr : string : 'ubsp '
Row :
Col pacc : string : ' '
Col keyr : string : 'ubsp '
Col desc : string : '1221222
'
Col Refcntd : long : <0>
Col Refcntu : long : <0>
and after that:
Col desc : string : '1221122
'
Col desc : string : '1221112
'
Col desc : string : '1221111
'
Col desc : string : '1221111
'
And at last you will see a record like:
<15103> bsp [15]--------- R_UPD on ttadv990000 ------------

Key values index 1:
Col user : string : 'bsp '
Col comp : short : <0>
Col sess : string : 'ttaad2100m000'
Col sequ : short : <0>
Row :
Col user : string : 'bsp '
Col comp : short : <0>
Col sess : string : 'ttaad2100m000'
Col sequ : short : <0>
Col rcrd : string : '032ttaad200.user:="bsp "015bwstart:="1"015w
orktop:="1"020menu.browser:="1"023process.browser:="1"016workflow:="1"022levels.
to.load:="1" '
Col Refcntd : long : <0>
Col Refcntu : long : <0>

karlovac
27th June 2003, 10:20
Thanks OmeLuuk

It's time for me to start using DBSLOG ...

Scout doesn't have enough infos about tools, but for other modules ....
CatalogScout (http://tatla.net/scout/full/)

Regards

tjbyfield
27th June 2003, 10:35
I tried the link in the the previous post and could see some useful info. However when I tried to look at Business Objects the feature was disabled.

Was this post an advertisment for CatalogScout?

What is DBSLOG ? Another commercial product ?

Terry

OmeLuuk
27th June 2003, 11:31
DBSLOG - see the file in this thread (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6783).