data3 [VMWare] Restoring Datastorage from Virtual Machine [Scenario] A user found that a file from DFS(Distributed File System) server has been lost. A IT ticket raised but help desk could not recover the file from "Previous version" because shadow copy has been disabled. [Objectives] Restore the file from VMWare backup [Remediation] - Check DFS server of the drive where the lost file located - Go to "vSphere Client" then find the DFS server - At Disk .. 2024. 3. 25. [PowerShell] PSCustomObject for Saving Log [Scenario] The business wants a scipt to run periodically as a temporal solution and needs to trace script's activities via log. [Objectives] Create PSCustomObject to save script log as an Excel file [Steps] As starter, lets create PSCustomObject which can save datetime, device, action $pso = [PSCustomObject]@{ "DateTime" =(get-date -format 'yyyy-MM-dd') "DeviceName" ='KRYAN-L-FM992H2' "State"='.. 2023. 7. 14. [VBA] Extracting Data from SQL with a Button in Excel [Requirements] Business transport team asks a Excel sheet to fetch all purchase order data in ERP system - Create Excel file with VBA embedded which fetchs data - Create SQL procedure calling ERP data from SQL database [OS] Windows 10 [Development Language] VBA, SQL [IDE] SSMS(SQL Server Management Studio), Microsoft Visual Basic For Applications [Code] VBA script: GetData_from_SQLServerDatabase.. 2023. 6. 27. 이전 1 다음 반응형
