Reporting Tools

Reporting Tools cover image - blue and green charts on blue background


Get wireless inventory report

The Get Wireless Inventory Report tool generates a report with details about wireless users and stores it for querying. This tool will request the latest report, if an update of the cached reported is required for querying. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

generate_wireless_inventory_report

  • Checks if the report needs to be generated
  • Makes sure one is not currently being generated
  • Start generating one and set a flag to prevent a second from being generated at the same time by the same customer / BAN / FAN
  • Wait for its arrival
  • Store it on arrival.

  • None

A report with details about wireless users on a Billing Account Number (BAN) or Foundation Account Number (FAN) level. It includes information about Customer Telephone Numbers (CTNs), Devices, SIM Cards, Rate Plans, and Data Plans.


Query wireless inventory report

The Query Wireless Inventory Report tool makes the wireless inventory report available for querying.  This report and associated data provides details about wireless users on a Billing Account Number (BAN) or Foundation Account Number (FAN) level. It includes information about Customer Telephone Numbers (CTNs), Devices, SIM Cards, Rate Plans, and Data Plans.

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

query_wireless_inventory_report

  • Runs the appropriate functions to allow the LLM to determine the schema, sample the data, and send a query to answer the users questions.

  • SQL query to be run against the stored report.

Query result set


Get rate plan report

The Get Rate Plan Report tool generates a report with details about Rate Plans including CTNs and average usage, and stores it for querying. This tool will request the latest report, if an update of the cached reported is required for querying. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

generate_rate_plan_report

  • Checks if the report needs to be generated
  • Makes sure one is not currently being generated
  • Start generating one and set a flag to prevent a second from being generated at the same time by the same customer / BAN / FAN
  • Wait for its arrival
  • Store it on arrival.

  • None

A report with details about Rate Plans including CTNs and average usage. 


Query rate plan report

The Query Rate Plan Report tool makes the rate plan report available for querying. This report and associated data provides details about Rate Plans including CTNs and average usage. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

query_rate_plan_report

  • Runs the appropriate functions to allow the LLM to determine the schema, sample the data, and send a query to answer the users questions.

  • SQL query to be run against the stored report.

Query result set


Get catalog extract report

The Get Catalog Extract Report tool generates a report with a Catalog of AT&T Products and Services specific to the customer's account, and stores it for querying. This tool will request the latest report, if an update of the cached reported is required for querying. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

generate_catalog_extract_report


  • Checks if the report needs to be generated
  • Makes sure one is not currently being generated
  • Start generating one and set a flag to prevent a second from being generated at the same time by the same customer / BAN / FAN
  • Wait for its arrival
  • Store it on arrival

  • None

The Catalog Extract Report will include SKUs for Products and Services, and compatibility information about Devices, Accessories, Rate Plans, Data Plans, and Features. 


Query catalog extract report


The Query Catalog Extract Report tool makes the catalog extract report available for querying.  The Catalog Extract Report will include SKUs for Products and Services, and compatibility information about Devices, Accessories, Rate Plans, Data Plans, and Features.

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

query_catalog_extract_report

  • Runs the appropriate functions to allow the LLM to determine the schema, sample the data, and send a query to answer the users questions.

  • SQL query to be run against the stored report.

Query result set


Get upgrade eligibility report

The Get Upgrade Eligibility Report tool generates a report showing which of the customer's devices, under a specific Billing Account Number (BAN), are eligible for an Upgrade. This tool will request the latest report, if an update of the cached reported is required for querying. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

generate_upgrade_eligibility_report

  • Checks if the report needs to be generated
  • Makes sure one is not currently being generated
  • Start generating one and set a flag to prevent a second from being generated at the same time by the same customer / BAN / FAN
  • Wait for its arrival
  • Store it on arrival.

  • None

Information about devices that are eligible for an upgrade. 


Query upgrade eligibility report

The Query Upgrade Eligibility Report tool makes the upgrade eligibility report available for querying.  The report shows which of the customer's Devices, under a specific Billing Account Number (BAN), are eligible for an Upgrade. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

query_upgrade_eligibility_report

  • Runs the appropriate functions to allow the LLM to determine the schema, sample the data, and send a query to answer the users questions.

  • SQL query to be run against the stored report.

Query result set


Get order history report

The Get Order History Report tool generates a report that shows up to 90 days of Order History information across all Store Order and Care Order transactions. This tool will request the latest report, if an update of the cached reported is required for querying. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

generate_order_history_report

  • Checks if the report needs to be generated
  • Makes sure one is not currently being generated
  • Start generating one and set a flag to prevent a second from being generated at the same time by the same customer / BAN / FAN
  • Wait for its arrival
  • Store it on arrival.

  • None

Order History information across all Store Order and Care Order transactions. 


Query order history report

The Query Order History Report tool makes the order history report available for querying.  The report shows Order History information across all Store Order and Care Order transactions. 

Tool Name

Tool Functionality

Inputs

Outputs

Example Prompt

query_order_history_report

  • Runs the appropriate functions to allow the LLM to determine the schema, sample the data, and send a query to answer the users questions.

  • SQL query to be run against the stored report.

Query result set