Skip to main content

Posts

Showing posts from May, 2017

Powershell for pulling information from existing CSV

I was working on script which was suppose to pull information from existing .CSV file, another problem is you dont know when new file get generate and you have to fetch data from it.  hence what i did is wrote a code which pulls the information from latest file which got created recently under that particular folder. $file = get-childitem "Path" | select -last 1 Instead of  path put the share name or unc path without "". Write-host "File Selected - $($file.fullname)" This will give actually information about which file you are targeting to pull information. Script.:- $file = get-childitem "Path" | select -last 1 $ServerInfo = import-csv $file.fullname  $ServerInfo |? OU -eq 'General' | Export-Csv C:\TEMP\\Eapps_$currentdate.csv Write-host "File Selected - $($file.fullname)"

OSD or Onscreen menu is locked.

OSD or Onscreen menu is locked. I am having HP 20 Inch monitors on my Desk and was not able to change brightness and Sleep Timer etc for my monitor and was not able to get into the menu due to On Screen menu locked error. I know it's irritating issue. fix what i found for this is "Just hold menu button for 30 Sec and it will be solved. :)