Document Activity Tracking Feature in 9.0

[dakun]

Hello All,

Recently, we upgraded our system to CMOD v9.0.0.2 and I found there is a new feature that in application group properties, we can track last document loaded, last document retrieval and last document Query in the specific group.

it's a good feature to me in order to identify which AGs or folder were not used at all, I will be able to optimize CMOD performance based on it.

However, is there any to turn on the feature by xml or other scripts for all AGs? I dont want to go into each one of them and turn it on.

Thanks

[jeffs42885]

I doubt IBM would tell you because those tables are proprietary?

My former coworker completely reengineered all of the ARS.* tables because IBM refused to help us with a user report. Try playing with the tables in your lower tiered. Make sure you back up first

[Frederick Tybalt]

If that is a field is that can be updated in AG, try using arsxml to do a batch update

[dakun]

If that is a field is that can be updated in AG, try using arsxml to do a batch update

I wanted to use XML but those fields are not defined in AG XML objects.

[dakun]

I doubt IBM would tell you because those tables are proprietary?

My former coworker completely reengineered all of the ARS.* tables because IBM refused to help us with a user report. Try playing with the tables in your lower tiered. Make sure you back up first

WOW, IBM told me before to use XML to operate tables otherwise the table will be messed up. Is your system upgraded after table change? just wonder if the change was still there after upgrade.

[jeffs42885]

I doubt IBM would tell you because those tables are proprietary?

My former coworker completely reengineered all of the ARS.* tables because IBM refused to help us with a user report. Try playing with the tables in your lower tiered. Make sure you back up first

WOW, IBM told me before to use XML to operate tables otherwise the table will be messed up. Is your system upgraded after table change? just wonder if the change was still there after upgrade.

Nothing was messed up, as we werent messing up anything.

Honestly, in my 4 years of supporting CMOD i have maybe talked to 1-2 people from IBM that were helpful. Most of my answers were solved by making a list of possible things, and checking each one, and this group of course.

Our script basically created NEW tables, populated tables (Granted, the users/groups tables) are much smaller...exported it to a CSV file and then it was sent to another line of business for analysis, probably ingested via cognos or even something like a coldfusion/mssql setup.

They never not once mentioned to use ARSXML, so instead of wasting time waiting on PMR's and keeping track, I would "reinvent the wheel" except it would be the reinvented jeff wheel and boom..solved.

</rant>

[Frederick Tybalt]

I wanted to use XML but those fields are not defined in AG XML objects.

What I generally do to locate the XML object is,
1. manually update the field in AG
2. use arsxml export  to export the object to xml
3. Locate the object for the field that requires update and recreate a xml
4. use arsxml update

Not sure if you have tried this.

[dakun]

I wanted to use XML but those fields are not defined in AG XML objects.

What I generally do to locate the XML object is,
1. manually update the field in AG
2. use arsxml export  to export the object to xml
3. Locate the object for the field that requires update and recreate a xml
4. use arsxml update

Not sure if you have tried this.

It 's a cool approach! I found the parameter I need!
enableLoadDate="true" enableQueryDate="true" enableRetrieveDate="true"
Thank you very much!

[Frederick Tybalt]

Great!!

[Alessandro Perucchi]

I doubt IBM would tell you because those tables are proprietary?

My former coworker completely reengineered all of the ARS.* tables because IBM refused to help us with a user report. Try playing with the tables in your lower tiered. Make sure you back up first

I'm really sorry for that... I work with IBM, and I help all my customer even if sometimes I need to look directly into the ARS table, and sometimes if the task requires it I give some information on these tables. With of course all the warning that if they change the values directly ... etc.. etc.. that could break their system.

Even recently I've done it for a customer who needed to find some information on their permission jungle, and it was an old CMOD without XML... and the admin was not really fit to their needs... so directly looking into the tables is the only way to answer such questions...

Of course this is my point of view, and my way to help customer, and maybe I'm an outlaw inside IBM!
But an happy customer is for me the greatest reward...

Yours sincerely,
Alessandro

BEGIN DISCLAMER
this is my own point of view, and not the one from IBM... since I'm not allowed to speak in the name of IBM
END OF DISCLAMER