Which documents are referenced the most?

Bhupinder_Singh

I was wondering if someone knows how to create a LiveReport to find out number of aliases on a document, or the number of aliases on all documents, i.e. to find the most popularly referenced documents in the system.

eLink User

Message from David Slimmon via eLinkHi there,You should be able to track down all aliases in your database quickly with somequerying on the DTree column. In particular, you're looking for database objects inDTree with a DataType of 1. This query should find them, for example:SELECT *FROM DTreeWHERE SubType=1Taking the root of the query above, it wouldn't be too difficult to sort the resultsbased on the OriginDataID column. This would give you a good impression of thenumber of times a particular object in Livelink is aliased. Take a look at theOriginDataID column for each element in DTree with a SubType of 1.Coincidentally, I happened to be working on a different kind of query when yourposting came in which you might also find useful for maintenance purposes. The querybelow, when constructed as an AutoLiveReport, brings back a list of all bad aliasesin your database. This could be handy.It goes a little something like this:SELECT * FROM DTreeWHERE (%1 OR %2) AND %3AND (OriginDataID NOT IN (select DataID from DTree))Where:Param%1: Filter AliasParam%2: Filter GenerationParam%3: Filter PermissionsThe way to test this LiveReport out is to do the following:1. Add a document to Livelink.2. Add an alias to that document.3. Remove (delete) the original document but leave the alias there.After doing this, the LiveReport above should find the broken alias.Regards,Dave-----Original Message-----I was wondering if someone knows how to create a LiveReport to find outnumber of aliases on a document, or the number of aliases on all documents,i.e. to find the most popularly referenced documents in the system.