TechnoGist

www.xkcd.com

Original was here.

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

I have started to look at performance and charge back visualization options for my environment. The final result would be a web portal/dashboard providing visual data for my peers and management. I have been following a project on “CodePlex” called “PoshBoard” by Antoine Habert.

The author Antoine Habert describes it as a,

“PowerShell Dashboard is a modular IT web portal based onPowerShell and Silverlight controls”

I will be starting to look at “PoshBoard” and will be posting my progress, I am really impressed with this project.

Links:

Site: http://www.poshboard.com/
Author “Antoine Habert” Blog: http://www.devinfra.blogspot.com/

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

“Please note that the beeping noise coming from the doors means that the doors are about to close.
It does not mean throw yourself or your bags into the doors.”

All information is provided on an AS-IS basis, with no warranties and confers no rights.

Installing VMWare Fusion 3.X.X Tools onto Windows 2008 Core edition.

• Select ‘VMWare/Virtual Machine/Install VMWare Tools’ to mount the ISO.
• On the command line change disk to the D:\> drive.
• Run either the D:\>Setup.exe or D:\>Setup64.exe depending on the OS version installed.
• Follow all prompts as normal.

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

If you need “Remote System Administration Tools” for Microsoft Windows 7, you can download it here.

This enables remote management for Windows Server 2008 R2, 2008 and 2003 from a Windows 7 Client machine.

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

Screen Capture in MAC OSX . [Unsure of previous version compatibility]

• Capture the entire desktop to a file.
  • Press Command-Shift-3.
• Capture the entire desktop to the clipboard.
  • Press Command-Control-Shift-3.
• Capture a portion of the desktop to a file. [Use the cursor to select the area for capture.]
  • Press Command-Shift-4
• Capture a specific application window to a file. [Select the application window with the camera.]
  • Press Command-Shift-4, then press the Spacebar.

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

“Let the passengers off the train FIRST!” (Pause.) “Oh go on then,
stuff yourselves in like sardines, see if I care — I’m going home….”

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

I was sent this and it made my day.

Original was here.

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.

At the height of the gale, the harbourmaster radioed a coastguard on the spot and asked him to estimate the wind speed. He replied that he was sorry, but he didn’t have a gauge. However, if it was any help, the wind had just blown his Land Rover off the cliff.

(Aberdeen Evening Express)

Today I was looking at producing a report from a SQL2005 database and exporting the SQL data into a CSV file. Once completed I would be sending the CSV file to a member of my team via Email. As this is a common request I wanted to automate this with PowerShell.

I had posted previously on basic database connectivity with PowerShell here and using that code as a basis I wrote a PowerShell script that connects to the SQL database and extracts the data into an SQLDataAdapter. The required table is selected and imported into a hash table, and then exported to a CSV file. This file is then attached to an email using the .NET SMTP Mail object and sent on its way via SMTP.

Download Script at PoshCode.org

Code:

#Connection Strings
$Database = "Database"
$Server = "SQLServer"
#SMTP Relay Server
$SMTPServer = "smtp.domain.com"
#Export File
$AttachmentPath = "C:\SQLData.csv"
# Connect to SQL and query data, extract data to SQL Adapter
$SqlQuery = "SELECT * FROM dbo.Test_Table"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Data Source=$Server;Initial Catalog=$Database;Integrated Security = True"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $SqlQuery
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$nRecs = $SqlAdapter.Fill($DataSet)
$nRecs | Out-Null
#Populate Hash Table
$objTable = $DataSet.Tables[0]
#Export Hash Table to CSV File
$objTable | Export-CSV $AttachmentPath
#Send SMTP Message
$Mailer = new-object Net.Mail.SMTPclient($SMTPServer)
$From = "email1@domain.com"
$To = "email2@domain.com"
$Subject = "Test Subject"
$Body = "Body Test"
$Msg = new-object Net.Mail.MailMessage($From,$To,$Subject,$Body)
$Msg.IsBodyHTML = $False
$Attachment = new-object Net.Mail.Attachment($AttachmentPath)
$Msg.attachments.add($Attachment)
$Mailer.send($Msg)

Hope this helps.

All information is provided on an AS-IS basis, with no warranties and confers no rights.