top of page

BMC Remedy FTS

How to determine which fields are being used by FTS

select 'character' TYPE, c.name FORM, b.fieldname FIELD from FIELD_CHAR a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 UNION select 'diary' TYPE, c.name FORM, b.fieldname FIELD from FIELD_DIARY a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 UNION select 'attachment' TYPE, c.name FORM, b.fieldname FIELD from FIELD_ATTACH a, field b, arschema c where a.schemaid = c.schemaid and a.schemaid = b.schemaid and a.fieldid = b.fieldid and a.fulltextoptions = 1 order by FORM asc, FIELD asc

 
 
 

Recent Posts

See All
Install Surfshark CLI

Step-by-step guide to automatically set up Surfshark VPN on Ubuntu (for both CLI and autostart at boot): sudo apt update sudo apt install snapd sudo snap install surfshark https://chatgpt.com/share/

 
 
 

Comments


Contact Me

Tel: 678-642-8051

cspeed@jcsassoc.com

  • Google+ Long Shadow
  • LinkedIn Long Shadow
  • Facebook Social Icon
  • Twitter Long Shadow

© 2005 by Christopher Speed

Your details were sent successfully!

bottom of page