Skip to main content

Posts

Showing posts from November, 2012

Personalize button is missing in Sitecore > Presentation > Details tab in Sitecore

Personalization and Analytics in Sitecore are interrelated. If we disable the analytics, all the personalization related stuff also gets hidden from the content tree.
If we disable analytics, we will not get the personalize button in the pop up.


If we enable analytics, we will get the option of adding rules using personalize button.  

Enable the Analytics in Sitecore.Analytics.config in Includes/App_Config folder.
      <setting name="Analytics.Enabled" value="true" />

Find the list of Sitecore Admin Users (through database)

If you want to list down the users who have Sitecore admin access, you have to go through each user (to check IsAdministrator checkbox is checked or not) in User Manager in Security tools. We can also find the list by querying Sitecore ASP.Net membership tables. Mostly these table will be located in Sitecore Core database.

Query:

/**  Getting the list of Users who have Sitecore admin access **/ SELECT [ApplicationId] ,[UserId] ,[UserName] ,[LoweredUserName] ,[MobileAlias] ,[IsAnonymous] ,[LastActivityDate] FROM [NewInstance1Sitecore_Core].[dbo].[aspnet_Users] WHERE UserId IN /** Getting the list of user-ids **/ (SELECT [UserId] FROM [NewInstance1Sitecore_Core].[dbo].[aspnet_Profile] WHERE /** IsAdministrator Property Name Check **/   [PropertyNames] LIKE'%IsAdministrator%' AND /** Property Value : True or False Check **/ /** !Important: This check should be avoided when you have other boolean type             custom profile property. And in that case, just get the User name without this check and…