Capabilities
The Open iT Generative AI assistant is equipped with advanced capabilities that enables you to retrieve knowledge, analyze data, optimize licensing, generate reports, and visualize insights through natural language interaction.
This page outlines four core capabilities of the AI assistant to help you understand and utilize Open iT effectively.
Knowledgebase Support
The AI assistant offers direct access to Open iT resources, helping you to navigate technical setup, configuration, licensing strategies, and reporting standards. This support is powered by the documentation from the Open iT Docs, Licensing 101 Guide, and Open iT Customer Portal Reports.
Documentation
Provides access to official guides, technical specifications, and usage documentation.
The AI assistant can guide you in:
- Setting up Open iT components
- Reviewing product updates and version changes
- Following best practices during deployment
- Accessing module-specific documentation
Example Prompts:
How do I configure the Core Server in Open iT?
What are the release notes for the latest Analysis Server version?
Where can I find the installation guide for License Analyzer?
Licensing Guidance
Access guidance to manage software licenses effectively, reduce costs, and improve usage behavior across your organization.
The AI assistant can guide you in:
- Optimizing license allocation and recovery
- Detecting inactive licenses or unused applications
- Improving compliance with vendor policies
- Avoiding overspending through behavior-based tuning
Example Prompts:
How can I prevent service denial due to license shortfalls?
Suggest ways to reduce idle time on high-cost licenses.
What license optimization strategies can reduce our annual costs?
Customer Portal Reports Support
Guides you in exploring and applying predefined report templates available in the Open iT Customer Portal. These templates, based on SQL Server Reporting Services (SSRS), support tracking, visualization, and analysis of license usage data.
While the Generative AI assistant can assist you with SSRS concepts, report selection, and RDL template usage, SQL Server Reporting Services (SSRS) functionality is not yet supported in the initial release of Open iT Version 11. This content is provided for informational purposes and future reference.
The AI assistant can guide you in:
- Finding templates for usage summaries
- Understanding the technical structure of RDL files
- Selecting reports tailored for specific business or compliance needs
Example Prompts:
What types of RDL templates are available to analyze licensing compliance?
How can I upload Open iT reports to SQL Server Reporting Services?
Data Management and Analysis
The AI assistant enables you to convert natural language queries into structured SQL commands and extract actionable insights from usage data. This capability is helpful for generating reports, analyzing software consumption patterns, and identifying optimization opportunities.
Data Querying and Handling
Generates PostgreSQL-compatible SQL queries that retrieve structured usage data from the Cube.js semantic layer.
The AI assistant can guide you in:
- Extracting targeted datasets such as license usage trends, peak activity times, or user-level breakdowns.
- Returning clean, readable markdown tables that include row counts, column headers, and structured outputs.
- Understanding and reflecting data schema, enhancing usability and interpretation.
Example Prompts:
Retrieve software usage data for the past quarter.
Find all unused licenses over the last month, including user information.
Get peak usage hours for Autodesk licenses by day for the past 30 days.
Insights and Analysis
Interpret and analyze query results to uncover patterns, detect compliance risks, and recommend efficiency improvements.
The AI assistant can guide you in:
- Identifying software with high or low utilization rates across teams or departments.
- Detecting overuse, under-allocation, or potential licensing violations based on usage data.
- Determining actions to reduce idle time, improve license allocation, or adjust usage behaviors.
Example Prompts:
Which licenses are frequently overutilized, and what can we do about it?
Analyze user behavior to reduce idle time and improve efficiency.
Which applications are rarely used and could be decommissioned?
Reporting and Visualizations
The AI assistant allows users to generate structured reports and meaningful data visualizations that support operational reviews, decision-making, and license optimization planning.
Report Generation
Create actionable and presentation-ready reports using prebuilt or custom templates.
The AI assistant can guide you in:
- Designing tailor-fit reports specific to business units, software categories, or license types.
- Generating time-bound reports (monthly, quarterly, annually) to support compliance and performance tracking.
Example Prompts:
Create a report comparing departmental license usage for Q1.
Summarize unused licenses in a custom report template.
Generate a quarterly license cost summary grouped by vendor.
Visualization
Transform raw data into clear visual representations like charts, graphs, and dashboards to support better data-driven decisions.
The AI assistant can guide you in:
- Building bar charts, line graphs, scatter plots, pie charts, and heatmaps tailored to specific metrics or comparisons.
- Generating components suitable for embedding in dashboards or presentations.
- Highlighting key data behaviors, such as usage peaks, time-based fluctuations, or performance gaps, in a visual format.
Example Prompts:
Display software usage trends over the last quarter using a line graph.
Visualize daily concurrent license usage with a bar chart.
Generate a heatmap showing hourly license usage across the week.
Advanced Prompt Handling and Output Generation
The AI assistant can orchestrate multiple tools in parallel to fulfill complex requests. This capability enables you to execute multi-step workflows that involve data querying, analysis, visualization, and documentation from a single prompt.
The AI assistant is capable of processing multi-step requests within a single prompt — combining data retrieval, analysis, visualization, and documentation.
Complex Prompts
Address advanced or multi-step requests that require simultaneous interaction with different tools such as CubeJsQueryer, DataVisualizer, and Documentation Retriever.
The AI assistant can guide you in:
- Pulling structured license or usage data from Cube.js using queries.
- Generating graphs and dashboards based on query results using the DataVisualizer tool.
- Integrating documentation or licensing guidance to contextualize results and recommendations.
Example Prompts:
Analyze software usage trends for the last 6 months and visualize the results in an interactive dashboard.
Retrieve license usage data, highlight top 10 users, and generate a report with relevant graphs.
Generate a license efficiency report, visualize idle license time, and include recommendations from Licensing 101.