Catatan

Tunjukkan catatan dari Ogos, 2026

Setup Rustdesk server

Imej
  On Windows 1) Download execute file from official Rustdesk github  Github:  https://github.com/rustdesk/rustdesk-server-pro/releases/tag/1.8.5 Execute file:  https://github.com/rustdesk/rustdesk-server-pro/releases/download/1.8.5/rustdesk-server-windows-x86_64.zip 2) Install Rustdesk Server. Simpan dalam directory C:\Program Files\RustDeskServer 3) Run Powershell in Administrator. Run command ni > cd "C:\Program Files\RustDeskServer\bin" >  .\hbbs.exe 4) 

Excel for Signalling

Imej
1) First, Separate log Assume this text is in A1 : 07/07/2026 00:00:09 - H,07072026,0000, Datetime column In B1 : =LEFT(A1,FIND(" - ",A1)-1) Result: 07/07/2026 00:00:09 Message column In C1 : =MID(A1,FIND(" - ",A1)+3,LEN(A1)) Result: H,07072026,0000, 2) VBA auto delete Press Alt + F11 → Insert → Module → paste this: Sub DeleteUnwantedLogRows_ByMessageColumn_Fixed() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim msgText As String Set ws = ActiveSheet lastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row For i = lastRow To 1 Step -1 ' Skip kalau cell ada error value If Not IsError(ws.Cells(i, "B").Value) Then msgText = CStr(ws.Cells(i, "B").Value) If InStr(1, msgText, "All messages processed", vbTextCompare) > 0 _ Or InStr(1, msgText, "Transaction", vbTextCompare) > 0 _...