Advanced Search
Search Results
84 total results found
Kiwiplan
This is for anything to do with Kiwiplan's ERP systems
Wiki
This is for anything to do with knowledge base items to share.
Database Toolset
Toolset of tools and script for maintaining the databases. We also included scripts for different applications. Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies,...
Linux
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Kiwiplan
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Apache
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Microsoft
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Amtech
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Visual Studio
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Powershell
Anything to do with Powershell scripting. Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless...
All Others Stuff
Copyright Notice SFL Services LLC has prepared this document for use only by their staff, agents, customers and prospective customers. Companies, names and data used as examples in this document are fictitious unless otherwise noted. No part of this document ...
Raspberry Pi - SD card to a USB SSD
Install rpi-clone is on github and is downloaded by cloning the repository. It is a standalone script and the install is a simple copy to a bin directory. When run it checks its program dependencies and offers to install needed packages. But currently rpi-c...
ESP - Delete Old Messages
/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Created Status 1 FAILED 3 Sucessfull 6 History */ delete from infbigtext where foreignId <> 1 and lastchanged < dateadd(d,-5,getdate()) and foreigntype lik...
Linux - Setting up a Logging Server
Summary This is to setup a logging server to capture logs from any servers on your network. Prerequisites Install of a RedHat or Rocky Linux minimal install Configuration You will need to edit the file "/etc/rsyslog.conf" Editing the file vi /etc/rsyslo...
ESP - Database Copy Script
/* Search and replace for the ESP database and its folders Created By : SFL 08/13/23 Modified By : SFL 08/21/24 Use at own risk */ USE ESP_DEV; /* select * from infParameter where value like '%/%' select * from infPlantValue where value like '%...
ESP - Delete User
/* Delete users from ESP which do not exist in Active Directory Created By : Steve Ling 2024/03/07 The user name is the name from the SAM account in ADD Or if you do the following select select name from infuser */ Declare @username nvarchar...
ESP - Create Financial Year and Period
/* Script to auto add finacial year and its periods if they are missing Created By : Steve Ling 2024/03/02 You may have to change the stating year depending on your finacial year and periods */ GO Declare @y nvarchar(4), @yid int, @ly nvarchar(...
ESP - Add Notifications to All Active Companies
/* This script will add Notifications to all active companies Please run in SQLAgent every 15 minutes. Modified Steven F Ling 2019-11-27 Modified Steven F Ling 2023-08-14 */ DECLARE @companyid INT DECLARE @name VARCHAR(100) DECLARE @regionName VARC...
ESP - Delete Product Design in Imported Status
/************************************************ This script is to delete PD that do not have Orders on them and are in import status 20140207 Steven F Ling created 20230401 Steven F Ling Modified Changed for the new Database structure ********...
ESP - Delete Old Message
/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Created Status 6 = history 5 = 4 = processing 3 = success 2 = pending 1 = failed 0 = created */ delete from infbigtext where foreignId <> 1 and lastch...
SQL - Kill Database Connections
/* This is to kill off any connection to a database Created by : Steve Ling 2022/03/20 */ --This script will kill when ran USE MASTER GO DECLARE @Spid INT DECLARE @ExecSQL VARCHAR(255) DECLARE KillCursor CURSOR LOCAL STATIC READ_ONLY F...
Apache - Health Check
Server Health Commands Check TLS openssl s_client -connect <IP_ADDRESS>:8443 -tls1 nmap -sV --script ssl-enum-ciphers -p 8443 <IP_ADDRESS> Connections onto Server netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n ...
Apache - Enabling HTTPS w/Certificate
1. Getting the required software For an SSL encrypted web server you will need a few things. Depending on your install you may or may not have OpenSSL and mod_ssl, Apache's interface to OpenSSL. Use yum to get them if you need them. yum install mod_ssl op...
Visual Studio - Deploy to Linux
The only thing that you need to do do to deploy to Linux is too change the target runtime setting. This allows for the deployment to add the specific files to the folder.
Apache - Host Visual Studio .NET 8 Deployments
Introduction This is to prep the Linux server to host Visual Studio code. This is for either RedHat or Rocky Linux installations. For this configuration were are installing on a Rocky Linux server. Preparation Make sure that the server is up to date dnf...
Apache - Self Signed HTTPS Certificates
If you are starting to migrate your web servers over to Linux (or have already done so) and are looking to serve those pages up over secure http (aka https), you're going to need to know how to make this happen. Although https does will not guarantee security ...
Apache - Setting up an SSL secured Webserver w/Rocky Linux
This guide will explain how to set up a site over https. The tutorial uses a self signed key so will work well for a personal website or testing purposes. This is provided as is so proceed at your own risk and take backups! 1. Getting the required software F...
Visual Studio - Entity Framework Tips
dotnet tool install --global dotnet-efdotnet ef migrations add CreateInitialdotnet ef database update//https://www.youtube.com/watch?v=Fbf_ua2t6v4 Scaffold dotnet ef dbcontext scaffold "Data Source=mfb-us-sql-001;Initial Catalog=MyFFLBookAPI;TrustServerCerti...
Windows - Update additional resources
Try resetting the Windows Update Agent by running these commands from an elevated command prompt: net stop wuauserv rd /s /q %systemroot%\SoftwareDistribution net start wuauserv Reset Windows Update components manually Open a Windows command prompt. T...
Windows - How to delete the Recovery Partition
Unfortunately when there is no room on the disk to convert the drive from basic to dynamic. Microsoft documents the problem, and notes the solution is to delete the last partition on the disk: Not Enough Space Available to Upgrade to a Dynamic Disk RESOLU...
Linux - FTP Using Bash
Example of simple bash script ftp client This script first defines variables such as hostname of the ftp server, username and password and then it creates an ftp session and uploads the specified file into your selected directory: #!/bin/bash ftp_site=127...