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
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
<#
.SYNOPSIS
Generate-SpiceworksTicketReports.ps1 - Spiceworks open ticket reporting
.DESCRIPTION
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: https://psqlite.codeplex.com/
View Manage-WifiStatus.ps1
#Requires -Version 4.0 -RunAsAdministrator
<#
.SYNOPSIS
Manage-WiFiStatus.ps1 - Enable/Disable WiFi based on wired connectivity status
.DESCRIPTION
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
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
<#
.SYNOPSIS
Enable-DisabledOfficeAddins.ps1 - Enable specific Office add-ins
.DESCRIPTION
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
<#
.SYNOPSIS
Get-ProliantDiskDrives - Get HP ProLiant disk drive status for PRTG
.DESCRIPTION
Reads the status of HP ProLiant Smart Array disk drives via WMI and HP WBEM
http://www.hp.com/go/HPwbem
View Get-ProliantTemperatures.ps1
#requires -version 3
<#
.SYNOPSIS
Get-ProliantTemperatures - Get HP ProLiant temperature sensor readings and status for PRTG
.DESCRIPTION
Reads the status of HP ProLiant temperatures sensors via WMI and HP WBEM
and
http://www.hp.com/go/HPwbem
@dstreefkerk
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
<#
.SYNOPSIS
Migrate-OfficescanClient - Migrate Officescan clients to the correct server
.DESCRIPTION
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
dstreefkerk / Remove-FilesiteViews.ps1
Created Nov 21, 2014
Remove VDM files for all users, for HP FileSite for Outlook
View Remove-FilesiteViews.ps1
<#
.SYNOPSIS
Remove-FilesiteViews.ps1 - Remove VDM files for all users
.DESCRIPTION
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
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
dstreefkerk / Spiceworks_Geckoboard-TicketsOpen.ps1
Created Dec 5, 2014
Tickets Open widget update code. To be used with a "Number and Secondary Stat" widget: https://developer.geckoboard.com/#number-and-secondary-stat
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 = @"
{
"api_key":"APIKEY",
@dstreefkerk
dstreefkerk / Spiceworks_Geckoboard-TicketList.ps1
Created Dec 5, 2014
Ticket List Widget update code, to be used with a List Widget: https://developer.geckoboard.com/#list
View Spiceworks_Geckoboard-TicketList.ps1
$query = @"
select t.id 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 = u.id
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.