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. |