How to Get the Hits from any IP Address??

I was thinking of if we can get the counts of hits from IP Addresses on my site.

Well - got a small query that needs to be run on the Analytics database which would return the hits:-

SELECT TOP (10)[IpAddress],[IpId],COUNT (IpAddress) AS 'Total count'
  FROM [Session]
  GROUP BY [IpAddress],[IpId]
  ORDER BY [Total count] DESC
GO

Sitecore Positioned as a Leader in 2011 Magic Quadrant for Web Content Management

In a new Gartner Magic Quadrant for Web Content Management, released today, Sitecore has been positioned in the Leaders quadrant, based on an evaluation of the company's completeness of vision and ability to execute. View this new report, compliments of Sitecore, to see Gartner’s ratings of Web CMS vendors based on “ability to execute” and “completeness of vision,” using these criteria to place vendors into one of four quadrants: Leaders, Visionaries, Challengers or Niche Players. Read the key strengths and cautions for each Web CMS vendor listed in the Magic Quadrant.

Just released: Gartner 2011 Magic Quadrant for Web Content Management Must-have information for anyone actively considering or researching web content management systems. Access your complimentary Gartner Magic Quadrant Web CMS report now.

Michael Seifert, CEO of Sitecore, states, “the founder of Apple, Inc. once said ‘innovation distinguishes between a leader and a follower.’ This reigns true for Sitecore, and our leadership position in the Magic Quadrant validates it. As the industry continues to evolve with new entrants and technology integration, we are continuing to lead in a market that will exceed the success of the ERP and CRM industries.” Sitecore's leadership position in the Magic Quadrant validates its strategy to intelligently guide customer conversations across all interactions and communications channels. We are pleased to offer this report for providing perspective on Sitecore's leadership position within this quickly evolving industry.

Want to be different?

Lets try to have your taskbar at the top of your Sitecore Desktop instead of the bottom.
Then we need to change a part of the source code in the /sitecore/shell/Applications/Shell.xml file from :

<GridPanel>
<Border ID=”Desktop” GridPanel.Class=”scFill” ContextMenu=”ShowContextMenu”>
<Border ID=”Links” DblClick=”Launch”/>
</Border>
<Startbar GridPanel.Class=”scStartbar”/>
</GridPanel>

to

<GridPanel>
<Startbar GridPanel.Class=”scStartbar”/>
<Border ID=”Desktop” GridPanel.Class=”scFill” ContextMenu=”ShowContextMenu”>
<Border ID=”Links” DblClick=”Launch”/>
</Border>
</GridPanel>

Hope it works and probably now, you can see the difference.... :)

Forgotten your admin password?

Forgotten your admin password?

No worries, if you have access to the core database then you can change the password from there. (This works in 6 and above)

Open the dbo.aspnet_Users table and find the record where the UserName column contains the sitecore\admin value.

Note the value of the UserId column of this record.

Open the dbo.aspnet_Membership table and find the record where the UserId column contains the saved value in the point above.

In this record change the current value of the Password column to the “qOvF8m8F2IcWMvfOBjJYHmfLABc=” value (this is the hash value of the “b” password).

Prevent Sitecore from logging into the log file

If you have something that Sitecore is logging into the log file and you no longer want it to show up you can ask the log4net class to clear it by updating your web.config accordingly by adding a filter like so within the web.config (this will stop the string “INFO: sitecore/admin has logged in” from being logged into the Sitecore log files.


<log4net>

…

<appender name=”LogFileAppender” type=”log4net.Appender.SitecoreLogFileAppender, Sitecore.Logging”>

…

<filter type=”log4net.Filter.StringMatchFilter”>

<stringToMatch value=”INFO: sitecore/admin has logged in” />

<acceptOnMatch value=”false” />

</filter>

…

</appender>

…

</log4net>