<!DOCTYPE html>Kinch: It sounds like you're getting thumbnails.
You'll want to set a "WHERE OTVerType IS NULL" in there. Thumbnails have an OTVerType of "otthumb".
Cheers,
Ben
On August 9, 2017 at 12:02 PM "eLink Entry: Content Server LiveReports Forum" <livereportsdiscussion@elinkkc.opentext.com> wrote:
I am trying to respond to a Technical Architecture Questionaire from OT, attempting to create the Data Profile of existing documents. I am NOT at all very good at livereports but using Dave Slimmon's topic from 2011 in this forum, I/he came up with "SELECT MimeType, COUNT(MimeType) FROM DVersData GROUP BY MimeType" which seemed perfect. I ran straight from SQL Server Mangagement Console and produced a surprising result of some 2 million "image/jpg"... surprising because I expected a few thousand at best, we essentially only work with PDF and ZIP files. So, I then decided to use CS search for "image/jpg" but found that was not a valid mimetype to use in an advanced search .... hmmmm, even more suprising.So, I then tried a livereport: "select d.*
from DTreeCore d
inner join DVersData v on d.dataid=v.DocID and d.VersionNum=v.Version
where d.SubType=144
and v.MimeType='image/jpg'"And I got a list of supposed matches, the vast majority of which are PDFs ... and it is VERY likely that the data within the PDF is an image (scanned of course) but Properties->Specific shows it as "application/pdf" as does the Properties->version->Properties->specific information.At a data level I can appreciate how a PDF is an image but I'm quite confused by the mimetype being displayed and available. I just can't make sense of how the CS GUI displays these as PDFs, search can't even look for image/jpg, and yet dversdata suggests we have 2 million such documents. I don't think anything is untoward however I am still at a loss as to how to come up with a true data profile. Can anybody help clear my muddled brain?As a bonus question, any idea how that mimetype is getting set to a value that CS claims it doesn't know about? Looking at the report results, this has been going on essentially since the system was setup in 2014 and continues today, it doesn't seem to have any effect on the data (other than the aforementioned Data Profile creation) but it sure is confusing me. |
