12/11/2014 | Scripting and security

Read in a Comma-Separated Values File

(No Ratings Yet)

The Import-Csv cmdlet provides a way for you to read in data from a comma-separated values file (CSV) and then display that data in tabular format within the Windows PowerShell console. For example, suppose you have a file named C:\Scripts\Test.txt, a file that contains the following data:

Name,Department,Title
Paula Marín,Research,Manager
Juan Hana,Finance,Finance Specialist
Carlos Abel,Finance,Accountant

Name,Department,Title

Paula Marín,Research,Manager

Juan Hana,Finance,Finance Specialist

Carlos Abel,Finance,Accountant

You say you’d like to view that data on-screen, and in a table, to boot? Then just call Import-Csv followed by the path to the file you want to open:

Import-Csv c:\scripts\test.txt

1	Import-Csv c:\scripts\test.txt

In turn, Windows PowerShell will give you output that looks like this:

Name                       Department                 Title
----                       ----------                 -----
Paula Marín             Research                   Manager
Juan Hana              Finance                    Finance Specialist
Carlos Abel                   Finance                    Accountant

Name Department Title

---- ---------- -----

Paula Marín Research Manager

Juan Hana Finance Finance Specialist

Carlos Abel Finance Accountant

That’s cool. But if you really want to […]

Understanding Linux CPU Load – when should you be worried?

(No Ratings Yet)

You might be familiar with Linux load averages already. Load averages are the three numbers shown with the uptime and top commands – they look like this:

load average: 0.09, 0.05, 0.01

1	load average: 0.09, 0.05, 0.01

Most people have an inkling of what the load averages mean: the three numbers represent averages over progressively longer periods of time (one, five, and fifteen minute averages), and that lower numbers are better. Higher numbers represent a problem or an overloaded machine. But, what’s the the threshold? What constitutes “good” and “bad” load average values? When should you be concerned over a load average value, and when should you scramble to […]

Last Longon Time and Display Name in Exchange Online

(No Ratings Yet)

#Important
#Necessary: Microsoft Online Services Sign-In Assistant for IT Professionals RTW
#The Microsoft Online Services Sign-In Assistant provides end user sign-in capabilities to Microsoft Online Services, such as Office 365.
#Link: https://www.microsoft.com/en-gb/download/details.aspx?id=28177
#If you have problems with MSOnline: MSOnline can't be imported on PowerShell (Connect-MsolService error)

#Connect to Exchange Online
Import-Module MSOnline
Get-Module
$O365Cred = Get-Credential
$O365Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://pod50248psh.outlook.com/powershell-liveid?PSVersion=4.0 -Credential $O365Cred -Authentication Basic -AllowRedirection
Import-PSSession $O365Session
Connect-MsolService –Credential $O365Cred

#Last Longon Time and Display Name in Exchange Online
$mail = (Get-Mailbox | Get-MailboxStatistics)

#Save information and convert to CSV
$mail | Select-Object DisplayName, LastLogonTime | ConvertTo-Csv | Out-File F:\fich.csv

#Important

#Necessary: Microsoft Online Services Sign-In Assistant for IT Professionals RTW

#The Microsoft Online Services Sign-In Assistant provides end user sign-in capabilities to Microsoft Online Services, such as Office 365.

#Link: https://www.microsoft.com/en-gb/download/details.aspx?id=28177

#If you have problems with MSOnline: MSOnline can't be imported on PowerShell (Connect-MsolService error)

#Connect to Exchange Online

Import-Module MSOnline

Get-Module

$O365Cred = Get-Credential

$O365Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://pod50248psh.outlook.com/powershell-liveid?PSVersion=4.0 -Credential $O365Cred -Authentication Basic -AllowRedirection

Import-PSSession $O365Session

Connect-MsolService –Credential $O365Cred

#Last Longon Time and Display Name in Exchange Online

$mail = (Get-Mailbox | Get-MailboxStatistics)

#Save information and convert to CSV

$mail | Select-Object DisplayName, LastLogonTime | ConvertTo-Csv | Out-File F:\fich.csv

Searching the Registry: IP addresses

(No Ratings Yet)

Write-Host "IP addresses:`n"
Get-ChildItem HKCU:\ -rec -ea SilentlyContinue | ForEach-Object {
Select-String "\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b" -input (Get-ItemProperty -Path $_.PsPath) -AllMatches | ForEach-Object {($_.matches)|Select-Object Value}
}

Write-Host "IP addresses:`n"

Get-ChildItem HKCU:\ -rec -ea SilentlyContinue | ForEach-Object {

Select-String "\b\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}\b" -input (Get-ItemProperty -Path $_.PsPath) -AllMatches | ForEach-Object {($_.matches)|Select-Object Value}

}