Re: DayLastAccessed - site

Well that would be my assumption, in that any site with useage analysis
enabled would provide a counter field greater than zero, alluding to the
number of dayes elapsed since 1899 to the last access. As it's a smallint
and relates to number of days it should be a simple addition of root date +
days elapsed. Not sure how you have a minus though as your other post
points out! I wonder if the usage analysis timer job has run yet as its
likely to be what updates that value?

Of course my interpretation of the docuemtnation could very easily be wrong!

Regards

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


"NAT" <NAT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58AFEAD5-801D-4D5F-9FDA-49C7F0D8A528@xxxxxxxxxxxxxxxx
Hi John,
I appreciate your help. The documentation also says that "Sites that have
never been used or that have never had their usage data processed for some
reason will have this field set to 0". So, will using add method on
DayLastAccessed give me what I am looking for ? I am trying to get the
list
of all webs/sites, that have been viewed/accessd in the past 6 months.
Thanks.

"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
    ... "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
    ... 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)
Loading