Re: DayLastAccessed - site

John,
I beleive there has to be a catch here...since I have a site whose
DayLastAccessed value is '-25738'. When I use DATEADD(d, 25738, '01/01/1899')
, I don't get today's date. Since I accessed the site today, the dateadd must
return today's date.Please advice.

"John Timney (MVP)" wrote:

According to the documentation that specific field is a smallint (integer)
value that specifies the last day the site was accessed as the number of
days since January 1, 1899. So, its a counter field and can be converted to
a c# system.int16. If you need a date, you'll need to use the adddays
method to add that counter to jan 1,1899.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog


"NAT" <NAT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9047559-870D-427B-A5AC-A4FBBF73D8B5@xxxxxxxxxxxxxxxx
Hi,
I am trying to get the list of all webs/sites, that have been
viewed/accessd
in the past 6 months. How can I acheive that using ad hoc SQL queries. I
know
using SQL query may not be recommendable by MS. But how can I generate
such
report. I see that there is a column named 'DayLastAccessed' in Webs table
in
SP. But I don't know how to read/interpret that column value format.
Please
advice.



.

Relevant Pages

  • Re: DayLastAccessed - site
    ... "John Timney (MVP)" wrote: ... its a counter field and can be converted to ... How can I acheive that using ad hoc SQL queries. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: DayLastAccessed - site
    ... Well that would be my assumption, in that any site with useage analysis ... "John Timney (MVP)" wrote: ... its a counter field and can be converted ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: DayLastAccessed - site
    ... usage analysis timer job has run because if I go to the ... "John Timney (MVP)" wrote: ... its a counter field and can be converted ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: DayLastAccessed - site
    ... The daylastaccessed field is a negative number ... "John Timney (MVP)" wrote: ... its a counter field and can be converted to ... How can I acheive that using ad hoc SQL queries. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Dowload File
    ... John Timney (MVP) wrote: ... download the file allowing your job to complete before you actually ... HttpWebRequest webRequest3 = WebRequest.Createas ...
    (microsoft.public.dotnet.general)
Loading