adaz fucked around with this message at 01:26 on Mar 8, 2012

############
# SQL Data #
############
function Get-SqlData
{
param(
[parameter(Mandatory=$true,HelpMessage="SQL Server to connect to.")]
[string]$serverName,

[parameter(mandatory=$true,HelpMessage="SQL DB")]
[string]$databaseName,

[parameter(mandatory=$true,HelpMessage="SQL Query to run.")]
[string]$query
)
    $SQLDT = New-Object "System.Data.DataTable"
    $connString = "Server=$serverName;Database=$databaseName;Integrated Security=SSPI;"
    $da = New-Object "System.Data.SqlClient.SqlDataAdapter" ($query,$connString)
    [void]$da.fill($sqlDt)
    return $sqlDt
}

# Execute our SQL Query and store the data in the $queryResults variable.
$queryResults = Get-SqlData -server sqlserver -database databasename -query "select firstname,lastname from employees where lastname like 'd%'"

# Initialize our array which we will use to store then data and then
# to pipe to Export-CSv
$exportTable = @()

# add the result sets to the array
foreach($result in $queryResults) {
   # shorthand method of creating an object with two properties called 
   # firstname, lastname.
   $OutObj = "" | select firstname,lastname
   # set the properties on each object.
   $outObj.Firstname = $result.firstname
   $outObj.lastName = $result.Lastname
   #add the Object to our array for later exporting
   $exportTable += $outObj
}
# Export out to CSV
$exportTable | export-Csv C:\blah\blah.csv -noTypeInformation

adaz fucked around with this message at 01:44 on Mar 8, 2012

Using System.Drawing

[void]([reflection.assembly]::loadfile
("C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Drawing.dll"))
OR
[void]([reflection.assembly]::loadfile
("C:\Windows\Microsoft.NET\Framework\v2.0.50727\wiascr.dll"))

Scaramouche fucked around with this message at 01:40 on Mar 13, 2012

Function Resize-Jpeg {
param($path)

    $fileInfo = get-ChildItem $path
    $oldJpeg = new-Object system.drawing.bitmap $path
    
    # we need to resize our jpegs to be 300 by x where x is whatever the proper ratio is depending on if the jpeg is size
    # height or width wise in dimension.
    
    If($oldjpeg.height -lt $oldjpeg.width) {
        $factor = $oldjpeg.height / $oldjpeg.width
        [int]$newHeight =  300 * $factor
        [int]$newWidth = 300
    } else {
        $factor = $oldjpeg.width / $oldjpeg.height
        [int]$newWidth = 300 * $factor
        [int]$newHeight = 300
    }
    $thumbNail = $oldJpeg.GetThumbnailImage($newWidth,$newHeight,$null,[intptr]::zero)
    $encoderParams = New-Object System.Drawing.Imaging.EncoderParameters(1) 
    $qualityEncoder = [System.Drawing.Imaging.Encoder]::Quality
    $encoderParams.Param[0] = New-Object System.Drawing.Imaging.EncoderParameter($qualityEncoder, 75)
    $CodecInfo = [System.Drawing.Imaging.ImageCodecInfo]::GetImageEncoders()|where {$_.MimeType -eq 'image/jpeg'}    
    $thumbnail.save("c:\temp\testthumb.jpg",$codecInfo,$($encoderParams))
    
    return [byte[]]$file = Get-Content "c:\temp\testthumb.jpg" -Encoding Byte
    
}

$adObj = [adsi]"LDAP://CN=Blah,ou=blah,ou=blah,dc=blah,dc=com"
$adObj.Children

# iterate through the children
foreach($child in $adobj.children) {
  $child # do stuff
}

adaz fucked around with this message at 19:14 on Mar 13, 2012

try {
 # put code here
} catch {
     $smtp = new-object Net.Mail.SmtpClient("smtp server here")
    $msg = new-Object Net.Mail.MailMessage
    $msg.From = "email address here"
    $msg.body = "body here  -- error will be stored in the $error variable" 
    $msg.To.Add("emailto here")
    $msg.Subject = "subject" 
    $smtp.Send($msg)
}

$smtp = new-object Net.Mail.SmtpClient("smtp.server")
$smtp.UsedefaultCredentials = $true

$msg = new-Object Net.Mail.MailMessage
$msg.From = "blah@contoso.com"
$msg.body = "Words and stuff" 
$msg.To.Add("blah@contoso.com")
$att = new-Object Net.Mail.Attachment(C:\path\To\Log.File)
$msg.Attachments.Add($Att)
$msg.Subject = "Subject" 
$smtp.Send($msg)

adaz fucked around with this message at 19:48 on Mar 14, 2012

adaz fucked around with this message at 18:25 on Mar 15, 2012

At C:\temp\f40ee6ff-e305-417d-9aac-6b2221edaa8c.ps1:3 char:25

+ ConvertFrom-SecureString <<<<  $password | Set-Content C:\myDirectory\credentials.txt
    + CategoryInfo          : NotSpecified: (:) [ConvertFrom-SecureString], CryptographicException
    + FullyQualifiedErrorId : System.Security.Cryptography.CryptographicException,Microsoft.PowerShell.Commands.ConvertFromSecureStringCommand

stubblyhead fucked around with this message at 18:39 on Mar 15, 2012

adaz fucked around with this message at 00:33 on Mar 16, 2012

$string = "text

Jelmylicious fucked around with this message at 13:35 on Mar 22, 2012