Search Results

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details Prerequisites VMware, KVM, Hyper-V machine to host the installation You will need to use the following command when you vi your files as you cut and paste: On...

This is a script to import databases, logs and preference bundles from a backup file generated from a datadump script. Name: importdata Script: #!/bin/bash #Type:Utility ######################################################### # Script: # # This is t...

This script is to get a backup of all databases to either send them to a test server, just a backup or send them for support. Name: datadump Script: #!/bin/bash ############################################################################## # # Added by ...

This removes failed jobs requests after 1 month that users are not cleaning up themselves. /* This script will clean up the agent errors that we are not looking for every day. Please run in SQLAgent every day. Created Steven F Ling 2021-06-22 */ --s...

Prequisites Minimal Installed RHEL 9 with Desktop Environment Sudo user with admin rights Local Yum Repository or Red Hat Subscription Internet Connectivity (for Red Hat Subscription) Once the prerequisites are met then jump into installatio...

SearchCtrl+K Chat Ctrl+J Voice Files Tasks Projects History Today This Week July Add logic to change the link on my pictures, my music, my videos @echo off echo Mapping Synology NAS drives... :: Map Document drive net use F: \\192.168.1.20...

NFS Server Configuration Install NFS Utilities. sudo dnf install nfs-utils Create the Shared Directory. sudo mkdir -p /nfs/exports/myshare (Replace /nfs/exports/myshare with your desired path.)Configure NFS Exports: Edit the /etc/exports file to define th...

The document is walk you through the re-mapping or combining of mapped drives on a Linux server. This is to make the root drive aka "/" drive one drive to be able to use the space of the full drive. First you will have to look at the current setup sudo fdis...

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details Prerequisites VMware, KVM, Hyper-V machine to host the installation You will need to use the following command when you vi your files as you cut and paste: On...

MAXPROC=999 TERM=vt100 KIDSLOGDIR=$PLANT/tmpKIDSLOGMAX=1000000KIDSLOGLEVEL=-4 The KWSQL_LOG variable is a system-level setting in Kiwiplan that controls logging options for the SQL interface, although ISAM can also utilize these logs. It allows you to speci...

On any Powered Off VM, click the "Advanced Parameters" tab. Click filter icon of Attribute column. Search for 3 items' names, check if they already exist. If yes, edit their corresponding values. If not, add them from the textboxs above. Name...

This script is based on this initial loadmon script This is to monitor specific objects at a Advantive/Kiwiplan sites It will send something like this for PCS #!/bin/bash ############################################ # # Author: Steve Ling 5/2/25 # M...

This is to monitor various objects on a given server and email notifications out when thresholds are exceeded IT will send out something like this #!/bin/bash ############################################ # # Author: Steve Ling 5/2/25 # # Purpose: Moni...

Installing Network UPS Tools (NUT) version 2.8.3 from source on a Raspberry Pi 4 running Raspberry Pi OS (based on Debian) requires compiling the software from the source code, as a pre-built Debian package for this specific version may not be available. Below...

Steps to Restore the master Database: Stop the SQL Server Instance: Open SQL Server Configuration Manager or Windows Services. Locate the SQL Server service (e.g., SQL Server (MSSQLSERVER) for a default instance). Stop the service. ...

This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID UNIQUEIDENTIFIER DECLARE @SchedulerID Int SELECT @JobID = job_id FROM ErangaMSDB.dbo.sysjobs WHERE NAME='Restore IPay' --- Insert the jobs INSERT msdb.dbo.sys...

BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction -- e.g., INSERT, UPDATE, DELETE statements COMMIT TRANSACTION; END TRY BEGIN CATCH -- Error handling logic IF @@TRANCOUNT > 0 BEGIN ...

Your best, easiest and most globally available tool: telnet or Windows CMD At command prompt, type: telnet mail.mailserver.com 25 Type EHLO , and then press ENTER. Type AUTH LOGIN. The server responds with an encrypted prompt for your user name. Enter ...

These scripts are using to help how to determine what is blocking process are occurring. SELECT text,* FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) WHERE DB_NAME(database_id) = '[dBName]' AND blocking_session_id <> 0 ...

Installing ImageMagick 7 from Source Code To install ImageMagick from source, you need a proper development environment with a compiler and related development tools. If you don’t have the required packages on your system, install development tools as shown: ...