Blog - So when did you last update DNN?

So when did you last update DNN?

Jun 3

Written by: host
Wednesday, June 03, 2009 8:57 PM

While I have been playing with DNN V5 beta and RCs, I was interested in a forum post a few weeks ago that was asking how to determine the version of DNN. For long time users of DotNetNuke, this is a simple question answered on the Host page.

However, there are other ways to determine the version - primaryly the version table in the DotNetNuke database. But when did you perform your updates? This is what I began wondering. So I created a SQL SELECT that will return the dates of the update.

select
    Cast(major as varchar(2))
    + '.' + cast(minor as varchar(2))
    + '.' + Cast(build as varchar(2))
    as [Version Number],
    Convert(varchar(17), Createddate, 113)
    as [Implementation Date]
from
    {databaseOwner}{objectQualifier}version
where
    versionid in
   (
     select max(versionid)
     from {databaseOwner}{objectQualifier}version
     group by Convert(varchar(17), Createddate, 113)
   )
order by
    versionid desc

Note: I used the fact that I can convert only a part of date string - I used only the first 17 characters of the 113 format. This returns dd mon yyyy HH:mm so I will display all updates done at the same minute.

Version Number Implementation Date
-------------- -------------------
4.9.0          21 Sep 2008 13:37
4.8.3          08 Jun 2008 11:22
4.6.2          08 Jun 2008 11:20
4.5.5          13 Sep 2007 11:10
4.5.3          01 Jun 2007 09:01
4.5.1          17 Apr 2007 09:09
4.5.0          16 Apr 2007 11:42

As you can see from above I performed two updates in the same day. Also notice that several version are updated reach update event.

Hope this helps -- especially if you need to prove when certain update were performed.
Paul.

Trackback Print

Location: Blogs

DNN Musings

Tags:

4 comment(s) so far...

ugg boots usa

I agree with you! very valuable post. and here i have a ugg boots usa shop which i recommend to all of you,we carry ugg handbags such as ugg grab bags and classic stylish like ugg bailey button black, ugg bailey button sand, and ugg bailey button grey, ugg bailey button eggplant,and ugg bailey button chocolate,are the most popular items, also such as the tall boot like ugg bailey button triplet sand, ugg bailey button triplet grey, and ugg bailey button triplet chestnut,i prefer this two ugg bailey button triplet chocolate,and ugg bailey button triplet black,we still carry cardy boots like ugg classic cardy grey, ugg classic cardy cream and ugg classic cardy black.they are good for spring and fall.there are still mini boots like ugg classic mini sand, ugg classic mini grey,and ugg classic mini chocolate,for stylish wear.i think ugg classic mini chestnut, and ugg classic mini black,is your first choice.we still have the most classic boots ugg classic short sand, ugg classic short fancy chestnut,and ugg classic short fancy grey are the most classic short boots,also available in ugg classic short grey and ugg classic short fuschia for ultra comfortable,you could choose ugg classic short eggplant, ugg classic short chocolate and ugg classic short chestnut are the excellent choices,ugg classic short aqua,and ugg classic short black are the most popular item.if you are going outside,ugg ultra short sand, ugg ultra short chocolate comes in a short style.ugg ultra short chestnut and ugg ultra short black will be your first choice,we still carry tall boot style like ugg ultra tall chocolate,ugg ultra tall chestnut,and ugg ultra tall black,they feature with rubber outsole,ideal for outdoor sport,my favorite is ugg ultra tall sand,there are another cold weather boots like ugg sundance ii black, ugg sundance ii chocolate and ugg sundance ii chestnut. they are all brand new style, also carry ugg nightfall sand, ugg nightfall chocolate.welcome to www.thepopshoes.com. free shipping and fast delivery.order yours today.!!!!

By muichan on Wednesday, May 02, 2012 10:15 PM

ugg boots usa

What a wonderful and valuable post, and we highly recommend a ugg boots usa store for the coming winter, this season ugg bailey button grey, ugg bailey button sand and ugg bailey button black is your first choice , also as ugg bailey button chestnut, ugg bailey button chocolate. for those cold weather days, ugg ultra short black, ugg ultra short chestnut and ugg ultra short chocolate is the excellent choice,same as ugg ultra short sand,the tall style ugg ultra tall black and ugg ultra tall chestnut is my favorite color,also available in ugg ultra tall chocolate, ugg ultra tall sand,feature with rubber lugged outsole for extra traction and slip resistance,there are another popular style like ugg sundance ii black, ugg sundance ii chestnut, ugg sundance ii chocolate and ugg sundance ii sand.we still carry ugg bailey button triplet black, ugg bailey button triplet chestnut, ugg bailey button triplet chocolate and the popular items such as ugg bailey button triplet grey, ugg bailey button triplet sand and also we still carry the ugg classic cardy like ugg classic cardy black, ugg classic cardy cream(appropriate for me)and ugg classic cardy grey.of course,we also have ugg classic mini black, ugg classic mini chestnut and ugg classic mini chocolate,i thinks you will also like ugg classic mini grey and ugg classic mini sand. we know ugg classic tall black and ugg classic tall chestnut are the classic tall boot style,i prefer ugg classic tall chocolate, ugg classic tall grey and ugg classic tall sand, at the end,the most classic boots are ugg classic short black, ugg classic short chestnut and ugg classic short chocolate,and the best-seller item is ugg classic short grey and ugg classic short sand. all the boots made with twin faced sheepskin offer ultra warm. for more details please feel free to visit our site www.zpshoes.com. these items sell out fast,get your today and make your order today!!!!

By sevon020 on Thursday, May 03, 2012 10:27 PM

ugg boots usa

Thanks for sharing, it's a very good article! keep on doing it. here is a ugg boots usa store i highly recommend to you. they carry ugg bailey button black, ugg bailey button chestnut and ugg bailey button chocolate, ugg bailey button eggplant. even ugg bailey button grey, of course including ugg bailey button sand and ugg bailey button bomber, and the bailey button boots in tall such as ugg bailey button triplet black, ugg bailey button triplet chestnut, and my favorite ugg bailey button triplet chocolate andugg bailey button triplet grey, i love ugg bailey button triplet sand so much. and the classic short version such as ugg classic short aqua, ugg classic mini black, ugg classic short chestnut and ugg classic short chocolate, ugg classic short eggplant are my favorite.ugg classic short fancy chestnut, ugg classic short fancy grey, as well as the ugg classic short grey and ugg classic short sand, are my second faovrite. and the classic tall boots like ugg classic tall black, ugg classic tall chestnut, and ugg classic tall chocolate. ugg classic tall grey and ugg classic tall sand are my best love, we still carry the knit boots like ugg classic cardy black, ugg classic cardy cream and ugg classic cardy grey, the ugg classic mini black, ugg classic mini chestnut and ugg classic mini chocolate are you must-have this winter, ugg classic mini grey and ugg classic mini sand are your first choice.and boots for men like ugg men classic short black, ugg men classic short chestnut and ugg men classic short chocolate. ugg men classic short grey and ugg men classic short sand are perfect for men. the ugg boots for kids like ugg kids classic short black, ugg kids classic short chestnut and ugg kids classic short chocolate. ugg kids classic short grey and ugg kids classic short sand are perfect for boys, the kids bailey button boots like ugg kids bailey button black, ugg kids bailey button chestnut and ugg kids bailey button chocolate.ugg kids bailey button sand is good for girls. ugg ultra short black, ugg ultra short chestnut and ugg ultra short chocolate are designed for those bad weather days. ugg ultra short sand, ugg ultra tall black andugg ultra tall chestnut come in tall that offer ultra warm.ugg ultra tall chocolate and ugg ultra tall sand have a popular color.for more fashionable, you can chooseugg sundance ii black,ugg sundance ii chestnut and ugg sundance ii chocolate. my favorite is ugg sundance ii sand. welcome to our site www.shoesvol.com,there's sure at least one pair of boot you will like. have a great day!!!!

By sevon020 on Thursday, May 03, 2012 10:28 PM

Coach Factory Outlet

Some bags sold at Coach Factory Outlet will have small defects. These defects are made during the process of Coach Outlet Online. But these defects are very small. No body will notice Coach Outlet. In case you buy some bags which you will not like in the future, it is better for you to check the quality before you make the payment.Of course, if you think fake Coach Factory are much cheaper and you can accept them. You can buy some of them on Internet. There are plenty of these Coach Factory Outlet there
Ladies are creatures of Coach Factory Store. They are born to love designer bags. Sometimes they can not Coach Outlet. They can not stop buying their Coach Factory there are very little money in their wallets. They know they should not do that. But a Coach Outlet Store Online will definately show her personality and Coach Outlet Online. Just like people will love Coach Outlet Store, women can not say no to Coach Outlet Online.

By michaelkors on Tuesday, May 15, 2012 4:28 AM