HTTPS | Scripting and security

$signature = '[DllImport("user32.dll",SetLastError=true)]
public static extern bool LockWorkStation();'
$t = Add-Type -memberDefinition $signature -name api -namespace stuff -passthru
$null = $t::LockWorkStation()

$signature = '[DllImport("user32.dll",SetLastError=true)]

public static extern bool LockWorkStation();'

$t = Add-Type -memberDefinition $signature -name api -namespace stuff -passthru

$null = $t::LockWorkStation()

Fuente: https://community.idera.com/database-tools/powershell/powertips/b/tips/posts/locking-workstation-1

PowerShell

Determinar el tamaño de un fichero para descargar con PowerShell

20/07/201911/06/2019

function Ver-Tam
{
  [CmdletBinding()]
  param
  (
    [Parameter(Mandatory,ValueFromPipeline)]
    [String]
    $Url
  )
  
  process
  {
    $webRequest = [System.Net.WebRequest]::Create($Url)
    $response = $webRequest.GetResponse()
    $response.ContentLength
    $response.Dispose()
  }
}

Ver-Tam https://www.jesusninoc.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_over.gif

function Ver-Tam

{

[CmdletBinding()]

param

(

[Parameter(Mandatory,ValueFromPipeline)]

[String]

$Url

)

process

{

$webRequest = [System.Net.WebRequest]::Create($Url)

$response = $webRequest.GetResponse()

$response.ContentLength

$response.Dispose()

}

Ver-Tam https://www.jesusninoc.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_over.gif

PowerShell

Ejecutar un script de PowerShell creando un Acceso directo

12/07/201912/06/2019

# specify the path to your PowerShell script
$ScriptPath = "C:\test\test.ps1"

# create a lnk file
$shortcutPath = [System.IO.Path]::ChangeExtension($ScriptPath, "lnk")
$filename = [System.IO.Path]::GetFileName($ScriptPath)

# create a new shortcut
$shell = New-Object -ComObject WScript.Shell
$scut = $shell.CreateShortcut($shortcutPath)
# launch the script with powershell.exe:
$scut.TargetPath = "powershell.exe"
# skip profile scripts and enable execution policy for this one call
# IMPORTANT: specify only the script file name, not the complete path
$scut.Arguments = "-noprofile -executionpolicy bypass -file ""$filename"""
# IMPORTANT: leave the working directory empty. This way, the 
# shortcut uses relative paths 
$scut.WorkingDirectory = ""
# optinally specify a nice icon
$scut.IconLocation = "$env:windir\system32\shell32.dll,162"
# save shortcut file
$scut.Save()

# open shortcut file in File Explorer
explorer.exe "/select,$shortcutPath"

# specify the path to your PowerShell script

$ScriptPath = "C:\test\test.ps1"

# create a lnk file

$shortcutPath = [System.IO.Path]::ChangeExtension($ScriptPath, "lnk")

$filename = [System.IO.Path]::GetFileName($ScriptPath)

# create a new shortcut

$shell = New-Object -ComObject WScript.Shell

$scut = $shell.CreateShortcut($shortcutPath)

# launch the script with powershell.exe:

$scut.TargetPath = "powershell.exe"

# skip profile scripts and enable execution policy for this one call

# IMPORTANT: specify only the script file name, not the complete path

$scut.Arguments = "-noprofile -executionpolicy bypass -file ""$filename"""

# IMPORTANT: leave the working directory empty. This way, the

# shortcut uses relative paths

$scut.WorkingDirectory = ""

# optinally specify a nice icon

$scut.IconLocation = "$env:windir\system32\shell32.dll,162"

# save shortcut file

$scut.Save()

# open shortcut file in File Explorer

explorer.exe "/select,$shortcutPath"

FUENTE: https://community.idera.com/database-tools/powershell/powertips/b/tips/posts/launching-powershell-scripts-for-dummies

PowerShell

How to free up RAM from the command line

03/07/201902/07/2019

But if you think your PC is using more RAM than it should, then there is one small and very simple tool which might be able to help. Empty Standby List is a free command line application — from the developer of Process Hacker — which provides various ways to free up RAM. If you’re normally console-phobic, don’t worry, the program accepts only four commands. You can set it up to run from a shortcut or a batch file in a few seconds (just make sure it’s set to run as an administrator). More information: https://betanews.com/2016/03/11/how-to-free-up-ram-from-the-command-line/

Memory

Ver el mapa de memoria RAM con RAMMap

02/07/201902/07/2019

RAMMap sirve para comprender mejor la forma en que Windows administra la memoria, para analizar el uso de la memoria de la aplicación o para responder preguntas específicas sobre cómo se asigna la RAM. La función de actualización de RAMMap le permite actualizar la pantalla e incluye soporte para guardar y cargar instantáneas de memoria. Descargar RAMMap https://docs.microsoft.com/en-us/sysinternals/downloads/rammap

PowerShell

Abrir las categorías de una página web en WordPress que se listan mediante botones en un formulario de PowerShell

19/06/201907/06/2019

$buttons_functionslist=@(
    $json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
    $json.name
)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario
$Form = New-Object System.Windows.Forms.Form
$Form.Text="Formulario"
$Form.Size=New-Object System.Drawing.Size(500,500)
$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)
	{
	$thisbutton = New-Object System.Windows.Forms.Button
	[string]$thisbuttonname = $buttons_functionslist[$loop]
	$thisbutton.Text = $thisbuttonname
	$thisbutton.size = New-Object System.Drawing.Size(100,20)
	$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))
	$thisbutton.Add_Click({
            if($json.name.indexof($this.Text))
            {
                start chrome $json.link[$json.name.indexof($this.Text)]
            }
		})
	$Form.Controls.Add($thisbutton)
	$loop += 1
	}

$Form.ShowDialog()

$buttons_functionslist=@(

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON

$json.name

)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario

$Form = New-Object System.Windows.Forms.Form

$Form.Text="Formulario"

$Form.Size=New-Object System.Drawing.Size(500,500)

$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)

{

$thisbutton = New-Object System.Windows.Forms.Button

[string]$thisbuttonname = $buttons_functionslist[$loop]

$thisbutton.Text = $thisbuttonname

$thisbutton.size = New-Object System.Drawing.Size(100,20)

$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))

$thisbutton.Add_Click({

if($json.name.indexof($this.Text))

{

start chrome $json.link[$json.name.indexof($this.Text)]

}

})

$Form.Controls.Add($thisbutton)

$loop += 1

}

$Form.ShowDialog()

PowerShell Web Web scraping

Ver mediante una lista de botones en un formulario de PowerShell las categorías de una página en WordPress

17/06/201907/06/2019

$buttons_functionslist=@(
    $json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
    $json.name
)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario
$Form = New-Object System.Windows.Forms.Form
$Form.Text="Formulario"
$Form.Size=New-Object System.Drawing.Size(500,500)
$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)
	{
	$thisbutton = New-Object System.Windows.Forms.Button
	[string]$thisbuttonname = $buttons_functionslist[$loop]
	$thisbutton.Text = $thisbuttonname
	$thisbutton.size = New-Object System.Drawing.Size(100,20)
	$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))
	$thisbutton.Add_Click({
	        Write-Host $this.Text
		})
	$Form.Controls.Add($thisbutton)
	$loop += 1
	}

$Form.ShowDialog()

$buttons_functionslist=@(

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON

$json.name

)

$buttons_functionbuttoncount = $buttons_functionslist.count

$loop = 0

#Formulario

$Form = New-Object System.Windows.Forms.Form

$Form.Text="Formulario"

$Form.Size=New-Object System.Drawing.Size(500,500)

$Form.StartPosition="CenterScreen"

while($loop -lt $buttons_functionbuttoncount)

{

$thisbutton = New-Object System.Windows.Forms.Button

[string]$thisbuttonname = $buttons_functionslist[$loop]

$thisbutton.Text = $thisbuttonname

$thisbutton.size = New-Object System.Drawing.Size(100,20)

$thisbutton.Location = New-Object System.Drawing.Size(200,(20*$loop+1))

$thisbutton.Add_Click({

Write-Host $this.Text

})

$Form.Controls.Add($thisbutton)

$loop += 1

}

$Form.ShowDialog()

PowerShell Web

Listar las categorías de una página en WordPress con PowerShell

15/06/201907/06/2019

$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content | ConvertFrom-JSON
$json.name

1 2	$json=(Invoke-WebRequest -Uri 'https://www.jesusninoc.com/wp-json/wp/v2/categories').content \| ConvertFrom-JSON $json.name

Database PowerShell

Insertar en una base de datos las noticias de una página web (crear la base de datos y la tabla)

15/06/201915/06/2019

Crear la base de datos

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + "root"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query = 'create database bbc'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]

$Connection.Close()

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + "root"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

$Query = 'create database bbc'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0]

$Connection.Close()

Crear e insertar cada noticia en una tabla de la base de datos

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + "root" +  ";database="+"bbc"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query = 'create table titulo(titulo varchar(500) primary key)'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]

$url='https://www.bbc.com/news/'
$result = Invoke-WebRequest $url
$result.AllElements | Where Class -eq 'gs-c-promo-heading__title gel-pica-bold nw-o-link-split__text' | %{$_.innerText} | %{
$Query = "INSERT INTO titulo (titulo) values (""$_"")"
$Query
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]
}

$Connection.Close()

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + "root" + ";database="+"bbc"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

$Query = 'create table titulo(titulo varchar(500) primary key)'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0]

$url='https://www.bbc.com/news/'

$result = Invoke-WebRequest $url

$result.AllElements | Where Class -eq 'gs-c-promo-heading__title gel-pica-bold nw-o-link-split__text' | %{$_.innerText} | %{

$Query = "INSERT INTO titulo (titulo) values (""$_"")"

$Query

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0]

}

$Connection.Close()

Realizado por Ignacio Barranquero

PowerShell Web scraping

Mostrar noticias de una web con PowerShell

14/06/201914/06/2019

$url='https://www.bbc.com/news/'
$result = Invoke-WebRequest $url
$result.AllElements | Where Class -eq 'gs-c-promo-heading__title gel-pica-bold nw-o-link-split__text' | %{$_.innerText}

$url='https://www.bbc.com/news/'

$result = Invoke-WebRequest $url

$result.AllElements | Where Class -eq 'gs-c-promo-heading__title gel-pica-bold nw-o-link-split__text' | %{$_.innerText}

Older Posts