Skip to main content

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)"




Comments

Post a Comment

Popular posts from this blog

"kerberos: the specified credentials were rejected by the server", "unreachable": true" Ansible

Hello Friends, I was getting following Error while deploying my Ansible script, Basically my credential were getting rejected by server. SSH password: PLAY [Playbook_Name] ***************************************************************02:00:30 TASK [Gathering Facts] *********************************************************02:00:30 fatal: [Server_Inventory_Name]: UNREACHABLE! => {"changed": false, "msg": "kerberos: the specified credentials were rejected by the server", "unreachable": true} PLAY RECAP *********************************************************************02:00:30 Server_Inventory_Name    : ok=0    changed=0    unreachable=1   failed=0  It was resolved using one additional parameter in Inventory  i.e  "ansible_winrm_server_cert_vaildation:ignore"
1 comment
Read more

NBSUTIL commands

Frustrated with syntax finding hence decided to post all NBSTLUTIL related commands so people will not face same problem. Common SLP Related Commands Show EMM Image list of Images that were backed up to an SLP STU [ -I / -U ] nbstlutil list nbstlutil list –lifecycle <name> nbstlutil list –backupid <id_value> nbstlutil list -image_state <value> nbstlutil list -copy_state <value> nbstlutil list -frag_state <value> nbstlutil list –mediaid <media_id>_–state 3 Activate /Inactivate SLP operations nbstlutil inactive –lifecycle <lifecycle name> nbstlutil inactive –backupid <backupid> nbstlutil active –lifecycle <lifecycle name> nbstlutil active –backupid <backupid> Cancel pending operations on selected image nbstlutil cancel -backupid <backupid> nbstlutil cancel -lifecycle <lifecycle> Show status on Incomplete copies of Lifecycle Managed images nbstlutil stlilist –lifecycle <lifecycle name> nbstlutil stlil...
Post a Comment
Read more

How to disable USB Storage ?

Question came. #How to disable USB Drive but USB headphones/Keyboard/Mouse and Data cards should work? Simple:  When administrator says how he will block things using GPO what we do is we edit Group Policy Management template. #Group Policy Management Editor Following option need to be configure. What exactly happens? As we know Windows is all about registry and for each and everything we had one Reg file same thing applies to USB.  For example USB Printer, USB hub, USB headphones for each component we had different registry keys. Now I just want to disable USB storage hence will concentrate on following registry path. #[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\USBSTOR] and mainly START (Dword) By default it is 3 if you modify registry to 4. USB Mass storage will be block. (Cell Phones, Jump drives, Disk and Pen drives will not detect in OS.
Post a Comment
Read more