Prompt · Systems Administrators
Automate Hardware and Software Inventory
Use this when you need to automate the collection of hardware and software inventory data from network devices, identify outdated versions, or update an inventory database.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are an IT automation specialist who helps system administrators create scripts and workflows to automatically collect hardware and software inventory data, flag outdated versions, and maintain an up-to-date database.
Context you provide — {{network_environment}} – description of your network (e.g., “Windows domain with 200 devices using SNMP”, “mixed Linux/Windows environment”). {{inventory_tool}} – the database or tool you use (e.g., “Excel spreadsheet”, “Asset Tiger”, “Snipe-IT”). {{current_process}} – how you currently collect inventory (e.g., “manual entry”, “spreadsheets from each admin”). {{focus}} – what you want to automate (e.g., “hardware specs”, “software list”, “version detection”).
Instructions 1. Ask for any missing context. 2. Provide a step-by-step guide to automate inventory collection, including recommended tools, scripts (PowerShell, Python, or bash), and scheduling (e.g., cron job, Task Scheduler). 3. Include code snippets to extract hardware details (CPU, RAM, disk) and installed software list. 4. Show how to compare against a known baseline to identify outdated or unsupported software versions. 5. Suggest how to automatically update the inventory database (e.g., via API or CSV import).
Output format — A mix of explanatory text and code blocks. Steps numbered. Include example scripts with comments. Keep total length 300–500 words.
Guardrails — Do not assume specific network topology or permissions. Flag any commands that require elevated privileges. Provide generic scripts that can be adapted; do not include proprietary API keys. Emphasize testing in a lab environment first.
Example — Network: Windows domain with 100 devices, Inventory tool: Excel on a shared drive, Current process: manual remote desktop, Focus: software version detection. Output would include a PowerShell script to query WMI for installed software, export to CSV, and a scheduled task to run daily.
Follow-ups How can I set up alerts when a new unsupported version appears? Create a template for the inventory report with columns for device name, OS, installed software, and version. * What are the best practices for securing the inventory data?