everlight.eap/backend/WebBIStaus/NLog.config

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd"
      autoReload="true"
      throwExceptions="false"
      internalLogLevel="Warn"
      internalLogFile="Logs/nlog-internal.log">

  <!--internalLogLevel="Off"-->
  <!-- optional, add some variables
  https://github.com/nlog/NLog/wiki/Configuration-file#variables
  -->
  <variable name="myvar" value="myvalue"/>

  <!--
  See https://github.com/nlog/nlog/wiki/Configuration-file
  for information on customizing logging rules and outputs.
   -->
  <targets>

    <!--
    add your targets here
    See https://github.com/nlog/NLog/wiki/Targets for possible targets.
    See https://github.com/nlog/NLog/wiki/Layout-Renderers for the possible layout renderers.
    -->

    <!--
    Write events to a file with the date in the filename.
    <target xsi:type="File" name="f" fileName="${basedir}/logs/${shortdate}.log"
            layout="${longdate} ${uppercase:${level}} ${message}" />
    -->

    <!-- write logs to file -->
    <target xsi:type="File" name="allfile" fileName="logs/${date:format=yyyy-MM-dd}/log.txt"
             layout="------------------------------------------${newline}${longdate} | ${uppercase:${level}} | ${logger} ${newline}${message} ${exception} ${newline} | url: ${aspnet-request-url} | action: ${aspnet-mvc-action}" />

    <target xsi:type="Null" name="blackhole" />

    <target xsi:type="Database" name="database" dbProvider="MySql.Data.MySqlClient.MySqlConnection,Mysql.Data">
      <connectionString>${var:connectionString}</connectionString>
      <commandText>
        INSERT INTO log(Platform,Category,LogLevel,Module,Action,Message,RecCode,RecTime)
        VALUES (@applicationId,@category,@levels, @logger, @action, @message,@reccode,@operatingTime);
      </commandText>
      <parameter name="@application" layout="EapWeb" />
      <parameter name="@applicationId" layout="1" />
      <parameter name="@levels" layout="${level}" />
      <parameter name="@operatingTime" layout="${date}" />
      <parameter name="@operatingaddress" layout="${aspnet-Request-IP}" />
      <parameter name="@logger" layout="${logger}" />
      <parameter name="@callSite" layout="${callsite}" />
      <parameter name="@requesturl" layout="${aspnet-request-url}" />
      <parameter name="@referrerurl" layout="${aspnet-request}" />
      <parameter name="@action" layout="${aspnet-mvc-controller}/${aspnet-mvc-action}" />
      <parameter name="@controller" layout="${aspnet-mvc-controller}" />
      <parameter name="@message" layout="${message}" />
      <parameter name="@exception" layout="${exception:tostring}" />
      <parameter name="@category" layout="${event-properties:item=category}" />
      <parameter name="@reccode" layout="${event-properties:item=reccode}" />
    </target>
  </targets>
  <rules>
    <!-- add your logging rules here -->

    <!--
    Write all events with minimal level of Debug (So Debug, Info, Warn, Error and Fatal, but not Trace)  to "f"
    <logger name="*" minlevel="Debug" writeTo="f" />
    -->

    <!--All logs, including from Microsoft-->
    <!--minlevel 改为Trace 跟踪全部 Error 只捕获异常-->
    <logger name="*" minlevel="Error" maxlevel="Fatal" writeTo="allfile" />

    <!--Skip Microsoft logs and so log only own logs-->
    <logger name="Microsoft.*" minlevel="Trace" writeTo="blackhole" final="true" />
    <!--<logger name="*" minlevel="Trace" writeTo="ownFile-web" />-->
    <!--<logger name="*" minlevel="Fatal"  writeTo="database" />-->

  </rules>
</nlog>