mskutta

configure

# Configure Firewall
set firewall ipv6-name IPV6WAN_IN description 'IPV6WAN to internal'
set firewall ipv6-name IPV6WAN_IN default-action drop

set firewall ipv6-name IPV6WAN_IN rule 10 action accept
set firewall ipv6-name IPV6WAN_IN rule 10 state established enable
set firewall ipv6-name IPV6WAN_IN rule 10 state related enable
set firewall ipv6-name IPV6WAN_IN rule 10 log disable

mskutta

<%@ WebService Language="C#" Class="PackageInstaller" %>
using System;
using System.Configuration;
using System.IO;
using System.Web.Services;
using System.Xml;
using Sitecore.Data.Proxies;
using Sitecore.Data.Engines;
using Sitecore.Install.Files;
using Sitecore.Install.Framework;

mskutta

using System;
using System.Linq;
using Sitecore.Analytics.Aggregation.Pipeline;
using Sitecore.Diagnostics;

namespace Website.Logic.Analytics.Views
{
    public class ViewAggregationProcessor : AggregationProcessor
    {
        protected override void OnProcess(AggregationPipelineArgs args)

mskutta

# https://community.ubnt.com/t5/EdgeMAX/traffic-remarking/td-p/1210870

configure

set firewall modify WAN_IN_MODIFY rule 10 action modify
set firewall modify WAN_IN_MODIFY rule 10 modify dscp 0

set interfaces ethernet eth0 firewall in modify WAN_IN_MODIFY

commit

mskutta

# ISP: Comcast 
# Router: Ubiquiti EdgeMax Router Lite
# EdgeOS System Image: v1.7.0
# WAN Interface: eth1
# LAN Interface: eth0 (mgmt)
# VLAN Interface: eth0.2 (video)
# VLAN Interface: eth0.3 (voip)
# VLAN Interface: eth0.4 (local)
# VLAN Interface: eth0.5 (guest)

mskutta

UPDATE [aspnet_Membership] SET Password='qOvF8m8F2IcWMvfOBjJYHmfLABc='   
WHERE UserId IN (SELECT UserId FROM [aspnet_Users] WHERE UserName = 'sitecore\Admin')

mskutta

using System;
using Sitecore.Analytics;
using Sitecore.Diagnostics;
using Sitecore.Pipelines;
using Website.Logic.Common.Extensions;
using Sitecore.Data;
using Newtonsoft.Json;

namespace Website.Logic.Analytics.Views
{

mskutta

string culture = "int";
string name = "Integration";
 
//Create Culture & Region Info with an existing Language Culture (Eg: en-GB)
CultureInfo cultureInfo = new CultureInfo("en-US");
RegionInfo regionInfo = new RegionInfo(cultureInfo.Name);
CultureAndRegionInfoBuilder cultureAndRegionInfoBuilder = new CultureAndRegionInfoBuilder(culture, CultureAndRegionModifiers.None);
cultureAndRegionInfoBuilder.LoadDataFromCultureInfo(cultureInfo);
cultureAndRegionInfoBuilder.LoadDataFromRegionInfo(regionInfo);
cultureAndRegionInfoBuilder.CultureEnglishName = cultureAndRegionInfoBuilder.CultureNativeName = name;

mskutta

        public static List<Item> GetMostViewed(int count, int daysToInclude, List<Guid> templateIDs, List<Guid> mostViewedExcludeGuids)
        {
            var sqlServerDataApi = new SqlServerDataApi(Sitecore.Configuration.Settings.GetConnectionString("reporting"));

            // Base Query
            var query = @"SELECT TOP " + count.ToString() + @"
		                        A.ItemId,
		                        A.DailyCount,
		                        A.LastViewDate
                        FROM

mskutta

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
    <pipelines>
      <group groupName="analytics.aggregation">
        <pipelines>
          <interactions>
            <processor type="Website.Logic.Analytics.Views.ViewAggregationProcessor, Website" />
          </interactions>
        </pipelines>
      </group>