xrisdoc

using My.OrderPortal.Models;
using Merchello.Core.Gateways.Payment;
using Merchello.Core.Gateways.Shipping;
using Merchello.Core.Models;
using Merchello.Web;
using Merchello.Web.Mvc;
using Constants = Merchello.Providers.Constants;
using System;
using System.Collections.Generic;
using System.Linq;

xrisdoc

SELECT CONVERT(int, objectGUID) AS UserID, LOWER(LEFT(userPrincipalName, LEN(userPrincipalName) - LEN('@my-domain.co.uk'))) AS Username, givenName AS FirstName, sn AS Surname, LOWER(mail) AS Email, 
	   CONVERT(nvarchar(20), telephoneNumber) AS DirectDial, CONVERT(nvarchar(20), pager) AS ExtensionNumber, CONVERT(nvarchar(20), mobile) AS MobileNumber, Department, title AS JobTitle, 
	   REPLACE(LOWER(givenName) + '-' + LOWER(sn) + '.jpg', ' ', '-') AS ProfileImageCSS,
	   LOWER(userPrincipalName) AS UsernameFull, userAccountControl AS AccountStatus, distinguishedName AS ADTreeRoute
FROM OPENQUERY(ADSI, 
     'SELECT objectSID, objectGUID, userPrincipalName, sAMAccountName, givenName, sn, mail, telephoneNumber, pager, mobile, physicalDeliveryOfficeName, Department, title, userAccountControl, distinguishedName
	   FROM ''LDAP://my-server/DC=my-domain,DC=co,DC=uk''
	   WHERE objectCategory = ''person'' AND objectClass = ''user''
	   ORDER BY SN ASC') AS ad
WHERE RIGHT(distinguishedName, LEN('OU=SBSUsers,OU=Users,

xrisdoc

SELECT (SELECT SUBSTRING(
		(SELECT ('; ' + Username  + '') FROM 
			(SELECT AD.sAMAccountName as Username
			FROM OPENQUERY(ADSI, 'SELECT sAMAccountName, displayName, userPrincipalName, userAccountControl, company
				FROM ''LDAP://myserver/OU=SBSUsers,OU=Users,OU=MyBusiness,DC=my-domain,DC=co,DC=uk''
				WHERE objectClass = ''Person'''
			) AD
			WHERE AD.userPrincipalName Is NOT Null 
			AND AD.sAMAccountName Is Not Null
			AND AD.userAccountControl NOT IN (512, 546, 514, 66050)

xrisdoc

<div class="container-fluid">
    <div class="row">
        <div class="col-xs-12">
            <h2>ASP.NET Server Variables</h2>
            <table class="table table-striped table-bordered table-condensed">
                <tr>
                    <th>Key</th>
                    <th>Value</th>
                </tr>
                @foreach (var key in Request.ServerVariables.AllKeys)