#!/bin/bash
# asset_discovery.sh

NETWORK_RANGE="192.168.1.0/24"
OUTPUT_FILE="/var/log/asset_discovery_$(date +%Y%m%d_%H%M%S).txt"

echo "Starting asset discovery on $NETWORK_RANGE" > $OUTPUT_FILE
echo "Discovery started: $(date)" >> $OUTPUT_FILE
echo "========================================" >> $OUTPUT_FILE

# Network scan for active hosts
echo "Scanning for active hosts..." >> $OUTPUT_FILE
nmap -sn $NETWORK_RANGE | grep "Nmap scan report" >> $OUTPUT_FILE

# Port scan for services
echo "Scanning for open ports..." >> $OUTPUT_FILE
nmap -sS -O $NETWORK_RANGE >> $OUTPUT_FILE

# SNMP discovery
echo "SNMP device discovery..." >> $OUTPUT_FILE
for ip in $(nmap -sn $NETWORK_RANGE | grep "Nmap scan report" | awk '{print $5}'); do
    snmpwalk -v2c -c public $ip 1.3.6.1.2.1.1.1.0 2>/dev/null | head -1 >> $OUTPUT_FILE
done

# Software inventory (if running on Windows)
if command -v wmic &> /dev/null; then
    echo "Software inventory..." >> $OUTPUT_FILE
    wmic product get name,version,vendor >> $OUTPUT_FILE
fi

echo "Asset discovery completed: $(date)" >> $OUTPUT_FILE

-- Asset database schema
CREATE TABLE assets (
    asset_id VARCHAR(50) PRIMARY KEY,
    asset_name VARCHAR(100) NOT NULL,
    asset_type VARCHAR(50) NOT NULL,
    category VARCHAR(50),
    manufacturer VARCHAR(100),
    model VARCHAR(100),
    serial_number VARCHAR(100),
    mac_address VARCHAR(17),
    ip_address VARCHAR(15),
    location VARCHAR(100),
    status VARCHAR(20),
    owner VARCHAR(100),
    cost DECIMAL(10,2),
    purchase_date DATE,
    warranty_expiry DATE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE software_licenses (
    license_id VARCHAR(50) PRIMARY KEY,
    software_name VARCHAR(100) NOT NULL,
    vendor VARCHAR(100),
    license_type VARCHAR(50),
    license_key VARCHAR(200),
    seats INTEGER,
    used_seats INTEGER DEFAULT 0,
    expiry_date DATE,
    cost DECIMAL(10,2),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE asset_history (
    history_id INT AUTO_INCREMENT PRIMARY KEY,
    asset_id VARCHAR(50),
    action VARCHAR(50),
    description TEXT,
    user VARCHAR(100),
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (asset_id) REFERENCES assets(asset_id)
);

#!/bin/bash
# license_optimization.sh

# Check for unused software licenses
echo "Checking for unused software licenses..."

# Get installed software
INSTALLED_SOFTWARE=$(dpkg -l | grep "^ii" | awk '{print $2}')

# Check against license database
while IFS=',' read -r software_name license_type seats used_seats; do
    if [ "$license_type" = "per-seat" ]; then
        # Check if software is actually installed
        if ! echo "$INSTALLED_SOFTWARE" | grep -q "$software_name"; then
            echo "Unused license detected: $software_name"
            echo "Seats available: $seats"
            echo "Used seats: $used_seats"
        fi
    fi
done < software_licenses.csv

# Check for over-licensed software
echo "Checking for over-licensed software..."
while IFS=',' read -r software_name license_type seats used_seats; do
    if [ "$license_type" = "per-seat" ]; then
        if [ "$used_seats" -lt "$seats" ]; then
            UNUSED_SEATS=$((seats - used_seats))
            echo "Over-licensed software: $software_name"
            echo "Unused seats: $UNUSED_SEATS"
        fi
    fi
done < software_licenses.csv

# Check for expiring licenses
echo "Checking for expiring licenses..."
TODAY=$(date +%Y-%m-%d)
while IFS=',' read -r software_name license_type seats used_seats expiry_date; do
    if [ "$expiry_date" != "" ]; then
        DAYS_UNTIL_EXPIRY=$(( ($(date -d "$expiry_date" +%s) - $(date -d "$TODAY" +%s)) / 86400 ))
        if [ $DAYS_UNTIL_EXPIRY -lt 30 ]; then
            echo "License expiring soon: $software_name"
            echo "Expiry date: $expiry_date"
            echo "Days until expiry: $DAYS_UNTIL_EXPIRY"
        fi
    fi
done < software_licenses.csv

#!/bin/bash
# asset_deployment.sh

ASSET_ID="$1"
USER_NAME="$2"
LOCATION="$3"

# Update asset database
mysql -u root -p asset_management << EOF
UPDATE assets 
SET status = 'deployed', 
    owner = '$USER_NAME', 
    location = '$LOCATION',
    updated_at = NOW()
WHERE asset_id = '$ASSET_ID';
EOF

# Create deployment record
mysql -u root -p asset_management << EOF
INSERT INTO asset_history (asset_id, action, description, user)
VALUES ('$ASSET_ID', 'deployed', 'Asset deployed to $USER_NAME at $LOCATION', '$(whoami)');
EOF

# Send notification
echo "Asset $ASSET_ID has been deployed to $USER_NAME at $LOCATION" | \
    mail -s "Asset Deployment Notification" admin@company.com

echo "Asset $ASSET_ID deployed successfully"

#!/bin/bash
# support_ticket.sh

TICKET_ID="$1"
ASSET_ID="$2"
ISSUE_DESCRIPTION="$3"
PRIORITY="$4"

# Create support ticket
mysql -u root -p asset_management << EOF
INSERT INTO support_tickets (ticket_id, asset_id, issue_description, priority, status, created_at)
VALUES ('$TICKET_ID', '$ASSET_ID', '$ISSUE_DESCRIPTION', '$PRIORITY', 'open', NOW());
EOF

# Update asset status
mysql -u root -p asset_management << EOF
UPDATE assets 
SET status = 'maintenance',
    updated_at = NOW()
WHERE asset_id = '$ASSET_ID';
EOF

# Send notification based on priority
case $PRIORITY in
    "high")
        echo "High priority support ticket created for asset $ASSET_ID" | \
            mail -s "URGENT: Support Ticket $TICKET_ID" admin@company.com
        ;;
    "medium")
        echo "Medium priority support ticket created for asset $ASSET_ID" | \
            mail -s "Support Ticket $TICKET_ID" support@company.com
        ;;
    "low")
        echo "Low priority support ticket created for asset $ASSET_ID" | \
            mail -s "Support Ticket $TICKET_ID" support@company.com
        ;;
esac

echo "Support ticket $TICKET_ID created for asset $ASSET_ID"

#!/bin/bash
# data_sanitization.sh

ASSET_ID="$1"
DISPOSAL_METHOD="$2"

echo "Starting data sanitization for asset $ASSET_ID"

# Create sanitization log
LOG_FILE="/var/log/sanitization_${ASSET_ID}_$(date +%Y%m%d_%H%M%S).log"
echo "Data sanitization log for asset $ASSET_ID" > $LOG_FILE
echo "Started: $(date)" >> $LOG_FILE
echo "Method: $DISPOSAL_METHOD" >> $LOG_FILE

case $DISPOSAL_METHOD in
    "secure_erase")
        # Secure erase using ATA secure erase
        echo "Performing ATA secure erase..." >> $LOG_FILE
        hdparm --user-master u --security-set-pass p $ASSET_ID
        hdparm --user-master u --security-erase p $ASSET_ID
        ;;
    "dd_wipe")
        # Multiple pass wipe using dd
        echo "Performing multiple pass wipe..." >> $LOG_FILE
        dd if=/dev/zero of=/dev/$ASSET_ID bs=1M status=progress
        dd if=/dev/urandom of=/dev/$ASSET_ID bs=1M status=progress
        dd if=/dev/zero of=/dev/$ASSET_ID bs=1M status=progress
        ;;
    "physical_destruction")
        # Physical destruction
        echo "Asset marked for physical destruction" >> $LOG_FILE
        ;;
esac

# Verify sanitization
echo "Verifying sanitization..." >> $LOG_FILE
# Check if drive is readable
if [ -b /dev/$ASSET_ID ]; then
    echo "Drive still readable - sanitization may have failed" >> $LOG_FILE
else
    echo "Drive not readable - sanitization successful" >> $LOG_FILE
fi

# Update asset status
mysql -u root -p asset_management << EOF
UPDATE assets 
SET status = 'disposed',
    updated_at = NOW()
WHERE asset_id = '$ASSET_ID';

INSERT INTO asset_history (asset_id, action, description, user)
VALUES ('$ASSET_ID', 'disposed', 'Asset disposed - $DISPOSAL_METHOD', '$(whoami)');
EOF

echo "Data sanitization completed for asset $ASSET_ID"

#!/bin/bash
# asset_report.sh

REPORT_DATE=$(date +%Y%m%d)
REPORT_FILE="/var/log/asset_report_${REPORT_DATE}.html"

# Create HTML report
cat > $REPORT_FILE << EOF



    
    


    
IT Asset Management Report
    
Generated: $(date)
    
    

        
Executive Summary
        
Total Assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets;" -s -N)
        
Active Assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status='active';" -s -N)
        
Assets Under Maintenance: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status='maintenance';" -s -N)
        
Disposed Assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status='disposed';" -s -N)
    
    
    
Asset Status Distribution
    
EOF

# Add status distribution
mysql -u root -p asset_management -e "
SELECT status, COUNT(*) as count, 
       ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM assets), 2) as percentage
FROM assets 
GROUP BY status 
ORDER BY count DESC;" >> $REPORT_FILE

cat >> $REPORT_FILE << EOF
    

        
Status
Count
Percentage
    
    
Top 10 Most Expensive Assets
    
EOF

# Add expensive assets
mysql -u root -p asset_management -e "
SELECT asset_id, asset_name, asset_type, cost, status
FROM assets 
ORDER BY cost DESC 
LIMIT 10;" >> $REPORT_FILE

cat >> $REPORT_FILE << EOF
    

        
Asset ID
Name
Type
Cost
Status
    
    
Software License Summary
    
EOF

# Add license summary
mysql -u root -p asset_management -e "
SELECT software_name, vendor, seats, used_seats, (seats - used_seats) as available
FROM software_licenses 
ORDER BY software_name;" >> $REPORT_FILE

cat >> $REPORT_FILE << EOF
    

        
Software
Vendor
Total Seats
Used Seats
Available
    
    
Assets by Location
    
EOF

# Add location distribution
mysql -u root -p asset_management -e "
SELECT location, COUNT(*) as count
FROM assets 
WHERE location IS NOT NULL
GROUP BY location 
ORDER BY count DESC;" >> $REPORT_FILE

cat >> $REPORT_FILE << EOF
    

        
Location
Count


EOF

echo "Asset report generated: $REPORT_FILE"

-- Asset cost analysis queries

-- Total asset value by category
SELECT 
    category,
    COUNT(*) as asset_count,
    SUM(cost) as total_cost,
    AVG(cost) as avg_cost
FROM assets 
WHERE status != 'disposed'
GROUP BY category
ORDER BY total_cost DESC;

-- Asset depreciation calculation
SELECT 
    asset_id,
    asset_name,
    cost,
    purchase_date,
    DATEDIFF(CURDATE(), purchase_date) as days_owned,
    ROUND(cost * (1 - (DATEDIFF(CURDATE(), purchase_date) / 365.0) * 0.2), 2) as depreciated_value
FROM assets 
WHERE status != 'disposed'
ORDER BY depreciated_value DESC;

-- Software license cost analysis
SELECT 
    software_name,
    vendor,
    seats,
    used_seats,
    (seats - used_seats) as unused_seats,
    cost,
    ROUND(cost / seats, 2) as cost_per_seat,
    ROUND((cost / seats) * (seats - used_seats), 2) as wasted_cost
FROM software_licenses
WHERE seats > used_seats
ORDER BY wasted_cost DESC;

-- Asset utilization by department
SELECT 
    owner,
    COUNT(*) as asset_count,
    SUM(cost) as total_cost,
    AVG(cost) as avg_cost
FROM assets 
WHERE status = 'active'
GROUP BY owner
ORDER BY total_cost DESC;

#!/bin/bash
# audit_preparation.sh

AUDIT_DATE=$(date +%Y%m%d)
AUDIT_DIR="/var/log/audit_${AUDIT_DATE}"

# Create audit directory
mkdir -p $AUDIT_DIR

echo "Preparing audit documentation for $AUDIT_DATE"

# Export asset database
mysqldump -u root -p asset_management > $AUDIT_DIR/asset_database.sql

# Generate asset inventory
mysql -u root -p asset_management -e "
SELECT * FROM assets 
ORDER BY asset_id;" > $AUDIT_DIR/asset_inventory.csv

# Generate software license report
mysql -u root -p asset_management -e "
SELECT * FROM software_licenses 
ORDER BY software_name;" > $AUDIT_DIR/software_licenses.csv

# Generate asset history
mysql -u root -p asset_management -e "
SELECT * FROM asset_history 
ORDER BY timestamp DESC;" > $AUDIT_DIR/asset_history.csv

# Generate compliance report
cat > $AUDIT_DIR/compliance_report.txt << EOF
IT Asset Management Compliance Report
Generated: $(date)

1. Asset Inventory Accuracy
   - Total assets in database: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets;" -s -N)
   - Active assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status='active';" -s -N)
   - Disposed assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status='disposed';" -s -N)

2. Software License Compliance
   - Total software licenses: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM software_licenses;" -s -N)
   - Over-licensed software: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM software_licenses WHERE seats > used_seats;" -s -N)
   - Under-licensed software: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM software_licenses WHERE used_seats > seats;" -s -N)

3. Asset Lifecycle Management
   - Assets with missing information: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE serial_number IS NULL OR manufacturer IS NULL;" -s -N)
   - Assets with expired warranties: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE warranty_expiry < CURDATE();" -s -N)

4. Data Security
   - Assets with sensitive data: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE category IN ('server', 'workstation') AND status != 'disposed';" -s -N)
   - Properly disposed assets: $(mysql -u root -p asset_management -e "SELECT COUNT(*) FROM assets WHERE status = 'disposed';" -s -N)
EOF

echo "Audit documentation prepared in $AUDIT_DIR"