how to export data from SQL WINCC

hello

we have turbine use a wincc and we can use this software to see the log from history

but i want to export this data in any file(excel,txt,csv,....)

i use a microsoft SQL server to show the tables for Alarm and Slow and Fast mdf files

alarm === no problem and it successfully viewed

slow and fast , i have 3 database tables(Archive,tagcompressed ,taguncompressed)

archive have 273 rows with unkown data

tagcompressed have data like following row

ValueID Timebegin Timeend BinValues
709 2009-12-08 21:44:35.930 2009-12-08 21:48:36.940 0x58050000032020EC07E3010000B9EDB7FD7C9BE340F40100002702A6A0BC601002000F1800000400229269043EBE8C82DD15794102A446208F6318D052176E6825B2672413200C220B48C60D04BD90B28200BC66416CDD3EA083AC13904ECC11082DE346C415B9BAC20B69726505B68A9282685E83414E3A3C208712D290425E50C8284BC5C413AD74CA09CE55ED04DA1CD282F96E8C4174C6B720B8DF16104AE8C9E820DAF994165D939A0BCCD621054A3EA8821CBA8141116B29A0892792905F32D0E825D91574116B02EA0B8701C904444EDE824C74804155CE27A08C18221057C0AFE8206426D4120CF4020ADAB93905814CF48224B369416FBF29A080441D1059ECC8E8228C952417DA82F2090A8219048EC50682CA9B5741336339209D1B1CD05C70CA682A3638D41658AB4A0B73FA15048A96F682BD2F5041682143A09BEC60D05E6D8B8822E7659417E59C6A0B8AB5E505C20EF482916D5441224BC3A0A47C5D50544BF0682A0BC554107E930A09349D7104FB311882F83A6D413C8EC3A0955C9E105F08EA4821275804140804D20AC1B631055817108288FD4D416C20BB209E1953104E9D718822FC85C417FB72A20BE99235041616A682A8234C411A03A4209E26A0105281F1082766969412842C1A0973BD2D04FF02CE8253D247416A0844208127E01051F10C68283BE524122E337A0B46C5CD04D29C9E826453564176EA2820B9A797D04B64CE48237703F414674B520AB7C92905B1131082EF916D4124A525A08ED4E11041490D682C526804126D63D20B8F1DC9058A8F0E826B1A55412046AC20A539E09047AD5048250215D4153D9C1A0AA81129057403088214805441799A38A09EAADA905BD84E68236BE794150952920B0ABA6505559ACE8246658D414AD04320AA2561D04F5848E823DA84A410227A520B7809FD058DE70C82DCAB56411B72C120B49D95105B1EB3482620584412645B7209C3D5A904B25AF8825C7572413AD43FA0A403DA505819CF082FD187941063CA420BEE456105AA52AA825650594133312720B73D66905DF22DA82C52680413638B1209DE5E3105DE989E82ABFF6941364525A0BFACE0D05C77E92821912494129D0BAA08BD652904493C948266B65A415F0D23209A17A0D059C7B1A82E5CB7241549BA9A09E0314D0498089C823BA17F41298B272096D4A6904C6A6F482203A54412D67AA20899552504021CD4823FA275412356AB209A11D2504FCDF0E82B91F68410C154020BF96D8D04E45AC882EF4C4F414439C02086B5DB905269D008202906E414C88C6A082BA6090553C4C08218784C411934BCA0BA5959904CCC2FC826ABA594103F02C20A66ADB105EB78CA82D4725C413190AE2085085510418AC9482A7517A410314ADA0A944DF9047786DE82CB6F72414FF32820811DA01054F70BA824F1549414DEAACA0BF3A53D055AF2A88206E88741251AB2209E291B104BEB4BC82F71E78411C8641A0B70B9BD0468F69882FC166841758CB820BB9F1C9048EDAF082E2016A41377BA120A95AD7104159B34828F98874155B7C620931B99504CFDD0082042D50415316BBA0B80656905D572B882B72251410BF6C620A4EC54D05352D048287C465413013402091FC16505ACCCFC82BB1E9B410AFA4320ACE7D2904D1DCD482DB0F88417098BE20A01F16D05D2C09C82A07C6E41397D24A09B8C9BD05604CB28212E88C411A19A620BD2561D05F08EA48240708C41266DAC20A3386090448E298825089884150EBB220AB169F905437F0E8263104641272FBF20A23F53504F1EB0C82A9E3504119DBB9A096C358D044CB8FE8226094D4109333CA08B29269056BE69A8278A87A411E1CC420A28C9C905C20EF482D471734159CD27A0B4531B50425E50C82266F524128352520841E94505D05EA282FB6D5A410D46C6A093011390489D518825ACF6F41527BC5A0B702E0D0580D0948209CA864167B9ADA0BC79E09050906B28261AA6A4116CA4120951B20905EE9D00822F594A412148A220B0DD971053E49008232164D41568D3320B07F9FD05F790A882E1EB70410CDAAD20BA7021D05B7AD0682874D5F41609AB0209D1CD4905A0850E82EBD15B4112C5ADA08A899950499F4D882C0217241022AA7A0ACC0DD5045A7B1A828FB46B410E263DA087B41950408EEA482E38653416EBF2320B8EAD8D05C994E4824BF68B41065A24A09FAE1E5048CCB1A8244988C413E27352089C895505CEA5088238D85F410DA9C5A0A6DF1710583FCFE8274EB8C413E75A1A090551E90523E2EA82A494874148D245A08DC5D490526C30682622959413D494120AC44955057DCF0E8225B68D413E5F39A0B683DF904FC68DC82C77B6F41272FBF20BD5C12505B018F2828DBD5A4153BF2A20B58360D046182A882661D684113DCAAA0B06C9E504F0D0C482163D5741672A3AA090CE54105DBB70682C59C4241330A3820BF57E0D055F56FE820F02844174CC36A0BB4D265041EBD06827AC1494162F7BDA08BDF9850451E2BC822D94824110A0A9A0B62262104D4390E82BE614A410278C0A0817F1350504DCE082B921624161DFC620B128E19045EA4BC82AA6188417B9E46A08A91E1D04834EFE82E5CB7241418AAAA0AE13D7905D028848293009A413CDAB420B0E495D05973CDA826CE1604143343F20AC4495505CD64AA828F8A714115CE27A09F2F9CD05B9AEB682CF5A47415BEBCCA08E8F9B505C756C68242B074415E1C2220AD1E619059ECC8E827F8046414A44C4209B8751D050168E88215747D4114BDB2A0B107A6D058E3D368260CE8B416CD4A3A0876FD21042FDB1882E3038441266DAC20BDABA6504334C8482

the taguncompressed have no data

have one can help me how to export the historical data?

and is there are any anther folder contain data ?

You should search for "WinCC Connectivity Pack".
Archive data in WinCC are stored in DB in compressed form, so you can not directly access them. Via OLEDB you can access archive by SQL query like TAG:R(id, start_timestamp, stop_timestamp).

As far as I remember, you should search application examples at Siemen's support page. I saw here an example, that might be useful:

https://support.automation.siemens....d=34677186&lang=en&cspltfrm=0&cssw=0&csbinh=8

https://support.automation.siemens....t=-DOCDATUMBEITRAG&csQuery4=c#&subtype=136000

You should be also aware, that you should buy licence for WinCC Connectivity Pack.