Types and Count of MimeTypes in your system...

David_Slimmon

Hi there,This is one of those really simple SQL statements that I had to come up with recently that (for me anyway) returned some really interesting results about the documents in my Livelink database.SELECT MimeType, COUNT(MimeType) FROM DVersData GROUP BY MimeTypeIt tells you how many of each type of document (based on mimetype) you have in your system. Beyond just plain old general interest, it can be meaningful information when building your enterprise index in Livelink.Cheers,Dave