Spiceworks Geckoboard Wrapper Script

Update-GeckoboardDashboard.ps1

Import-Module sqlite

$scriptLocation = "C:\Scripts\Spiceworks-Geckoboard\"
$spiceworksDatabaseFilePath = "C:\Program Files (x86)\Spiceworks\db\spiceworks_prod.db" # Path to the SQLite database used by SpiceWorks

# Get all of the widget scripts
$allScripts = Get-ChildItem $scriptLocation -Filter "*.ps1"

# Mount the SpiceWorks database
mount-sqlite -name SpiceWorks -dataSource $spiceworksDatabaseFilePath

# Execute each script
foreach ($script in $allScripts) {
    Write-Host "Executing $($script.FullName)"
    & $script.FullName
}

Remove-PSDrive SpiceWorks