27	leutek	::1:55980	attributes	Query	21850	Updating	update AttributeValues
 set
   LastModified                 = '2018-07-19 00:52:40.000000',
    LMByHostName                 = 'H2318784',
    LMByHandlerName              = 'ExecuterHandler',
    LMByZISUserID                = 'SYSTEM',
    LMByUniqueID      ...	0.000
29	leutek	::1:55982	status	Query	22422	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
34	leutek	::1:55988	eventmonitor	Query	23000	Updating	update EUStatus00000100103_Pending
 set
  ModifyTime             = '2018-07-19 00:33:30.000000',
  LMByHostName           = 'H2318784',
  LMByHandlerName        = 'LanMonitorHandler',
  LMByZISUserID          = 'SYSTEM',
  LMByUniqueID           = 15003,
  Modi...	0.000
36	leutek	::1:55990	eventmonitor	Query	22963	Updating	update EUStatus00000102230_Pending
 set
  ModifyTime             = '2018-07-19 00:34:07.000000',
  LMByHostName           = 'H2318784',
  LMByHandlerName        = 'LanMonitorHandler',
  LMByZISUserID          = 'SYSTEM',
  LMByUniqueID           = 15002,
  Modi...	0.000
38	leutek	::1:55992	eventmonitor	Query	22966	updating	delete from EUStatus00000100006_Pending where UniqueEventUnitID = 5085
 or UniqueEventUnitID = 5084	0.000
41	leutek	::1:55995	eventmonitor	Query	22422	Copying to tmp table	select 
  a.UniqueEventUnitID,
  a.ModifyTime,
  a.LMByHostName,
  a.LMByHandlerName,
  a.LMByZISUserID,
  a.LMByUniqueID,
  a.ModifyCounter,
  a.CreateTime,
  a.EventUnitState,
  a.EventUnitState,
  a.UserDefinedEventUnitID,
  a.StateText,
  a.ZISSourceDescData,
  a....	0.000
92	leutek	::1:56078	zissystem	Query	22422	creating table	create temporary table if not exists TempZOGD_ContainedZISOidForDelete(
  ZOGDefRBNr  int  NOT NULL,
  OTypNr      int  NOT NULL,
  RBNr        int  NOT NULL,
  primary key(ZOGDefRBNr, OTypNr, RBNr)
 ) engine=innodb	0.000
93	leutek	::1:56128	zissystem	Query	22413	preparing	select MarkedAsDeleted from CalculationUnitDef where RBNr = 100052	0.000
119	leutek	::1:56165	zissystem	Query	21834	statistics	select distinct a.RBNr, a.OTypNr, a.RelNr, a.Active, a.Name, a.Description, a.ZISObjectType, a.VersNr, a.LastModified, a.LMByHostName, a.LMByHandlerName, a.LMByZISUserID, a.LMByUniqueID, a.MarkedAsDeleted, a.MsgID, a.IsSynchronized, a.ZISUniversalIDCreat...	0.000
275	leutek	::1:62503	status	Query	22989	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
293	leutek	::1:62709	eventmonitor	Query	22122	Sorting result	select 
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
299	leutek	::1:62717	eventmonitor	Query	22422	updating	delete from EUStatus00000102228_Pending where UniqueEventUnitID = 1116	0.000
301	leutek	::1:62720	zissystem	Query	21878	Sending data	select
  UniqueAlarmDeviceNr,
  ZISUserDefRBNr
 from AlarmPathCopyItem where AlarmPathDefRBNr = 100015
 order by RelNr	0.000
304	leutek	::1:62723	zissystem	Query	22121	updating	delete from SessionDef
 where
  RBNr = 249896	0.000
314	leutek	::1:62789	zissystem	Query	21878	statistics	select 
  TimeSettingsOTypNr,
  TimeSettingsModificationType,
  TimeFrameDefRBNr,
  AutoReactionDelayIsActive,
  AutoReactionDelayTimeInMS,
  OnlyUserDefTriggerTakeEffect
 from TimeSettings
 where
  RBNr            = 100014 and
  OTypNr          = 11 and
  SubObjec...	0.000
315	leutek	::1:62790	eventmonitor	Query	21880	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
321	leutek	::1:62796	eventmonitor	Query	21880	Copying to tmp table	select 
  a.UniqueEventUnitID,
  a.ModifyTime,
  a.LMByHostName,
  a.LMByHandlerName,
  a.LMByZISUserID,
  a.LMByUniqueID,
  a.ModifyCounter,
  a.CreateTime,
  a.EventUnitState,
  a.EventUnitState,
  a.UserDefinedEventUnitID,
  a.StateText,
  a.ZISSourceDescData,
  a....	0.000
308	leutek	::1:62783	status	Query	21880	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
325	leutek	::1:62800	eventmonitor	Query	21880	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
329	leutek	::1:62804	zissystem	Query	21873	preparing	select MarkedAsDeleted from ArchiveDataProfileDef where RBNr = 18	0.000
334	leutek	::1:62809	eventmonitor	Query	21880	update	insert into EUStatus00000104106_Pending(
  UniqueEventUnitID,
  CreateTime,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
344	leutek	::1:62821	eventmonitor	Query	21768	updating	delete from EUStatus00000100001_Pending where UniqueEventUnitID = 1119
 or UniqueEventUnitID = 1118
 or UniqueEventUnitID = 1117	0.000
346	leutek	::1:62823	eventmonitor	Query	21768	updating	delete from EUStatus00000102237_Pending	0.000
348	leutek	::1:62825	eventmonitor	Query	21820	update	insert into EUStatus00000100004_Pending(
  UniqueEventUnitID,
  CreateTime,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
352	leutek	::1:62829	eventmonitor	Query	21879	update	insert into EUStatus00000100006_Pending(
  UniqueEventUnitID,
  CreateTime,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
411	leutek	::1:62894	zissystem	Query	21869	preparing	select MarkedAsDeleted from AttributeTypeDef where RBNr = 100007	0.000
414	leutek	::1:62897	zissystem	Query	21834	statistics	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1 Windows.Pages Input per Second' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select dis...	0.000
415	leutek	::1:62898	zissystem	Query	21834	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 PhysicalDisk' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 PhysicalDisk' )...	0.000
416	leutek	::1:62899	zissystem	Query	21834	statistics	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1 Windows.Pages per Second' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinct
 ...	0.000
417	leutek	::1:62900	zissystem	Query	21811	updating	delete from SessionDef
 where
  RBNr = 249893	0.000
419	leutek	::1:62902	zissystem	Query	21834	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 System' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 System' )    ) and
   ...	0.000
420	leutek	::1:62903	zissystem	Query	21834	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 Memory' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 Memory' )    ) and
   ...	0.000
421	leutek	::1:62904	zissystem	Query	21834	Copying to tmp table	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1 Windows.Available MBytes' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinct
 ...	0.000
422	leutek	::1:62905	zissystem	Query	21834	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1' )    ) and
       ( a.ZISObj...	0.000
423	leutek	::1:62906	zissystem	Query	21834	statistics	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1 Windows.Pages Output per Second' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select di...	0.000
424	leutek	::1:62907	zissystem	Query	21834	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1 Windows.Processor Time %' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinct
 ...	0.000
425	leutek	::1:62908	zissystem	Query	21817	statistics	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Webserver_1_ Ping' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinct
  a.RBNr
 from Numeri...	0.000
426	leutek	::1:62909	zissystem	Query	21830	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L2' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
508	leutek	::1:62996	eventmonitor	Query	21821	Sorting result	select 
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
529	leutek	::1:63019	zissystem	Query	21768	statistics	select RelNr, Name, ZOGDefGroupType from ZISObjectGroupDef where RBNr = 1103 and OTypNr = 300	0.000
531	leutek	::1:63021	zissystem	Query	21768	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L1' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
553	leutek	::1:63045	zissystem	Query	21756	Sending data	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100014 and
  OTypNr = 11	0.000
555	leutek	::1:63101	zissystem	Query	21634	statistics	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100014 and
  OTypNr = 11	0.000
556	leutek	::1:63123	eventmonitor	Query	21580	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
557	leutek	::1:63124	eventmonitor	Query	21580	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
558	leutek	::1:63125	eventmonitor	Query	21579	Copying to tmp table	select 
  a.UniqueEventUnitID,
  a.ModifyTime,
  a.LMByHostName,
  a.LMByHandlerName,
  a.LMByZISUserID,
  a.LMByUniqueID,
  a.ModifyCounter,
  a.CreateTime,
  a.EventUnitState,
  a.EventUnitState,
  a.UserDefinedEventUnitID,
  a.StateText,
  a.ZISSourceDescData,
  a....	0.000
560	leutek	::1:63127	status	Query	21578	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
568	leutek	::1:63137	zissystem	Query	21577	statistics	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100015 and
  OTypNr = 11	0.000
573	leutek	::1:63146	attributes	Query	21549	updating	delete from AttributeValue
 where
  RBNr   = 102131 and
  OTypNr = 98	0.000
574	leutek	::1:63149	zissystem	Query	21533	statistics	select distinct a.RBNr, a.OTypNr, a.RelNr, a.Active, a.Name, a.Description, a.ZISObjectType, a.VersNr, a.LastModified, a.LMByHostName, a.LMByHandlerName, a.LMByZISUserID, a.LMByUniqueID, a.MarkedAsDeleted, a.MsgID, a.IsSynchronized, a.ZISUniversalIDCreat...	0.000
575	leutek	::1:63150	zissystem	Query	21533	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 Memory' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 Memory' )    ) and
   ...	0.000
576	leutek	::1:63151	zissystem	Query	21533	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 PhysicalDisk' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 PhysicalDisk' )...	0.000
578	leutek	::1:63153	zissystem	Query	21533	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1' )    ) and
       ( a.ZISObj...	0.000
579	leutek	::1:63154	zissystem	Query	21533	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 System' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 System' )    ) and
   ...	0.000
584	leutek	::1:63159	zissystem	Query	21529	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L2' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
585	leutek	::1:63161	eventmonitor	Query	21521	Sorting result	select 
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
591	leutek	::1:63167	zissystem	Query	21513	statistics	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100014 and
  OTypNr = 11	0.000
592	leutek	::1:63177	zissystem	Query	21468	statistics	select RelNr, Name, ZOGDefGroupType from ZISObjectGroupDef where RBNr = 1103 and OTypNr = 300	0.000
593	leutek	::1:63178	zissystem	Query	21468	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L1' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
594	leutek	::1:63217	eventmonitor	Query	21279	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
595	leutek	::1:63218	eventmonitor	Query	21279	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
596	leutek	::1:63219	eventmonitor	Query	21279	Copying to tmp table	select 
  a.UniqueEventUnitID,
  a.ModifyTime,
  a.LMByHostName,
  a.LMByHandlerName,
  a.LMByZISUserID,
  a.LMByUniqueID,
  a.ModifyCounter,
  a.CreateTime,
  a.EventUnitState,
  a.EventUnitState,
  a.UserDefinedEventUnitID,
  a.StateText,
  a.ZISSourceDescData,
  a....	0.000
597	leutek	::1:63220	status	Query	21277	update	insert into serviceobjectstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (103083, 98, 0, '2018-07-19T...	0.000
598	leutek	::1:63221	zissystem	Query	21277	statistics	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100015 and
  OTypNr = 11	0.000
599	leutek	::1:63227	attributes	Query	21248	updating	delete from AttributeValue
 where
  RBNr   = 102131 and
  OTypNr = 98	0.000
600	leutek	::1:63231	zissystem	Query	21233	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 Memory' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 Memory' )    ) and
   ...	0.000
601	leutek	::1:63232	zissystem	Query	21233	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1' )    ) and
       ( a.ZISObj...	0.000
602	leutek	::1:63233	zissystem	Query	21233	statistics	select distinct a.RBNr, a.OTypNr, a.RelNr, a.Active, a.Name, a.Description, a.ZISObjectType, a.VersNr, a.LastModified, a.LMByHostName, a.LMByHandlerName, a.LMByZISUserID, a.LMByUniqueID, a.MarkedAsDeleted, a.MsgID, a.IsSynchronized, a.ZISUniversalIDCreat...	0.000
603	leutek	::1:63234	zissystem	Query	21233	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 System' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 System' )    ) and
   ...	0.000
604	leutek	::1:63235	zissystem	Query	21233	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 PhysicalDisk' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 PhysicalDisk' )...	0.000
605	leutek	::1:63236	zissystem	Query	21229	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L2' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
606	leutek	::1:63237	eventmonitor	Query	21220	Sorting result	select 
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
  EventUnitState,
  UserDefinedEventUnitID,
  StateText,
  ZISSourceDescData,
  ZISSourceOTypNr,
  ZISSourceR...	0.000
607	leutek	::1:63243	zissystem	Query	21167	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L1' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
608	leutek	::1:63270	eventmonitor	Query	20979	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
609	leutek	::1:63271	eventmonitor	Query	20979	Sorting result	select
  UniqueEventUnitID,
  ModifyTime,
  LMByHostName,
  LMByHandlerName,
  LMByZISUserID,
  LMByUniqueID,
  ModifyCounter,
  CreateTime,
  EventUnitState,
   case 
    When EventUnitState  =  10  then 10
    When AcknowledgeFlag = '1'  then 31
    When RevisionFl...	0.000
610	leutek	::1:63272	zissystem	Query	20976	statistics	select
  PerformanceCounterType,
  PerformanceCounterDefRBNr,
  Active,
  WriteIsOn,
  ValueCapturingIntervalInSec
 from PerformanceCounterFrwrdngItem
 where
  RBNr   = 100015 and
  OTypNr = 11	0.000
611	leutek	::1:63273	status	Query	20971	update	insert into zisobjectgroupstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  ZISObjectGroupGroupType,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (...	0.000
612	leutek	::1:63278	attributes	Query	20948	updating	delete from AttributeValue
 where
  RBNr   = 102131 and
  OTypNr = 98	0.000
613	leutek	::1:63286	zissystem	Query	20932	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 System' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 System' )    ) and
   ...	0.000
614	leutek	::1:63287	zissystem	Query	20932	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 PhysicalDisk' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 PhysicalDisk' )...	0.000
615	leutek	::1:63288	zissystem	Query	20932	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1' )    ) and
       ( a.ZISObj...	0.000
616	leutek	::1:63289	zissystem	Query	20932	Copying to tmp table	select distinct
  a.RBNr
 from ZISObjectGroupDef a left join MsgID2Message b
 on a.MsgID = b.MsgID
 where ( ( a.Name = 'Webserver_1 Memory' and (a.MsgID = 0  or a.MsgID is NULL)    ) or
         (a.MsgID != 0 and b.Message = 'Webserver_1 Memory' )    ) and
   ...	0.000
617	leutek	::1:63290	zissystem	Query	20932	statistics	select distinct a.RBNr, a.OTypNr, a.RelNr, a.Active, a.Name, a.Description, a.ZISObjectType, a.VersNr, a.LastModified, a.LMByHostName, a.LMByHandlerName, a.LMByZISUserID, a.LMByUniqueID, a.MarkedAsDeleted, a.MsgID, a.IsSynchronized, a.ZISUniversalIDCreat...	0.000
618	leutek	::1:63291	zissystem	Query	20928	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L2' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
619	leutek	::1:63303	zissystem	Query	20867	Sending data	select distinct
  a.RBNr
 from NumericUnitDef a
 where
  a.Name            = 'Power Consumption LeuTek DataCenter L1' and
  a.OTypNr          = 14 and
  (a.MsgID = 0 or a.MsgID is NULL) and
  a.ZISObjectType   = 1 and
  a.MarkedAsDeleted = 0
 union
 select distinc...	0.000
620	leutek	::1:63342	status	Query	20667	update	insert into currenteustatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus
 )
 values
 (100008, 18, 1114, '2018-07-19T00:52:11', 90, '22d45b10', 1, 0, 0
 )
 ,
 (100008,...	0.000
621	leutek	::1:63350	zissystem	Query	14929	statistics	select RelNr, Name, 0 from ServiceObjectDef where RBNr = 103083 and OTypNr = 98	0.000
622	leutek	::1:63399	status	Query	20360	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
623	leutek	::1:63477	status	Query	20051	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
624	leutek	::1:63523	status	Query	19751	update	insert into serviceobjectstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (103083, 98, 0, '2018-07-19T...	0.000
625	leutek	::1:63574	status	Query	19450	update	insert into zisobjectgroupstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  ZISObjectGroupGroupType,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (...	0.000
627	leutek	::1:63614	status	Query	19150	update	insert into currenteustatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus
 )
 values
 (100008, 18, 1114, '2018-07-19T00:52:11', 90, '22d45b10', 1, 0, 0
 )
 ,
 (100008,...	0.000
671	leutek	::1:63704	status	Query	18849	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
672	leutek	::1:63757	status	Query	18549	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
673	leutek	::1:63807	status	Query	18248	update	insert into serviceobjectstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (103083, 98, 0, '2018-07-19T...	0.000
678	leutek	::1:63851	status	Query	17947	update	insert into zisobjectgroupstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  ZISObjectGroupGroupType,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (...	0.000
680	leutek	::1:63879	status	Query	17647	update	insert into currenteustatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus
 )
 values
 (100008, 18, 1114, '2018-07-19T00:52:11', 90, '22d45b10', 1, 0, 0
 )
 ,
 (100008,...	0.000
725	leutek	::1:64003	status	Query	17346	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
726	leutek	::1:64065	status	Query	17046	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
727	leutek	::1:64116	status	Query	16745	update	insert into serviceobjectstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (103083, 98, 0, '2018-07-19T...	0.000
728	leutek	::1:64173	status	Query	16445	update	insert into zisobjectgroupstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  ZISObjectGroupGroupType,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (...	0.000
729	leutek	::1:64225	status	Query	16144	update	insert into currenteustatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus
 )
 values
 (100008, 18, 1114, '2018-07-19T00:52:11', 90, '22d45b10', 1, 0, 0
 )
 ,
 (100008,...	0.000
730	leutek	::1:64279	status	Query	15842	update	insert into calculationunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValu...	0.000
731	leutek	::1:64328	status	Query	15540	update	insert into numericunitstatus20180719(
  RBNr,
  OTypNr,
  LastModified,
  EventUnitState,
  IsCurrentStatus,
  Value,
  TextValue,
  Unit,
  MsgIDUnit,
  IsAverageValueCalculated,
  AverageValue,
  AverageValueStatus,
  IsTrendCalculated,
  TrendValue,
  TrendValueSta...	0.000
732	leutek	::1:64382	status	Query	15233	update	insert into serviceobjectstatus20180719(
  RBNr,
  OTypNr,
  UniqueEventUnitID,
  LastModified,
  EventUnitState,
  StateText,
  AcknowledgeFlag,
  RevisionFlag,
  IsCurrentStatus,
  DeterminingItemOTypNr,
  DeterminingItemRBNr
 )
 values
 (103083, 98, 0, '2018-07-19T...	0.000
741	leutek	::1:64479	zissystem	Query	14629	statistics	select RelNr, Name, 0 from ServiceObjectDef where RBNr = 103083 and OTypNr = 98	0.000
838	leutek	::1:50422	zissystem	Query	7608	Updating	update ConfigItemDef
 set
   LastModified    = '2018-07-19 04:50:02.000000',
    LMByHostName    = 'H2318784',
    LMByHandlerName = 'DataHandler',
    LMByZISUserID   = 'leutek',
    LMByUniqueID    = 0,
    VersNr          = VersNr + 1
 ,
  Value        = Pendi...	0.000
845	leutek	127.0.0.1:51510		Sleep	64			0.000
846	leutek	127.0.0.1:51511		Query	0		show full processlist	0.000