The website Log Access Logging Component UserVisitLogsHelp is open-source!

Source: Internet
Author: User

No.

Field name

Field Type

Remarks

1

Id

Integer

Auto-increment sequence number (PK, Not Null)

2

UserHostAddress

Varchar (20)

IP host address of the remote client

3

UserHostName

Varchar (20)

DNS name of the remote client

4

UrlAbsoluteUri

Varchar (1600)

Absolute URI of the current request

5

PhysicalPath

Varchar (500)

Physical file path corresponding to the current request URL

6

UserAgent

Varchar (1000)

Original user proxy information of the client browser

7

HttpMethod

Varchar (4)

HTTP data transmission method used by the client

8

Userages

Varchar (20)

Collation of client language preferences

9

UrlHost

Varchar (100)

Instance name of the client host

10

UrlPort

Varchar (10)

Port Number of the current URI

11

TotalBytes

Integer

Number of bytes in the current input stream

12

ContentLength

Integer

Length of the content sent by the client (in bytes)

13

IsLocal

Varchar (5)

Whether the current request comes from a local computer

14

BrowserType

Varchar (30)

Browser name and main (integer) version number

15

BrowserVersion

Varchar (20)

Complete browser version number (including integer and decimal number)

16

BrowserPlatform

Varchar (20)

Name of the operating system platform used by the client

17

BrowserBeta

Varchar (5)

Is the browser a beta version?

18

BrowserActiveXControls

Varchar (5)

Does the browser support ActiveX controls?

19

BrowserCookies

Varchar (5)

Does the browser support cookies?

20

BrowserCrawler

Varchar (5)

Does the browser search engines for Web crawling?

21

BrowserJavaScript

Varchar (5)

Main EcmaScript version supported by the browser

22

BrowserSupportsXmlHttp

Varchar (5)

Does the browser support XML receiving through HTTP?

23

BrowserInputType

Varchar (30)

Input types supported by browsers

24

BrowserScreenPixelsWidth

Integer

Approximate Browser display width (in pixels)

25

BrowserScreenPixelsHeight

Integer

Approximate height displayed by the browser (in pixels)

26

UrlReferrerAbsoluteUri

Varchar (1600)

Absolute URI of the last client request (the current URL of the request link)

27

UrlReferrerAbsoluteUriDecode

Varchar (1600)

Decoding the UrlReferrerAbsoluteUri field by zh-cn or utf-9

28

UrlReferrerHostName

Varchar (100)

DNS name of the last client request (the current URL of the request)

29

CanCombineFormsInDeck

Varchar (5)

Does the browser Support card groups that contain multiple windows?

30

IsMobileDevice

Varchar (5)

Whether the browser is a recognized mobile device

31

MobileDeviceManufacturer

Varchar (30)

Name of the mobile device manufacturer

32

MobileDeviceModel

Varchar (30)

Known mobile device model name

33

NumberOfSoftkeys

Integer

Number of soft keys on mobile devices

34

ContentEncoding

Varchar (10)

Content character encoding

35

ScreenBitDepth

Integer

Approximate depth displayed by the browser (in pixels)

36

Website

Varchar (100)

Access a Web site

37

WebCookies

Varchar (80)

Record the unique cookie value of the Current Visitor

38

VisitTime

Varchar (20)

Current request access time

Three typical application scenarios:

1.asp.net (SharePoint) WebsiteAdd the following to the
2. SharePoint websiteIndependently deployed website Log Access sites can be tracked through JS Code. For internal enterprise websites, you can obtain user information for logging on to AD: 
SP.SOD.exe cuteOrDelayUntilScriptLoaded (runMyCode, "SP. js ");
 
Var currentUser = null;
Var currentUserTitle = null;

Function runMyCode (){
Var ctx = new SP. ClientContext. get_current ();
Var web = ctx. get_web ();
Ctx. load (web );
Var user = web. get_currentUser ();
User. retrieve ();
Ctx.exe cuteQueryAsync (
Function (){
// Only in the success case you can work with user login

CurrentUser = user. get_loginName ();
CurrentUserTitle = user. get_title ();


Document. getElementById ("randimg"). src = "http: // webloggersite/Default. aspx? UserName = "+ currentUser +" & UserTitle = "+ currentUserTitle;









3. Other websites (PHP, JSP, ASP, etc)JS tracking code on the website page:<Script type = "text/javascript">
Function addImg (isrc ){
Var Img = new Image ();
Img. style = "width: 0; height: 0 ;";
Img. onload = function (){
Document. body. appendChild (Img );
}
Img. src = isrc;
}
AddImg ("http: // webloggersite/Default. aspx ");
</Script>
Automatically generate the configuration file of the log database Sqlite (log database can be generated by year, by month, by day or not ):NetOpen_SystemWebsiteVisit.cfg.xml<NetOpen_System>
<WebsiteVisit>
<! -- DateSource Automatic Generation of Database File year: one year month: every month day: every day None: Does not generate -->
<SQLiteConnectings DataSource = "~ /Visit_Data/HomeWeb "Password =" 12345678 "DateSource =" day "Website =" "ExcludeUrl =" "DecodeUrl =" "TextDecoding =" UTF-8 "ExcludeUserAgent =" "WebCookiesName = "" webCookiesExpires = "3650"/>
</WebsiteVisit>
</NetOpen_System>

SharePoint Business Intelligence Technology QQ group: 140668362,. Net technology exchange QQ group: 195516928, welcome to join the exchange.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.