Skip to content

Instantly share code, notes, and snippets.

View tomekjuranek's full-sized avatar

tomekjuranek

  • Alan Systems
View GitHub Profile
@tomekjuranek
tomekjuranek / gist:4117438
Created November 20, 2012 11:38
select page url
select [Url]
from [ItemUrls]
where [ItemId] = @Id
@tomekjuranek
tomekjuranek / gist:4117419
Created November 20, 2012 11:35
select item events
select
[Name],
[Text],
[PageId],
[IsGoal],
[IsFailure],
[RDNS],
[BusinessName],
[UserAgent],
[DateTime],
@tomekjuranek
tomekjuranek / gist:4111228
Created November 19, 2012 15:19
Sitecore deploy application from package
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:package="HomePage.zip" -dest:contentPath="C:\inetpub\wwwroot\HomePage\Website",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=filepath,absolutePath=\\App_Offline.htm$ -skip:objectName=dirpath,absolutePath=\\temp$
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:package="SitecoreData.zip" -dest:contentPath="C:\inetpub\wwwroot\HomePage\Data",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=filepath,absolutePath=.*logs\\.*\.txt$ -skip:objectName=dirpath,absolutePath=indexes\\.*$
@tomekjuranek
tomekjuranek / gist:4111189
Created November 19, 2012 15:11
Create sitecore deployment package
mkdir "%WORKSPACE%\Package
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:contentPath="%WORKSPACE%\Website" -dest:package="%WORKSPACE%\Package\HomePage.zip",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=dirpath,absolutePath=\\obj$ -skip:objectName=filepath,absolutePath=\\App_Offline.htm$ -skip:objectName=dirpath,absolutePath=\\temp$ -skip:objectname=filepath,absolutePath=web\..*\.config -skip:objectname=filepath,absolutePath=ConnectionStrings\..*\.config
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:contentPath="%WORKSPACE%\Data" -dest:package="%WORKSPACE%\Package\SitecoreData.zip",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=filepath,absolutePath=.*logs\\.*\.txt$ -skip:obj
@tomekjuranek
tomekjuranek / gist:4110901
Created November 19, 2012 14:24
Take app online
if exist C:\inetpub\wwwroot\HomePage\Website\App_Offline.htm del /Q C:\inetpub\wwwroot\HomePage\Website\App_Offline.htm
@tomekjuranek
tomekjuranek / gist:4110895
Created November 19, 2012 14:23
Take app offline
if exist C:\inetpub\wwwroot\HomePage\Website\App_offline.test ren C:\inetpub\wwwroot\HomePage\Website\App_offline.test App_Offline.htm
@tomekjuranek
tomekjuranek / gist:4110476
Created November 19, 2012 12:52
Sitecore set Read Write Modify ACL
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Data",setAclUser=IIS_IUSRS,setAclAccess="Read,Write,Modify"
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Website",setAclUser=IIS_IUSRS,setAclAccess="Read,Write,Modify"
@tomekjuranek
tomekjuranek / gist:4110472
Created November 19, 2012 12:50
Sitecore deploy application to iis
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:iisApp="%WORKSPACE%\Website" -dest:iisApp="Home Page",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=dirpath,absolutePath=\\obj$ -skip:objectName=filepath,absolutePath=\\App_Offline.htm$ -skip:objectName=dirpath,absolutePath=\\temp$ -skip:objectname=filepath,absolutePath=web\..*\.config -skip:objectname=filepath,absolutePath=ConnectionStrings\..*\.config
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:contentPath="%WORKSPACE%\Data" -dest:contentPath="C:\inetpub\wwwroot\HomePage\Data",includeAcls='False' -disableLink:AppPoolExtension -disableLink:ContentExtension -disableLink:CertificateExtension -skip:objectName=dirpath,absolutePath=.*\.svn -skip:objectName=filepath,absolutePath=.*logs\\.*\.txt$ -skip:objectName=dirpath,absolutePath=indexes\\.*$
@tomekjuranek
tomekjuranek / gist:4110450
Created November 19, 2012 12:45
Sitecore set read only rights
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Data",setAclUser=IIS_IUSRS,setAclAccess="Read"
"C:\Program Files (x86)\IIS\Microsoft Web Deploy V2\msdeploy.exe" -verb:sync -source:setacl -dest:setacl="C:\inetpub\wwwroot\HomePage\Website",setAclUser=IIS_IUSRS,setAclAccess="Read"
@tomekjuranek
tomekjuranek / gist:4110080
Created November 19, 2012 10:51
Sitecore connection strings transformations
<?xml version="1.0" encoding="utf-8"?>
<connectionStrings xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
<add name="core" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Core;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)" />
<add name="master" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Master;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
<add name="web" connectionString="Data Source=host\SQLDBNAME;Database=websiteSitecore_Web;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
<add name="analytics" connectionString="Data Source=host\SQLDBNAME;Database=Sitecore_analytics;Integrated Security=SSPI" xdt:Transform="Replace" xdt:Locator="Match(name)"/>
</connectionStrings>