- Install Ubuntu 18.04 server
- Follow github instructions to add a runner by going to a repository settings and creating a new self-hosted runner
- Edit the yml file to start a first run on it (which will probably fail due to lacking build tools)
DECLARE @UserId int | |
DECLARE @PortalId int | |
SET @PortalId = 6 -- <<<< Adjust to your portal ID | |
DECLARE @Authorized bit | |
SET @Authorized = 0 -- <<<< Adjust if you want the users to be authorized or not | |
DECLARE MY_CURSOR CURSOR | |
LOCAL STATIC READ_ONLY FORWARD_ONLY | |
FOR | |
SELECT DISTINCT UserID |
The first line of this script will connect to sql server and backup all databases with the Full option. The first line will delete any existing backup in the folder that is more than 5 days old (you can change the value 5 to whatever suites your needs).
param ( | |
[string]$rootPath = (Get-Location).Path, | |
[int]$maxDepth = 3, | |
[int]$maxFoldersPerLevel = 4, | |
[int]$maxFilesPerFolder = 5 | |
) | |
function New-RandomDirectoryStructure { | |
param ( | |
[string]$rootPath, |
This is a DDR Menu template to export a text format of a DNN site pages to reuse in the "Create Multiple Pages" feature on another site.
# Set the path to the 7-Zip executable | |
$zipExePath = "C:\Program Files\7-Zip\7z.exe" | |
# Define the parent directory from which child folders will be listed | |
$parentDirectory = "C:\wwwroot" | |
# List all child directories | |
$directories = Get-ChildItem -Path $parentDirectory -Directory | |
# Check if there are any directories found |