IT Assets Database Queries

This Blog Post provides an overview of the queries and analyses performed on the IT Assets database. The database contains records of company-owned IT equipment, including details such as asset type, ownership, purchase dates, warranty periods, and current status.

Please Note:  All Data is purely Fictional, created by me, using a combination of ChatGPT and Mockaroo.  Any similarities to any Business, Person or Entity are absolutely coincidental.  Everything is for demonstration purposes.  Coding was completed using ChatGPT for speed of delivery using relevant Prompt Engineering processes and iterations.

Database Structure

The IT Assets database consists of the following columns:

– AssetID (INTEGER): Unique identifier for each asset.
– AssetType (TEXT): The type of IT asset (e.g., Laptop, Desktop, Server).
– Owner (TEXT): The assigned owner or user of the asset.
– PurchaseDate (TEXT): The date the asset was purchased.
– WarrantyEnd (TEXT): The date the asset’s warranty expires.
– Status (TEXT): The current operational state of the asset (e.g., Active, Retired, In Repair).

Queries and Analysis

1. Asset Distribution by Type

We analyzed how assets are distributed across different asset types. This provides insight into the company’s inventory composition, such as the number of laptops, desktops, and servers.

2. Assets per Owner

We examined how assets are allocated to owners. This helps identify whether assets are fairly distributed among employees or if certain individuals hold a disproportionate number of assets.

3. Assets by Status

We categorized assets based on their operational status. This helps in identifying the proportion of assets that are active, retired, or undergoing maintenance.

4. Assets with Expired Warranties

We identified assets whose warranty periods have expired. This information is crucial for maintenance planning, budgeting for replacements, and risk management.

Key Insights

– The distribution of assets shows the reliance on specific device categories.
– Ownership analysis highlights asset allocation trends among employees.
– Status analysis helps determine the health of the IT infrastructure.
– Expired warranties indicate potential risks in terms of unexpected repair costs.

Conclusion

The IT Assets database queries provided valuable insights into asset distribution, ownership, status, and warranty coverage. These findings can assist IT managers in decision-making regarding asset lifecycle management, resource allocation, and budgeting for replacements.