Note: you must be connected to a system via serial console
- Type following commands in boot console to perform a conversational boot:
B /R5:1 DKA300
SET/STARTUP OPA0:
SET WINDOW_SYSTEM 0
SET WRITESYSPARAMS 0
CONTINUE
/* Create function */ | |
CREATE FUNCTION [dbo].[fn_GetUnixTimestamp] | |
( | |
@CT DATETIME | |
) | |
RETURNS BIGINT | |
AS | |
BEGIN | |
DECLARE @CTS BIGINT | |
SELECT @CTS = (CAST(DATEDIFF(second, '1970-01-01', CAST(GetUtcDate() AS date)) AS bigint)*1000) |
USE TestDatabase | |
/* Create tables */ | |
CREATE TABLE [dbo].[TParent]( | |
[id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY, | |
[name] [nvarchar](300) NULL | |
) | |
CREATE TABLE [dbo].[TChild]( | |
[id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY, |
@ECHO OFF | |
SET CONFIGFILE=config.txt | |
REM Create the key-value config file | |
ECHO #Simple key-value config > %CONFIGFILE% | |
ECHO Key1=Value1 >> %CONFIGFILE% | |
ECHO Key2=Value2 >> %CONFIGFILE% | |
REM Read keys and setting values |
$username='admin' | |
$password='s3cr3t' | |
$WebResponce = Invoke-WebRequest -Uri "http://192.168.1.1/" ` | |
-Headers @{"Authorization" = "Basic "+[System.Convert]::ToBase64String([System.Text.Encoding]::UTF8.GetBytes($username+":"+$password))} ` | |
-OutFile .\pstest.txt |