Tickets Open widget update code. To be used with a "Number and Secondary Stat" widget: https://developer.geckoboard.com/#number-and-secondary-stat

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",
  "data": {
     "type" : "reverse",
     "item" : 
      [ 
        { "text" : "TICKETTEXT","value" : TICKETSOPENVALUE}
      ]
  }
}
"@

$ticketText = if ($newToday.count -eq 1) { "Ticket Open" } else { "Tickets Open" }
 
$jsonstream = $jsonstream.Replace("TICKETSOPENVALUE",$($openTickets.count))
$jsonstream = $jsonstream.Replace("APIKEY",$apikey)
$jsonstream = $jsonstream.Replace("TICKETTEXT",$ticketText)
 
#The line of code will only work in PowerShell V3
#Invoke-WebRequest -Method Post -Body $jsonstream -Uri $geckoPushUrl
 
#This should work in V2 also
$client = new-object system.net.webclient
$client.UploadString($geckoPushUrl,$jsonstream)