540 lines
17 KiB
PowerShell
540 lines
17 KiB
PowerShell
$devices = @"
|
|
DeviceId FromDate ToDate
|
|
0x13C71C 2016-12-18 2016-12-18
|
|
0x13C6C0 2016-12-18 2016-12-18
|
|
0x1389F4 2016-12-18 2016-12-18
|
|
0x1389B0 2016-12-18 2016-12-18
|
|
0x13C6DE 2016-12-18 2016-12-18
|
|
0x13CABB 2016-12-18 2016-12-18
|
|
0x13C6A9 2016-12-18 2016-12-18
|
|
0x138A1A 2016-12-18 2016-12-18
|
|
0x13CB87 2016-12-18 2016-12-18
|
|
0x138A0A 2016-12-18 2016-12-18
|
|
0x1393CE 2016-12-10 2016-12-18
|
|
0x138951 2016-12-18 2016-12-18
|
|
0x13F401 2016-12-18 2016-12-18
|
|
0x13CB8A 2016-12-18 2016-12-18
|
|
0x13C715 2016-12-18 2016-12-18
|
|
0x13D024 2016-12-09 2016-12-18
|
|
0x13CF4D 2016-12-09 2016-12-18
|
|
0x138905 2016-12-10 2016-12-18
|
|
0x13CF55 2016-12-18 2016-12-18
|
|
0x138A04 2016-12-18 2016-12-18
|
|
0x13891F 2016-12-18 2016-12-18
|
|
0x13C89A 2016-12-18 2016-12-18
|
|
0x13F431 2016-12-18 2016-12-18
|
|
0x13D2AE 2016-12-09 2016-12-18
|
|
0x13F5FA 2016-12-18 2016-12-18
|
|
0x13893D 2016-12-18 2016-12-18
|
|
0x1389FF 2016-12-18 2016-12-18
|
|
0x139DB1 2016-12-18 2016-12-18
|
|
0x13CC95 2016-12-18 2016-12-18
|
|
0x138911 2016-12-18 2016-12-18
|
|
0x138909 2016-12-18 2016-12-18
|
|
0x13C6E2 2016-12-18 2016-12-18
|
|
0x1389A7 2016-12-09 2016-12-18
|
|
0x13C5AE 2016-12-18 2016-12-18
|
|
0x13C934 2016-12-18 2016-12-18
|
|
0x13C7A8 2016-12-18 2016-12-18
|
|
0x13F4C2 2016-12-18 2016-12-18
|
|
0x139293 2016-12-09 2016-12-18
|
|
0x13F5F9 2016-12-18 2016-12-18
|
|
0x13CD10 2016-12-18 2016-12-18
|
|
0x138996 2016-12-18 2016-12-18
|
|
0x13935C 2016-12-18 2016-12-18
|
|
0x13C5CD 2016-12-18 2016-12-18
|
|
0x13D19B 2016-12-18 2016-12-18
|
|
0x13D1A8 2016-12-18 2016-12-18
|
|
0x13F49D 2016-12-18 2016-12-18
|
|
0x138918 2016-12-09 2016-12-18
|
|
0x13CF6D 2016-12-18 2016-12-18
|
|
0x1392F5 2016-12-18 2016-12-18
|
|
0x138900 2016-12-09 2016-12-18
|
|
0x138900 2016-12-09 2016-12-18
|
|
0x1391CE 2016-12-09 2016-12-18
|
|
0x13C6FB 2016-12-18 2016-12-18
|
|
0x138900 2016-12-09 2016-12-18
|
|
0x138900 2016-12-09 2016-12-18
|
|
0x139D01 2016-12-18 2016-12-18
|
|
0x13C741 2016-12-18 2016-12-18
|
|
0x13C650 2016-12-09 2016-12-18
|
|
0x13F765 2016-12-18 2016-12-18
|
|
0x13893C 2016-12-09 2016-12-16
|
|
0x1389EA 2016-12-18 2016-12-18
|
|
0x13CF33 2016-12-18 2016-12-18
|
|
0x13C615 2016-12-18 2016-12-18
|
|
0x13C7AB 2016-12-18 2016-12-18
|
|
0x13F32A 2016-12-18 2016-12-18
|
|
0x13934A 2016-12-18 2016-12-18
|
|
0x138962 2016-12-18 2016-12-18
|
|
0x13CBE7 2016-12-18 2016-12-18
|
|
0x139CF7 2016-12-18 2016-12-18
|
|
0x13935F 2016-12-18 2016-12-18
|
|
0x13F79D 2016-12-18 2016-12-18
|
|
0x13C7F2 2016-12-18 2016-12-18
|
|
0x138915 2016-12-10 2016-12-18
|
|
0x138907 2016-12-18 2016-12-18
|
|
0x13F5ED 2016-12-18 2016-12-18
|
|
0x1389B3 2016-12-18 2016-12-18
|
|
0x13F5F0 2016-12-18 2016-12-18
|
|
0x13898B 2016-12-18 2016-12-18
|
|
0x13D1E3 2016-12-18 2016-12-18
|
|
0x13CAAD 2016-12-09 2016-12-18
|
|
0x13F4C8 2016-12-18 2016-12-18
|
|
0x13F48A 2016-12-18 2016-12-18
|
|
0x13928E 2016-12-18 2016-12-18
|
|
0x1389D0 2016-12-18 2016-12-18
|
|
0x13D1AA 2016-12-18 2016-12-18
|
|
0x13C571 2016-12-18 2016-12-18
|
|
0x13D022 2016-12-18 2016-12-18
|
|
0x13F58F 2016-12-18 2016-12-18
|
|
0x13CF20 2016-12-09 2016-12-18
|
|
0x1389CD 2016-12-13 2016-12-18
|
|
0x138916 2016-12-18 2016-12-18
|
|
0x13CBDE 2016-12-18 2016-12-18
|
|
0x13C8E0 2016-12-18 2016-12-18
|
|
0x1389C3 2016-12-09 2016-12-18
|
|
0x139D25 2016-12-18 2016-12-18
|
|
0x13CFEC 2016-12-09 2016-12-18
|
|
0x13F4F3 2016-12-18 2016-12-18
|
|
0x139237 2016-12-18 2016-12-18
|
|
0x13F740 2016-12-18 2016-12-18
|
|
0x13C626 2016-12-18 2016-12-18
|
|
0x13CD3C 2016-12-18 2016-12-18
|
|
0x13892D 2016-12-09 2016-12-12
|
|
0x13F342 2016-12-18 2016-12-18
|
|
0x13C5D6 2016-12-09 2016-12-18
|
|
0x139171 2016-12-09 2016-12-18
|
|
0x13C765 2016-12-18 2016-12-18
|
|
0x139CB7 2016-12-18 2016-12-18
|
|
0x13CD02 2016-12-18 2016-12-18
|
|
0x13CCEB 2016-12-18 2016-12-18
|
|
0x13F3AD 2016-12-18 2016-12-18
|
|
0x139D38 2016-12-18 2016-12-18
|
|
0x13F425 2016-12-18 2016-12-18
|
|
0x13F405 2016-12-18 2016-12-18
|
|
0x13893F 2016-12-18 2016-12-18
|
|
0x13C7B4 2016-12-18 2016-12-18
|
|
0x13F40A 2016-12-18 2016-12-18
|
|
0x13F544 2016-12-18 2016-12-18
|
|
0x13CCA1 2016-12-18 2016-12-18
|
|
0x13C708 2016-12-18 2016-12-18
|
|
0x139206 2016-12-18 2016-12-18
|
|
0x13C604 2016-12-18 2016-12-18
|
|
0x131F38 2016-12-09 2016-12-09
|
|
0x13895C 2016-12-18 2016-12-18
|
|
0x13C7B6 2016-12-18 2016-12-18
|
|
0x138949 2016-12-18 2016-12-18
|
|
0x1392FC 2016-12-18 2016-12-18
|
|
0x13937A 2016-12-18 2016-12-18
|
|
0x13F36D 2016-12-18 2016-12-18
|
|
0x13F61E 2016-12-18 2016-12-18
|
|
0x13F72E 2016-12-18 2016-12-18
|
|
0x138923 2016-12-18 2016-12-18
|
|
0x13CB7B 2016-12-09 2016-12-09
|
|
0x13CC06 2016-12-09 2016-12-18
|
|
0x13C55D 2016-12-18 2016-12-18
|
|
0x13F553 2016-12-18 2016-12-18
|
|
0x13CBFA 2016-12-18 2016-12-18
|
|
0x13CF82 2016-12-09 2016-12-18
|
|
0x13F502 2016-12-18 2016-12-18
|
|
0x13C86D 2016-12-18 2016-12-18
|
|
0x13C6DF 2016-12-18 2016-12-18
|
|
0x139176 2016-12-10 2016-12-18
|
|
0x139296 2016-12-18 2016-12-18
|
|
0x139409 2016-12-12 2016-12-14
|
|
0x13C873 2016-12-18 2016-12-18
|
|
0x13CF5E 2016-12-18 2016-12-18
|
|
0x138953 2016-12-18 2016-12-18
|
|
0x13F744 2016-12-18 2016-12-18
|
|
0x138952 2016-12-18 2016-12-18
|
|
0x13C6B2 2016-12-09 2016-12-12
|
|
0x13C613 2016-12-18 2016-12-18
|
|
0x13C7BD 2016-12-18 2016-12-18
|
|
0x13F42C 2016-12-18 2016-12-18
|
|
0x13F299 2016-12-18 2016-12-18
|
|
0x139CAB 2016-12-18 2016-12-18
|
|
0x13F435 2016-12-18 2016-12-18
|
|
0x13C771 2016-12-18 2016-12-18
|
|
0x13CC17 2016-12-18 2016-12-18
|
|
0x13CC99 2016-12-18 2016-12-18
|
|
0x13CBCC 2016-12-18 2016-12-18
|
|
0x138A11 2016-12-18 2016-12-18
|
|
0x138924 2016-12-18 2016-12-18
|
|
0x138960 2016-12-18 2016-12-18
|
|
0x1389E5 2016-12-18 2016-12-18
|
|
0x13D290 2016-12-18 2016-12-18
|
|
0x13D297 2016-12-14 2016-12-18
|
|
0x1392AE 2016-12-18 2016-12-18
|
|
0x13C93E 2016-12-18 2016-12-18
|
|
0x13D1E4 2016-12-09 2016-12-18
|
|
0x13F6A1 2016-12-18 2016-12-18
|
|
0x13CFEB 2016-12-18 2016-12-18
|
|
0x13C924 2016-12-18 2016-12-18
|
|
0x139246 2016-12-18 2016-12-18
|
|
0x13CAAE 2016-12-18 2016-12-18
|
|
0x13F4C4 2016-12-18 2016-12-18
|
|
0x13F2E3 2016-12-18 2016-12-18
|
|
0x13C8B2 2016-12-18 2016-12-18
|
|
0x13F77F 2016-12-18 2016-12-18
|
|
0x13C603 2016-12-18 2016-12-18
|
|
0x13C89B 2016-12-18 2016-12-18
|
|
0x13F664 2016-12-18 2016-12-18
|
|
0x138969 2016-12-10 2016-12-11
|
|
0x13F771 2016-12-18 2016-12-18
|
|
0x13942C 2016-12-10 2016-12-18
|
|
0x13CB43 2016-12-09 2016-12-10
|
|
0x13D234 2016-12-18 2016-12-18
|
|
0x13D1FE 2016-12-18 2016-12-18
|
|
0x13CAB9 2016-12-18 2016-12-18
|
|
0x13C886 2016-12-18 2016-12-18
|
|
0x139212 2016-12-18 2016-12-18
|
|
0x13F668 2016-12-18 2016-12-18
|
|
0x13F542 2016-12-18 2016-12-18
|
|
0x13C769 2016-12-12 2016-12-18
|
|
0x13D20A 2016-12-09 2016-12-18
|
|
0x13CAB0 2016-12-18 2016-12-18
|
|
0x13F442 2016-12-18 2016-12-18
|
|
0x1389FA 2016-12-18 2016-12-18
|
|
0x13F3DD 2016-12-18 2016-12-18
|
|
0x13C69E 2016-12-18 2016-12-18
|
|
0x13F7AC 2016-12-18 2016-12-18
|
|
0x13CF52 2016-12-18 2016-12-18
|
|
0x13C927 2016-12-18 2016-12-18
|
|
0x139345 2016-12-18 2016-12-18
|
|
0x13CC8D 2016-12-18 2016-12-18
|
|
0x13D164 2016-12-18 2016-12-18
|
|
0x13CC21 2016-12-18 2016-12-18
|
|
0x13D254 2016-12-18 2016-12-18
|
|
0x138930 2016-12-18 2016-12-18
|
|
0x1389C4 2016-12-18 2016-12-18
|
|
0x13CB67 2016-12-18 2016-12-18
|
|
0x13F5C7 2016-12-18 2016-12-18
|
|
0x13CBE8 2016-12-09 2016-12-09
|
|
0x139331 2016-12-18 2016-12-18
|
|
0x139284 2016-12-18 2016-12-18
|
|
0x13F552 2016-12-18 2016-12-18
|
|
0x13F45B 2016-12-18 2016-12-18
|
|
0x13F742 2016-12-18 2016-12-18
|
|
0x13CD57 2016-12-18 2016-12-18
|
|
0x13C7E3 2016-12-09 2016-12-09
|
|
0x13C946 2016-12-18 2016-12-18
|
|
0x13939C 2016-12-18 2016-12-18
|
|
0x13CC0E 2016-12-18 2016-12-18
|
|
0x13CD7A 2016-12-18 2016-12-18
|
|
0x13F2BD 2016-12-18 2016-12-18
|
|
0x13C663 2016-12-18 2016-12-18
|
|
0x13F475 2016-12-18 2016-12-18
|
|
0x13CCE7 2016-12-18 2016-12-18
|
|
0x13CD6E 2016-12-18 2016-12-18
|
|
0x13CD1F 2016-12-18 2016-12-18
|
|
0x1392EC 2016-12-18 2016-12-18
|
|
0x13F34E 2016-12-18 2016-12-18
|
|
0x13943E 2016-12-18 2016-12-18
|
|
0x13C84E 2016-12-18 2016-12-18
|
|
0x138986 2016-12-09 2016-12-09
|
|
0x1391C3 2016-12-18 2016-12-18
|
|
0x13CCE1 2016-12-10 2016-12-10
|
|
0x13D1DE 2016-12-18 2016-12-18
|
|
0x13CC59 2016-12-18 2016-12-18
|
|
0x13F64C 2016-12-18 2016-12-18
|
|
0x13D251 2016-12-09 2016-12-09
|
|
0x1388F5 2016-12-18 2016-12-18
|
|
0x13C889 2016-12-11 2016-12-11
|
|
0x13CF1E 2016-12-18 2016-12-18
|
|
0x13F560 2016-12-18 2016-12-18
|
|
0x13CF60 2016-12-18 2016-12-18
|
|
0x13D1DB 2016-12-18 2016-12-18
|
|
0x13CFFE 2016-12-18 2016-12-18
|
|
0x13F79E 2016-12-18 2016-12-18
|
|
0x13C6CF 2016-12-18 2016-12-18
|
|
0x139D3E 2016-12-18 2016-12-18
|
|
0x13F332 2016-12-18 2016-12-18
|
|
0x139297 2016-12-18 2016-12-18
|
|
0x13C4E2 2016-12-18 2016-12-18
|
|
0x139C48 2016-12-18 2016-12-18
|
|
0x13F4D9 2016-12-18 2016-12-18
|
|
0x139453 2016-12-18 2016-12-18
|
|
0x13899F 2016-12-09 2016-12-09
|
|
0x138942 2016-12-09 2016-12-09
|
|
0x13F623 2016-12-18 2016-12-18
|
|
0x13892A 2016-12-09 2016-12-09
|
|
0x13CD0C 2016-12-18 2016-12-18
|
|
0x13899B 2016-12-18 2016-12-18
|
|
0x1389EB 2016-12-18 2016-12-18
|
|
0x13D033 2016-12-15 2016-12-15
|
|
0x13F69D 2016-12-18 2016-12-18
|
|
0x13D203 2016-12-18 2016-12-18
|
|
0x13F653 2016-12-18 2016-12-18
|
|
0x13F5D0 2016-12-18 2016-12-18
|
|
0x13C538 2016-12-18 2016-12-18
|
|
0x13C751 2016-12-09 2016-12-09
|
|
0x1392D7 2016-12-18 2016-12-18
|
|
0x13D189 2016-12-09 2016-12-09
|
|
0x13D01D 2016-12-18 2016-12-18
|
|
0x13F460 2016-12-18 2016-12-18
|
|
0x13F540 2016-12-18 2016-12-18
|
|
0x13C776 2016-12-09 2016-12-09
|
|
0x13D218 2016-12-18 2016-12-18
|
|
0x13F59C 2016-12-18 2016-12-18
|
|
0x13F6B7 2016-12-18 2016-12-18
|
|
0x13CB95 2016-12-18 2016-12-18
|
|
0x13CB99 2016-12-18 2016-12-18
|
|
0x13F570 2016-12-18 2016-12-18
|
|
0x13C7F0 2016-12-18 2016-12-18
|
|
0x139220 2016-12-18 2016-12-18
|
|
0x13C8C8 2016-12-18 2016-12-18
|
|
0x13C65A 2016-12-09 2016-12-09
|
|
0x13C90E 2016-12-18 2016-12-18
|
|
0x13CC9B 2016-12-18 2016-12-18
|
|
0x13CC49 2016-12-18 2016-12-18
|
|
0x139424 2016-12-18 2016-12-18
|
|
0x1391BD 2016-12-18 2016-12-18
|
|
0x13CF63 2016-12-18 2016-12-18
|
|
0x13C67D 2016-12-18 2016-12-18
|
|
0x13C668 2016-12-10 2016-12-10
|
|
0x13F4F1 2016-12-18 2016-12-18
|
|
0x13CFE3 2016-12-18 2016-12-18
|
|
0x13C8BC 2016-12-18 2016-12-18
|
|
0x13F6C9 2016-12-18 2016-12-18
|
|
0x13F3D0 2016-12-18 2016-12-18
|
|
0x13F466 2016-12-18 2016-12-18
|
|
0x13F682 2016-12-18 2016-12-18
|
|
0x13C65C 2016-12-18 2016-12-18
|
|
0x139C73 2016-12-18 2016-12-18
|
|
0x13F6B3 2016-12-18 2016-12-18
|
|
0x13CF70 2016-12-18 2016-12-18
|
|
0x1391BE 2016-12-18 2016-12-18
|
|
0x13CFDB 2016-12-18 2016-12-18
|
|
0x13F6D2 2016-12-18 2016-12-18
|
|
0x13CAB5 2016-12-18 2016-12-18
|
|
0x139D47 2016-12-18 2016-12-18
|
|
0x13CCF5 2016-12-18 2016-12-18
|
|
0x13C780 2016-12-18 2016-12-18
|
|
0x13C6A5 2016-12-18 2016-12-18
|
|
0x139C61 2016-12-09 2016-12-09
|
|
0x13C6FA 2016-12-18 2016-12-18
|
|
0x139201 2016-12-18 2016-12-18
|
|
0x13CD3D 2016-12-18 2016-12-18
|
|
0x13F739 2016-12-18 2016-12-18
|
|
0x13F2CF 2016-12-18 2016-12-18
|
|
0x13F420 2016-12-18 2016-12-18
|
|
0x13D165 2016-12-18 2016-12-18
|
|
0x13CD25 2016-12-18 2016-12-18
|
|
0x13F489 2016-12-18 2016-12-18
|
|
0x13C705 2016-12-18 2016-12-18
|
|
0x13F37D 2016-12-18 2016-12-18
|
|
0x13CB3B 2016-12-18 2016-12-18
|
|
0x13C50B 2016-12-18 2016-12-18
|
|
0x13C649 2016-12-18 2016-12-18
|
|
0x13CD65 2016-12-18 2016-12-18
|
|
0x13CF32 2016-12-18 2016-12-18
|
|
0x139C6A 2016-12-18 2016-12-18
|
|
0x13CBD7 2016-12-18 2016-12-18
|
|
0x13CB8E 2016-12-18 2016-12-18
|
|
0x138913 2016-12-18 2016-12-18
|
|
0x138946 2016-12-18 2016-12-18
|
|
0x138929 2016-12-13 2016-12-13
|
|
0x13CC60 2016-12-18 2016-12-18
|
|
0x138921 2016-12-18 2016-12-18
|
|
0x1389C9 2016-12-12 2016-12-12
|
|
0x138956 2016-12-18 2016-12-18
|
|
0x138935 2016-12-18 2016-12-18
|
|
0x138959 2016-12-18 2016-12-18
|
|
0x13F67C 2016-12-18 2016-12-18
|
|
0x13892C 2016-12-18 2016-12-18
|
|
0x1388FF 2016-12-18 2016-12-18
|
|
0x1389F9 2016-12-18 2016-12-18
|
|
0x13C788 2016-12-18 2016-12-18
|
|
0x13F445 2016-12-18 2016-12-18
|
|
0x13D1D8 2016-12-18 2016-12-18
|
|
0x13CF56 2016-12-10 2016-12-10
|
|
0x13D269 2016-12-18 2016-12-18
|
|
0x13D275 2016-12-12 2016-12-12
|
|
0x13F516 2016-12-18 2016-12-18
|
|
0x13CC92 2016-12-18 2016-12-18
|
|
0x13C6FD 2016-12-12 2016-12-12
|
|
0x13CCDC 2016-12-18 2016-12-18
|
|
0x13D169 2016-12-18 2016-12-18
|
|
0x13D1EC 2016-12-13 2016-12-13
|
|
0x13C614 2016-12-18 2016-12-18
|
|
0x13C81B 2016-12-18 2016-12-18
|
|
0x139308 2016-12-18 2016-12-18
|
|
0x13C79B 2016-12-18 2016-12-18
|
|
0x13C8D8 2016-12-18 2016-12-18
|
|
0x13D288 2016-12-18 2016-12-18
|
|
0x13895E 2016-12-18 2016-12-18
|
|
0x13CAAA 2016-12-18 2016-12-18
|
|
0x1390FF 2016-12-18 2016-12-18
|
|
0x13C52F 2016-12-18 2016-12-18
|
|
0x13C5F7 2016-12-18 2016-12-18
|
|
0x13C93F 2016-12-18 2016-12-18
|
|
0x13D209 2016-12-18 2016-12-18
|
|
0x13C540 2016-12-12 2016-12-12
|
|
0x139CA4 2016-12-18 2016-12-18
|
|
0x13F586 2016-12-18 2016-12-18
|
|
0x13F3C9 2016-12-18 2016-12-18
|
|
0x13CFFF 2016-12-18 2016-12-18
|
|
0x13F5A8 2016-12-18 2016-12-18
|
|
0x133569 2016-12-18 2016-12-18
|
|
0x1389AF 2016-12-18 2016-12-18
|
|
0x13CFC6 2016-12-18 2016-12-18
|
|
0x1391EF 2016-12-18 2016-12-18
|
|
0x13C8F5 2016-12-18 2016-12-18
|
|
0x13CFA5 2016-12-09 2016-12-09
|
|
0x13F532 2016-12-18 2016-12-18
|
|
0x13944A 2016-12-18 2016-12-18
|
|
0x13F5F6 2016-12-18 2016-12-18
|
|
0x13F3CC 2016-12-18 2016-12-18
|
|
0x13C8EE 2016-12-18 2016-12-18
|
|
0x13931C 2016-12-18 2016-12-18
|
|
0x13D1AE 2016-12-18 2016-12-18
|
|
0x13D1EE 2016-12-18 2016-12-18
|
|
0x13C837 2016-12-10 2016-12-10
|
|
0x13C607 2016-12-18 2016-12-18
|
|
0x13C839 2016-12-18 2016-12-18
|
|
0x13F6AF 2016-12-18 2016-12-18
|
|
0x13CB39 2016-12-18 2016-12-18
|
|
0x13CC0A 2016-12-18 2016-12-18
|
|
0x13C63A 2016-12-18 2016-12-18
|
|
0x13C7C4 2016-12-18 2016-12-18
|
|
0x13CD81 2016-12-18 2016-12-18
|
|
0x13F3C3 2016-12-18 2016-12-18
|
|
0x138944 2016-12-18 2016-12-18
|
|
0x13CD13 2016-12-18 2016-12-18
|
|
0x13CFCF 2016-12-17 2016-12-17
|
|
0x1389B1 2016-12-09 2016-12-09
|
|
0x13F6B1 2016-12-18 2016-12-18
|
|
0x13893E 2016-12-18 2016-12-18
|
|
0x13F48F 2016-12-18 2016-12-18
|
|
0x13F732 2016-12-18 2016-12-18
|
|
0x13D166 2016-12-18 2016-12-18
|
|
0x13890A 2016-12-18 2016-12-18
|
|
0x13C710 2016-12-18 2016-12-18
|
|
0x13CF46 2016-12-18 2016-12-18
|
|
0x13D1D0 2016-12-18 2016-12-18
|
|
0x138991 2016-12-18 2016-12-18
|
|
0x13F5EC 2016-12-18 2016-12-18
|
|
0x13C72E 2016-12-18 2016-12-18
|
|
0x13890B 2016-12-12 2016-12-12
|
|
0x138964 2016-12-18 2016-12-18
|
|
0x13897A 2016-12-09 2016-12-09
|
|
0x13F488 2016-12-18 2016-12-18
|
|
0x13C56C 2016-12-09 2016-12-09
|
|
0x13C6E5 2016-12-18 2016-12-18
|
|
0x13D299 2016-12-18 2016-12-18
|
|
0x13C5C3 2016-12-18 2016-12-18
|
|
0x13D2A5 2016-12-10 2016-12-10
|
|
0x139CCB 2016-12-18 2016-12-18
|
|
0x13CD0F 2016-12-18 2016-12-18
|
|
0x13C737 2016-12-18 2016-12-18
|
|
0x13C82B 2016-12-18 2016-12-18
|
|
0x13C6EE 2016-12-18 2016-12-18
|
|
0x13C890 2016-12-09 2016-12-09
|
|
0x13CF7B 2016-12-09 2016-12-09
|
|
0x13CCF2 2016-12-18 2016-12-18
|
|
0x13C930 2016-12-10 2016-12-10
|
|
0x13CC2A 2016-12-11 2016-12-11
|
|
0x13C853 2016-12-09 2016-12-09
|
|
0x13D20E 2016-12-15 2016-12-15
|
|
0x13D185 2016-12-18 2016-12-18
|
|
0x139149 2016-12-18 2016-12-18
|
|
0x13CAAB 2016-12-18 2016-12-18
|
|
0x1391A1 2016-12-18 2016-12-18
|
|
0x13CC1D 2016-12-09 2016-12-09
|
|
0x139D16 2016-12-11 2016-12-11
|
|
0x139D74 2016-12-09 2016-12-09
|
|
0x13CFDF 2016-12-11 2016-12-11
|
|
0x13C72D 2016-12-09 2016-12-09
|
|
0x13F484 2016-12-18 2016-12-18
|
|
0x13C7EC 2016-12-18 2016-12-18
|
|
0x1389A6 2016-12-18 2016-12-18
|
|
0x13CCAF 2016-12-18 2016-12-18
|
|
0x13D02C 2016-12-18 2016-12-18
|
|
0x13C8FC 2016-12-18 2016-12-18
|
|
0x13CCE6 2016-12-18 2016-12-18
|
|
0x13C5D1 2016-12-18 2016-12-18
|
|
0x13D237 2016-12-10 2016-12-10
|
|
0x133250 2016-12-14 2016-12-14
|
|
"@ | ConvertFrom-Csv -Delimiter "`t"
|
|
|
|
Write-Progress -Activity 'Get-DeviceTransactions' -Status 'Connecting to SQL' -Id 1
|
|
|
|
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection
|
|
$sqlConnection.ConnectionString = 'Server=rejk-p-sql020\sql02;Database=PDWH;Trusted_Connection=True;'
|
|
$sqlConnection.Open()
|
|
$sqlCommand = $sqlConnection.CreateCommand()
|
|
$sqlCommand.CommandTimeout = 360
|
|
|
|
$deviceCount = 1
|
|
foreach($device in $devices) {
|
|
|
|
$deviceIdHex = $device.DeviceId
|
|
$startDate = $device.FromDate
|
|
$endDate = $device.ToDate
|
|
|
|
Write-Progress -Activity "Get-DeviceTransactions" -Status "Device $deviceIdHex" -PercentComplete (100 / $devices.Count * $deviceCount++) -Id 1
|
|
|
|
|
|
$sqlCommand.CommandText = "select FileCreationDate, FileHeaderTag, FileSequenceNumber from dcp.ObjFileInformation fi with(readuncommitted) where fi.deviceid = $deviceIdHex and cast(fi.FileCreationDate as date) between '$startDate' and '$endDate'"
|
|
|
|
Write-Progress -Activity "Get-DeviceTransactions" -Status "Executing SQL reader" -ParentId 1 -Id 2
|
|
$reader = $sqlCommand.ExecuteReader()
|
|
|
|
if(-not $reader.HasRows) {
|
|
Write-Warning "Query returned no data : $($sqlCommand.CommandText)"
|
|
}
|
|
|
|
$data = while($reader.Read()) {
|
|
[pscustomobject]@{
|
|
FileCreationDate = $reader['FileCreationDate']
|
|
FileHeaderTag = $reader['FileHeaderTag']
|
|
FileSequenceNumber = $reader['FileSequenceNumber']
|
|
}
|
|
}
|
|
|
|
$reader.Close()
|
|
|
|
Write-Debug "Found $($data.Count) rows"
|
|
|
|
foreach($group in ($data | group FileHeaderTag)) {
|
|
|
|
Write-Debug "Processing FileHeaderTag:$($group.Name) - $($group.Group.Count) rows"
|
|
|
|
$files = $group.Group | sort FileCreationDate
|
|
$fileList = $transactions | select -ExpandProperty FileSequenceNumber
|
|
|
|
$prevSequenceNumber = -2
|
|
|
|
$fileCount = 1
|
|
foreach($file in $files) {
|
|
Write-Progress -Activity 'Get-DeviceTransactions' -Status "Processing '$($file.FileSequenceNumber)' in group '$($group.Name)'" -PercentComplete (100 / $files.Count * $fileCount++) -ParentId 1 -Id 2
|
|
|
|
if($file.FileSequenceNumber -eq 0) {
|
|
Write-Debug "Rollover"
|
|
$prevSequenceNumber = -1
|
|
}
|
|
|
|
if(($prevSequenceNumber + 1) -ne $file.FileSequenceNumber) {
|
|
if($prevSequenceNumber -eq -2) { continue }
|
|
|
|
if($prevSequenceNumber -eq $file.FileSequenceNumber) {
|
|
Write-Debug "$prevSequenceNumber + 1: $($prevSequenceNumber + 1)"
|
|
Write-Debug "$($prevSequenceNumber + 1) -ne $($file.FileSequenceNumber): $($($prevSequenceNumber + 1) -ne $file.FileSequenceNumber)"
|
|
Write-Warning "Duplicate sequence: $prevSequenceNumber to $($file.FileSequenceNumber)"
|
|
}
|
|
else {
|
|
Write-Debug "$prevSequenceNumber + 1: $($prevSequenceNumber + 1)"
|
|
Write-Debug "$($prevSequenceNumber + 1) -ne $($file.FileSequenceNumber): $($($prevSequenceNumber + 1) -ne $file.FileSequenceNumber)"
|
|
Write-Warning "Sequence skip: $prevSequenceNumber to $($file.FileSequenceNumber)"
|
|
}
|
|
}
|
|
|
|
$prevSequenceNumber = $file.FileSequenceNumber
|
|
}
|
|
|
|
Write-Host "$deviceIdHex - $($group.Name) - Processed $($fileCount-1) files"
|
|
}
|
|
}
|
|
|
|
$sqlConnection.Close() |