Hello,
I'm looking SQL-livereport to fetch document details which having 0KB size
Can someone help me.
Thanks!
In livelink when a node is created and a version is created it has a positive size.However in a large install and with differing tools used to uplaod stuff it is not uncommon in livelink to get sometimes a node(as in the db) but not actually in the filestore.So to find those you can use level 5 of verification or alternatively use this
select docid from dversdata where filesize < 0
(pls do a describe on dversdata and check the column corrcetly)
I use this to find documents in livelink that is in an eeroneous condition.
Most modern livelink's with uptodat patches will not cause this situation
I am sure you found your query by now, if not try this
SELECT a . DocId , a . Version , a . ProviderId , a . FileName , a . datasize
FROM DVersData a
WHERE DataSize = 0
In addition, I am looking for a query to join this table (above) with the Remote Cache Server that is was uploaded from....
