ajshedivy/product
skills/product/SKILL.md
Query IBM i software products, licensing, and product health via SQL services. Use when user asks about: (1) installed software products and versions, (2) product details for a specific product ID, (3) software products with load errors, (4) license compliance and usage limits, (5) unsupported or incompatible products, (6) replacing DSPSFWRSC, WRKLICINF, DSPPTF commands, or (7) any software product management task.
$ install --global
skillsauthnpx skillsauth add ajshedivy/ibmi-agent-skills productInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 25, 2026, 5:35 AM55.7s4 files scanned
SKILL.md
- name:
- product
- description:
- Query IBM i software products, licensing, and product health via SQL services. Use when user asks about: (1) installed software products and versions, (2) product details for a specific product ID, (3) software products with load errors, (4) license compliance and usage limits, (5) unsupported or incompatible products, (6) replacing DSPSFWRSC, WRKLICINF, DSPPTF commands, or (7) any software product management task.
IBM i Software Product & License Management
Query installed software products, licensing, and product health using SQL services from QSYS2.
Available Tools
The ibmi CLI is the primary tool for executing product queries. Set SKILL_DIR to this skill's installed location (the directory containing this SKILL.md file):
# SKILL_DIR = directory containing this SKILL.md
# Examples: ./skills/product, ~/.claude/skills/product
ibmi tools --tools "$SKILL_DIR/tools/" --toolset product_default
ibmi tool list_software_products --tools "$SKILL_DIR/tools/"
ibmi sql "SELECT * FROM QSYS2.SOFTWARE_PRODUCT_INFO WHERE INSTALLED = 'YES' AND LOAD_ERROR = 'YES'"
Service Selection Guide
Software Products
- QSYS2.SOFTWARE_PRODUCT_INFO -- Installed products with release, state, errors, compatibility
Licensing
- QSYS2.LICENSE_INFO -- License terms, usage limits, peak usage, expiration dates
Key Capabilities
Software Inventory
- Product Listing -- All installed products with release level and status
- Product Detail -- Deep dive into a specific product's options and loads
- Error Detection -- Find products with load errors or broken installations
- Compatibility Check -- Identify unsupported or incompatible products
License Management
- Usage Tracking -- Current usage count vs usage limit per product
- Peak Usage -- Historical peak usage for capacity planning
- Compliance -- Compliance type and violation logging status
- Expiration -- License expiration dates and grace periods
Common Use Cases
- Software inventory -- List all installed products and versions
- Product lookup -- Get details for a specific product ID (e.g., 5770SS1)
- Error detection -- Find products with load errors needing attention
- License audit -- Review license compliance and usage
- Upgrade planning -- Identify unsupported or incompatible products
- Capacity planning -- Check peak usage against license limits
Quick Examples
List installed products
ibmi tool list_software_products --tools "$SKILL_DIR/tools/"
Details for a specific product
ibmi tool get_software_product_detail --tools "$SKILL_DIR/tools/" --product-id 5770SS1
Products with errors
ibmi tool list_software_errors --tools "$SKILL_DIR/tools/"
License compliance
ibmi tool get_license_info --tools "$SKILL_DIR/tools/"
Unsupported products
ibmi tool list_unsupported_products --tools "$SKILL_DIR/tools/"
Pre-built Tools
The tools/product.yaml file provides 5 ready-to-use tools:
| Tool | Description |
|------|-------------|
| list_software_products | Installed software products with status and release |
| get_software_product_detail | Detailed product info by product ID |
| list_software_errors | Products with load errors |
| get_license_info | License compliance, usage, and expiration |
| list_unsupported_products | Unsupported, incompatible, or errored products |
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" # Execute
ibmi tool <tool_name> --tools "$SKILL_DIR/tools/" --dry-run # Preview SQL
ibmi tools show <tool_name> --tools "$SKILL_DIR/tools/" # View details
Reference Documentation
- Product Services Catalog -- Available SQL services
- Example SQL Patterns -- Working query examples
- IBM SOFTWARE_PRODUCT_INFO -- View documentation
- IBM LICENSE_INFO -- View documentation
Related Skills
ajshedivy/work-management
tools
VerifiedTrustedCommunity
Query, monitor, and analyze jobs on IBM i using SQL table functions via the ibmi CLI. Use when user asks about: (1) finding jobs by status, user, subsystem, or type, (2) monitoring active job performance (CPU, I/O, memory), (3) detecting long-running SQL statements, (4) analyzing lock contention, (5) checking job queues, (6) scheduled jobs, (7) job logs, (8) replacing WRKACTJOB, WRKUSRJOB, WRKSBSJOB, WRKSBMJOB commands, or (9) any IBM i work management task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/system-health
testing
VerifiedTrustedCommunity
Monitor IBM i system health including CPU, memory, disk, ASPs, system limits, and network status via SQL services. Use when user asks about: (1) CPU utilization or system status, (2) memory pool sizes or page faults, (3) disk capacity or ASP usage, (4) system limits approaching thresholds, (5) TCP/IP connections and network status, (6) system activity overview, (7) replacing WRKSYSSTS, WRKDSKSTS, WRKTCPSTS commands, or (8) any system health monitoring task.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/storage
development
VerifiedTrustedCommunity
Monitor and analyze IBM i storage resources including ASPs, disk units, temporary storage, user storage consumption, and NVMe devices via SQL services. Use when user asks about: (1) ASP capacity, usage, or health, (2) disk unit status or I/O performance, (3) temporary storage consumption by jobs, (4) storage used per user profile, (5) NVMe device health, (6) IASP vary operations, or (7) replacing WRKDSKSTS, WRKSYSSTS storage info, or WRKSTG commands.
2SKILL.mdUpdated Apr 2, 2026
ajshedivy/spool
testing
VerifiedTrustedCommunity
Manage and analyze spooled files, output queues, and printer configurations on IBM i via SQL services. Use when user asks about: (1) listing or searching output queues, (2) viewing spooled file entries by queue, user, or status, (3) reading spool file content, (4) identifying top spool consumers or old spool files, (5) printer file definitions, (6) spool storage analysis, (7) replacing WRKSPLF, WRKOUTQ, WRKOBJLCK commands, or (8) any spool file management task.
2SKILL.mdUpdated Apr 2, 2026