Skip to main content
Sticky Project 1

txt2cql

  • 3 June 2024
  • 0 replies
  • 96 views

Context

 

txt2cql is a command-line tool designed to convert input text into a valid Centreon Query Language (CQL) request. The generated CQL is automatically copied to your clipboard, ready to be pasted into the research bar of the resource status page in Centreon.

 

Examples

 

Prompt: all ping services for all linux hosts

Generated CQL: s.description:ping h.name:linux

 

Prompt: get all hosts with mail or ldap in the name at the beginning of the name

Generated CQL: name:^mail|^ldap

 

Works in other languages too:

Prompt: tous les hôtes qui commencent par mail ou ldap

Generated CQL: name:^mail|^ldap

 

Costs

 

txt2cql uses OpenAI GPT-o model behind to translate the query with a specific context. These models are billed by token (input and output). The context is made of ~900 tokens. The input is usually around 10 to 30 tokens top and the output is usually below 20 tokens. This means that the cost of a query can vary but is around 5$ for every 1000 requests.

 

Installation

 

See the project repository for more information on how to install and configure the tool.

Be the first to reply!

Reply