Powershell script to list last modified files in x days

Let’s say you want to list of files from directory which are modified in last 2 to 3 days with certain extensions. like I would like to list all php files from directory C:\development modified in last 2 days

following PS command gives me exactly that.

PS> C:
PS> cd development
PS> $dtCompare = (Get-Date).AddDays(-3)
PS> get-childitem –recurse | where-object {$_.lastwritetime -gt $dtCompare -and $_.extension -eq “.php”}


Powershell script to connect to sql server

Sample Script

This script provides easy variables to add server name, db name and your SQL query

Save in notepad with a .ps1 extension
Change the server name and query to desired value
Save and run from a PowerShell prompt

$SQLServer = "MySQLServer" #use Server\Instance for named SQL instances! 
$SQLDBName = "MyDBName"
$SqlQuery = "select * from authors WHERE Name = 'John Simon'"

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; 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