ProNotion

internal static string GetModelPropertyTypeAlias<TModel>(Expression<Func<TModel, object>> selector)
        where TModel : PublishedElementModel
    {
        Expression body = selector.Body;

        // Unwrap conversions, if any
        if (body is UnaryExpression unaryExpression && unaryExpression.NodeType == ExpressionType.Convert)
            body = unaryExpression.Operand;

        if (!(body is MemberExpression memberExpression))

ProNotion

SELECT        m.LoginName, m.Email, cmsPropertyData.dataDate AS LastLoginDate
FROM            cmsPropertyType INNER JOIN
                         cmsPropertyData ON 
                         cmsPropertyType.id = cmsPropertyData.propertytypeid RIGHT OUTER JOIN
                         cmsMember AS m ON cmsPropertyData.contentNodeId = m.nodeId
WHERE        (cmsPropertyType.Alias = N'umbracoMemberLastLogin') AND (cmsPropertyData.dataDate IS NOT NULL)
ORDER BY LastLoginDate DESC

ProNotion

######## Phil's dev VM boxstarter script ########

###############
#### NOTES ####
###############

## After a restart/reconnect, even though it shows the login screen, boxstarter is still working

### NOTES when kicking off remotely from host to VM, fails on Configuring CredSSP settings
## check http://blogs.technet.com/b/heyscriptingguy/archive/2012/12/30/understanding-powershell-remote-management.aspx

ProNotion

INSERT INTO [icUrlTracker] (OldUrl, RedirectNodeId, Notes)
    SELECT
        RIGHT(url, LEN(url) - 1),
        (SELECT TOP (1)
            id
        FROM umbracoNode
        WHERE (uniqueID = umbracoRedirectUrl.contentKey))
        AS NodeId,
        'Import from umbracoRedirectUrl table' AS Note
    FROM umbracoRedirectUrl

ProNotion

ALTER TABLE icUrlTracker ADD ForceRedirect BIT DEFAULT 0 NOT NULL

ProNotion

import-module WebAdministration

Write-Host "`n Listing sites with SSL bindings"
Write-Host "**********************************`n"
ls IIS:\SslBindings | Foreach {
  Write-Host " - $($_.Host)"
}
Write-Host "`n**********************************"

ProNotion

robocopy /PURGE <empty_dir> <directory_to_remove>

ProNotion

robocopy /PURGE <empty_dir> <directory_to_remove>

ProNotion

robocopy /PURGE <empty_dir> <directory_to_remove>

ProNotion

PRINT 'Checking for existence of table ''countries'''

/****** Object:  Table [dbo].[Countries]    Script Date: 11/09/2006 16:58:01 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Countries]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Countries]

PRINT 'Existing table ''countries'' dropped!'
GO

/****** Object:  Table [dbo].[Countries]    Script Date: 11/09/2006 16:58:01 ******/