using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.EventLog
{
    public static class EventLogQB
    {

        public const string EVENTLOG_REPORT = @"SELECT TOP 1000
                                    TEVENTLOG.EVENTTEXT         AS EventText ,
                                    TEVENTLOG.LINK              AS Link,
                                    TEVENTLOG.SOURCEID          AS SourceId,
                                    TEVENTLOG.USERID            AS UserId,
                                    TEVENTLOG.TAGS              AS Tags,
                                    TEVENTLOG.EVENTVALUE        AS EventValue,
                                    TEVENTLOG.DATA              AS Data,
                                    TEVENTLOG.GEO               AS Geo,
                                    TEVENTLOG.EVENTTYPEID       AS EventTypeId,
                                    TEVENTLOG.EVENTCLASSID      AS EventClassId,
                                    TEVENTLOG.LOGBOOKID         AS LogBookId,
                                    TEVENTLOG.DATAID            AS DataId,
                                    TEVENTLOG.TIMESTAMP         AS Timestamp,
                                    TEVENTLOG.EVENTCHANNELID    AS EventChannelId,
                                    TEVENTLOG.OUID              AS Ouid,
                                    TEVENTLOG.MACHINEIP         AS MachineIp,
                                    TEVENTLOG.MODEOFWORKING     AS ModeOfWorking,
                                    TEVENTLOG.LOGINEVENTLOGID   AS LoginEventLogId,
                                    TEVENTLOG.EVENTLOGID        AS EventLogId
                                FROM TEVENTLOG TEVENTLOG
                                WHERE 1 = 1
                                ";
    }
}