Die Daten hat das Vitosoft Program im Database gespeichert. Mit diesen Query an die Database (man braucht dazu z.B. SQL Server Management Studio) kan man die Daten der leltzen Synchronisation lesen. Die DeviceId bekommt man in die Tabelle ecnDevice (Id). Die Database Dateien sind in C:\Program Files\Viessmann Vitosoft 300 SID1\ServiceTool\Database. Select dev.Name, et.Address, substring(et.address,charindex('~',et.address)+1,6) Parameter, et.Conversion, ete.ByteLength, case et.Type when 1 then 'R' when 2 then 'R'when 3 then'R/W' else '' end ReadWrite, ev.Unit, ev.Stepping, ev.DataType, ev.ValuePrecision, ev.LowerBorder, ev.UpperBorder, ev.DataType, ev.ValuePrecision, ev.LowerBorder, ev.UpperBorder, evc.ValueType, evc.Value_Binary, evc.Value_Bit, evc.Value_DateTime, evc.Value_Float, evc.Value_Int, evc.Value_Ntext, string_AGG(ev.EnumAddressValue,',') as 'Values', string_AGG(ev.Description,',') as Descriptions from ecnDevice dev join ecnEventGroupValueCache evc on dev.Id=evc.DeviceId join ecnEventType et on evc.EventTypeId=et.Id join ecnEventValueType evt on evc.EventValueTypeId=evt.Id left outer join ecnEventTypeEventValueTypeLink etvl on etvl.EventTypeId=et.Id left outer join ecnEventValueType ev on etvl.EventValueId=ev.Id left outer join [vsmEventTypeExtension] ete on ete.EventTypeId=et.Id where DeviceId=x group by dev.Name, et.Address, substring(et.address,charindex('~',et.address)+1,6), et.Conversion, case et.Type when 1 then 'R' when 2 then 'R'when 3 then'R/W' else '' end, ete.ByteLength, et.DefaultValue, ev.Unit, ev.Stepping, ev.DataType, ev.ValuePrecision, ev.LowerBorder, ev.UpperBorder, evc.ValueType, evc.Value_Binary, evc.Value_Bit, evc.Value_DateTime, evc.Value_Float, evc.Value_Int, evc.Value_Ntext, ev.DataType, ev.ValuePrecision, ev.LowerBorder, ev.UpperBorder Order by Parameter;
... Mehr anzeigen