skills.rest
ajshedivy
ajshedivyCOMMUNITY
Explore all skills by this author →
GitHub

product

Query IBM i software products and licenses via QSYS2 SQL services.

3|1|Updated Feb 3, 2026
Search Tags:#sql#licensing#inventory#software#ibmi#product-health#qsys2
One-click install
npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill product-ajshedivy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: product
Source: https://github.com/ajshedivy/ibmi-agent-skills/tree/main/skills/product
Command: npx skills add https://github.com/ajshedivy/ibmi-agent-skills --skill product-ajshedivy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Query IBM i software products, licensing, and product health via SQL services to give administrators visibility into system software state.

Core Features & Use Cases

  • Inventory: list installed software products with status, release, and health indicators.
  • Detail & Licensing: fetch detailed product information and licensing terms for a specific product ID.
  • Health & Compliance: identify load errors, unsupported or incompatible products, and license violations.
  • Use Case: quickly audit system software to plan upgrades and ensure compliance across IBM i installations.

Quick Start

Execute the tool list_software_products to retrieve installed software products and statuses.

Frequently Asked Questions about product

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I list installed IBM i software products and check their status using SQL?▼

You can list installed IBM i software products by querying the QSYS2.SQL services view SOFTWARE_PRODUCT_INFO. This returns product status, release levels, and health indicators for all installed software on your system.

What is the best way to check IBM i software licensing and compliance via SQL?▼

Checking IBM i software licensing involves querying the QSYS2 view LICENSE_INFO to retrieve licensing terms. You can flag load errors, identify unsupported products, and detect license violations for compliance auditing.

How do I retrieve detailed product information for a specific IBM i product ID?▼

To retrieve detailed product information for a specific IBM i product ID, query the SOFTWARE_PRODUCT_INFO view in QSYS2. This fetches specific product details alongside its current health and compliance data.

Can I identify product load errors and unsupported software on IBM i using SQL services?▼

Yes, you can identify product load errors and unsupported software by querying IBM i SQL services. The tool flags incompatible products and load errors, providing visibility into your system's software health.

Does querying product health on IBM i require any special dependencies or setup?▼

Querying IBM i product health requires no special dependencies, relying solely on built-in QSYS2 SQL services views like SOFTWARE_PRODUCT_INFO and LICENSE_INFO. You only need access to execute SQL on your IBM i system.

Related Skills

Explore More Product & Management Skills→
ajshedivyajshedivy
3

backup-and-recovery

Query IBM i backup resources using QSYS2 SQL services.

Community
Intermediate
wwa-labwwa-lab

legacy-ibmi-inventory

Automates inventory of IBM i legacy assets including RPGLE, CLLE, COBOL, and DDS.

Official
Advanced
ajshedivyajshedivy
3

system-health

Monitor IBM i CPU, memory, disk, ASP, and network metrics via QSYS2 views.

Community
Intermediate
ajshedivyajshedivy
3

application

Inventory IBM i application objects via QSYS2 SQL services and ibmi CLI.

Community
Intermediate