Skip to content

Instantly share code, notes, and snippets.

Daniel Streefkerk dstreefkerk

Block or report user

Report or block dstreefkerk

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
dstreefkerk / Generate-SpiceworksTicketReports.ps1
Last active Jul 16, 2019
Generate-SpiceworksTicketReports.ps1 - A PowerShell to generate reports about tickets in Spiceworks via SQLite
View Generate-SpiceworksTicketReports.ps1
#requires -version 3
Generate-SpiceworksTicketReports.ps1 - Spiceworks open ticket reporting
Reads the SpiceWorks database to generate emails about open tickets. Sends an email to each
operator with their open tickets.
Requires the SQLite PowerShell provider:
View Manage-WifiStatus.ps1
#Requires -Version 4.0 -RunAsAdministrator
Manage-WiFiStatus.ps1 - Enable/Disable WiFi based on wired connectivity status
Disables the Wi-Fi adapter if the wired one is connected, and vice versa.
This is built for internal use on Windows 8.1, and depends on the new *-NetAdapter cmdlets in PS 4.0
dstreefkerk / Enable-DisabledOfficeAddins.ps1
Last active Feb 6, 2018
PowerShell script designed to run at the machine-level to re-enable troublesome add-ins that often get disabled by Office. By default this script is looking for add-ins that relate to HP Interwoven WorkSite.
View Enable-DisabledOfficeAddins.ps1
Enable-DisabledOfficeAddins.ps1 - Enable specific Office add-ins
Re-enables specific Microsoft Office add-ins that are:
1. Listed in Disabled Items
2. Disabled in COM Add-Ins
This is designed to re-enable troublesome add-ins that often get disabled by Office. In this case,
View Get-ProliantDiskDrives.ps1
#requires -version 3
Get-ProliantDiskDrives - Get HP ProLiant disk drive status for PRTG
Reads the status of HP ProLiant Smart Array disk drives via WMI and HP WBEM
View Get-ProliantTemperatures.ps1
#requires -version 3
Get-ProliantTemperatures - Get HP ProLiant temperature sensor readings and status for PRTG
Reads the status of HP ProLiant temperatures sensors via WMI and HP WBEM
dstreefkerk / Migrate-OfficescanClient.ps1
Created May 2, 2014
Computer startup or PS Remoting script to migrate an installed Officescan client to another server if it's currently pointed at a different one.
View Migrate-OfficescanClient.ps1
Migrate-OfficescanClient - Migrate Officescan clients to the correct server
Checks which server the Officescan client is pointing to (by reading ofcscan.ini)
If it's pointing to the wrong one, call the appropriate ipxfer command with
the correct parameters to point it to the new/correct server
dstreefkerk / Remove-FilesiteViews.ps1
Created Nov 21, 2014
Remove VDM files for all users, for HP FileSite for Outlook
View Remove-FilesiteViews.ps1
Remove-FilesiteViews.ps1 - Remove VDM files for all users
This script is designed to be run under the SYSTEM account, as it needs
access to every user's profile. This will work fine as a scheduled task, or
under SCCM or similar.
As per the release notes for Filesite 9.0 Update 5, all VDM files need to be deleted
dstreefkerk / Update-GeckoboardDashboard.ps1
Created Dec 5, 2014
Spiceworks Geckoboard Wrapper Script
View 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
dstreefkerk / Spiceworks_Geckoboard-TicketsOpen.ps1
Created Dec 5, 2014
Tickets Open widget update code. To be used with a "Number and Secondary Stat" widget:
View Spiceworks_Geckoboard-TicketsOpen.ps1
$apikey = "paste in your API key here"
$geckoPushUrl = "paste in your push URL here"
# Get the count of open tickets from the database
$openTickets = Invoke-Item spiceworks: -sql 'select count() as "count" from tickets where status == "open"'
#Construct a here-string with the required json format
$jsonstream = @"
dstreefkerk / Spiceworks_Geckoboard-TicketList.ps1
Created Dec 5, 2014
Ticket List Widget update code, to be used with a List Widget:
View Spiceworks_Geckoboard-TicketList.ps1
$query = @"
select as id,t.summary as summary,t.description as description,u.first_name || ' ' || u.last_name as name, round((julianday(date('now','localtime')) - julianday(t.created_at))) + 1 as days, t.category as category from tickets as t
inner join users as u on t.created_by =
where status == 'open'
order by t.created_at desc
$apikey = "paste API key here"
$geckoPushUrl = "paste push URL here"
You can’t perform that action at this time.