William, I am glad that you found the solution. And, that BMC support was able to help by providing the solution!
Now, one thing I did want to comment on was your discussion of "leading search" and FTS. It is important to note that FTS is a "word search" capability. What this means is that FTS is a word centric search capability. Putting abc% will find words beginning with abc not the entire contents of the field starting with abc. Although the syntax may look like a LIKE, it is not really an SQL LIKE. It will also match words that are not exact matches using stemming and thesaurus. Stemming means that it will find words with standard endings. For example if you searched for hike, it would match hike, hikes, hiking, hiked, and similar permutations. Thesaurus means that it will find words from a dictionary where you have described the words as being the same thing. This dictionary can be expanded at your site to add things that are unique to your site where two words mean the same thing. Hopefully, this explains why the "lync" was matched even though it was not at the start of the entire string. It WAS at the start of a word. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: Tuesday, November 20, 2012 12:31 PM To: arslist@ARSLIST.ORG Subject: Re: FTS search on CI Name ** I found the fix for this (with BMC's help I should add) - The FT Search Threshold was set to the default of 10,000. Even though the documentation says this is the number of results that will be returned it's sort of vague. What it really means is that FTS will return this many results that "might" match, evaluate them, and then return your result set. In our case the total result set was only 16. However, after doing some checking in the database we were able to determine there was 21,000+ "Microsoft"-esque possible search results. Since our new data would be at the end of the data considered (given that it is all in one table) it looks like FTS just grabs the first possible match up to the max in the threshold prior to evaluating which ones are "good" matches. Upping the FT Search Threshhold to 25,000 fixed the problem. William Rentfrow wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com> http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell From: William Rentfrow Sent: Thursday, November 15, 2012 3:36 PM To: arslist@ARSLIST.ORG Subject: FTS search on CI Name We have indexed CI Name for FTS and MFS search. This is in CMDB 7.6.04 patch 002. All searches are QBE i.e., all examples below are typed into the field, not using the "Advanced Search". When a QBE search is run against this field we are getting some weird (IMHO) results. If I search for "microsoft" (no quotes) I get all the three word or four word phrases I'd expect, like these: Microsoft Office Professional 2007 MICROSOFT OFFICE COMMUNICATOR MICROSOFT OFFICE PROJECT ...and a few others. What does NOT show up however is two word combination entries, like: MICROSOFT LYNC I can't figure out why. The QBE value for this field is set to leading. So by default any search for that would be the functional equivalent of this: microsoft% And in fact that is what I see in the logs: the SQL log says this: Thu Nov 15 2012 09:05:32.3209 */FTS: Search request for schema ID 3158, field ID 200000020, search term ((microsoft%)) Even stranger, searching for just "lync" DOES find it, even though the FTS search issued is lync%. This does find it (all text below literally entered as a QBE entry): [microsoft test] I'm....so....confused....I understand how things are tokenized, etc. but given the search being issued it should find it. William Rentfrow wrentf...@stratacominc.com<mailto:wrentf...@stratacominc.com> http://www.stratacominc.com 715-204-3061 Office 715-498-5056 Cell _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"