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
| $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 |
| @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 |
| 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, |
| /* 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) |