Report that lists categories that need to be upgraded

Hello I need a report that identifies every applied category in Content Server that needs to be upgraded. Can anyone help me?

Find more posts tagged with

Comments

appuGmail

Page 9 of this Document has a good query that can be extrapolated to your specific case

https://knowledge.opentext.com/knowledge/cs.dll/15862451/Best_Practices_for_Upgrading_Categories.pdf?func=doc.Fetch&nodeid=15862451&vernum=3

DefID and DefVerN in LLAttrData signifies the Category that is being applied

so if in the Categories Volume (or wherever the new version of the category object is tored) you look at its versions and find that ID=12345678 is at Version 278,that is one went and imparted changes on Version 277.

One could try to find the Objects that are sitting Unupgarded by writing this

Select * from LLAttrData where AttrType=-18 and AttrID=1 /*this is to restrict it to one row for a applied object*/ and DefID=12345678 /*DefID will not change if a category is versioned*/

and DefVerN = 278

If this yields zero rows then you know that all Categories are Kosher good job

Select * from LLAttrData where AttrType=-18 and AttrID=1 /*this is to restrict it to one row for a applied object*/ and DefID=12345678 /*DefID will not change if a category is versioned*/

and DefVerN = 277 //if you get 250 rows(you wish) then that means all those objects numbering 250 are what you need to upgrade for this category,but you get the idea,if you say <278 then it will start reporting

on rows concerning individual versions of metadata on the object so try to limit objectively....Using a SQLtool to analyze is advised as the LR is not a very flexible tool

Most of us over the years will not try to run every category in your system for upgrade and if your users are waiting to see a Upgraded value one would try to find the container and upgarde the

category from there.I think it says in that best practice document.

Over the years a whole slew of good queries have been amassed so I am pretty sure if you searched you would get more excellent and purpose built ones here....

If you have WR or some other programming utility

[LL_REPTAG_1 CATACTION:UPGRADE:[LL_REPTAG_&catID /] /] here REPTAG_1 will resolve to a dataid that you may provide as a query or a flat file the second thing is the Upgarde instruction the thiird one is the

CategoryOn the node that is to be upgraded.Many of us will try to exclude items in Recycle bin etc...

For e.g one could try to find the folders one wants and not in Recycle bin by doing something like

select Name,DataID from DTree where SubType=0 and OwnerID != - (select DataID from DTree where SubType=3030) //because 3030 is the Recyclebin

subtype and everything in a Recycle bin is owned by that guy

..... appnair appunair( Livelink Rocks )

Well, if I called the wrongnumber, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

On Fri, Nov 17, 2017 at 1:04 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Report that lists categories that need to be upgraded Posted bywbrantley@cvrenergy.com (Brantley, Will)On 11/17/2017 02:02 PM

Hello I need a report that identifies every applied category in Content Server that needs to be upgraded. Can anyone help me?
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center CS 16.2.2

Will_Brantley

Thanks for your help. It was greatly appreciated.

Colin_Schmidt

For what it's worth, here is a PDF of a Visio drawing of basic Core relationships. The last page is on the LLATTRDATA.

Visio-TableRelationships.pdf

Nizar Ghazal

Quoted Colin Schmidt on 12/22/2017 11:33 AM:

For what it's worth, here is a PDF of a Visio drawing of basic Core relationships. The last page is on the LLATTRDATA.

Great share, Colin. I'm sure this will help people new to CS wrap their heads around some of the relationships.