jeroenmaes

# Path where to create the biztalk groups and service accounts
$BtsOuPath = "OU=BizTalk,OU=Service Accounts,DC=LABO,DC=local"
# Path where to create the biztalk admin user
$AdminOuPath = "CN=Users,DC=LABO,DC=local"
 
$DomainAdmin = "JMADMIN"
$BtsAdmin = "BTSADMIN"
 
# Convert the plain text passwords
$BtsAdminPassword = ConvertTo-SecureString "P@$$w0rd0" -AsPlainText -Force

jeroenmaes

Function CreateHost($strHostName, $boolIsTrackingHost)
{
    Set-Location 'BizTalk:\Platform Settings\Hosts'
 
    New-Item -Path:$strHostName -HostType:'InProcess' -NtGroupName: $DomainName'\BizTalk Application Users' -AuthTrusted:$false
    Set-ItemProperty -Path:$strHostName -Name:HostTracking -Value:$boolIsTrackingHost
    Set-ItemProperty -Path:$strHostName -Name:Is32BitOnly -Value:$false
 
    Cd \
}

jeroenmaes

USE [EsbExceptionDb]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[usp_delete_Faults]

jeroenmaes

USE EsbExceptionDb
GO
GRANT SELECT ON [dbo].[Alert] TO [ESBPortal]
GO
GRANT SELECT ON [dbo].[Alert] TO [ESBPortalAdmin]
GO
GRANT SELECT,INSERT,UPDATE,DELETE ON [dbo].[AlertCondition] TO [ESBPortal]
GO
GRANT SELECT,INSERT,UPDATE,DELETE ON [dbo].[AlertCondition] TO [ESBPortalAdmin]
GO

jeroenmaes

DECLARE @msgtype_in varchar(255);
DECLARE @msgtype_out varchar(255);

set @msgtype_in = 'http://schemas.adventureworks.com/AX/AXPurchaseOrder#AXPurchaseOrder'
set @msgtype_out = 'http://schemas.adventureworks.com/XMLGate/OrderRequest#XMLGateOrderRequest'

USE BizTalkMgmtDb

SELECT top(1) 
      i.Name as MapName

jeroenmaes

using Newtonsoft.Json;
using System;
using System.Collections.Specialized;
using System.Net;
using System.Text;

//A simple C# class to post messages to a Slack channel
//Note: This class uses the Newtonsoft Json.NET serializer available via NuGet
public class SlackClient
{

jeroenmaes

#r "Microsoft.ServiceBus"

using Microsoft.ServiceBus.Messaging;
using Microsoft.ServiceBus;

using System;
using System.Threading.Tasks;

public static void Run(BrokeredMessage myQueueItem, TraceWriter log, out BrokeredMessage outputSbMsg)
{    

jeroenmaes

#https://www.saotn.org/iis-application-pool-recycle-on-specific-times-not-regular-time-interval/

Import-Module WebAdministration

$appPools = Get-ChildItem IIS:\apppools | where {$_.Name -match "APP1|APP2"}
$timeDiff = 0

$appPools | ForEach-Object {
   
    $pool = $("IIS:\AppPools\") + ($_.Name)