This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#requires -version 2 | |
<# | |
.SYNOPSIS | |
PowerShell script to check the status of a Windows service, and start the service if status is 'Stopped' | |
.DESCRIPTION | |
PowerShell script to check the status of a Windows service, and start the service if status is 'Stopped' | |
.PARAMETER <Parameter_Name> | |
None |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Create table for PGH 311 requests | |
create table if not exists pgh_311_requests ( | |
REQUEST_ID integer, | |
CREATED_ON varchar, | |
REQUEST_TYPE varchar, | |
REQUEST_ORIGIN varchar, | |
STATUS integer, | |
DEPARTMENT varchar, | |
NEIGHBORHOOD varchar, | |
COUNCIL_DISTRICT integer, |
OlderNewer