Difference between revisions of "General Powershell Notes"
Jump to navigation
Jump to search
Michael.mast (talk | contribs) |
Michael.mast (talk | contribs) |
||
| Line 11: | Line 11: | ||
Install-Module ImportExcel | Install-Module ImportExcel | ||
| − | Import-Excel '.\test.xlsx' -StartRow 3 | + | Import-Excel '.\test.xlsx' -StartRow 3 -EndRow 5 -StartColumne 2 -EndColumne 4 |
</pre> | </pre> | ||
Revision as of 13:58, 10 August 2018
Contents
Powershell Version
$PSVersionTable
Import Excel Spreadsheets
[3]This will save the hassle of converting to CSV all the time.
Install-Module ImportExcel Import-Excel '.\test.xlsx' -StartRow 3 -EndRow 5 -StartColumne 2 -EndColumne 4
NTFS Permissions
Get-Command –Module NTFSSecurity Get-NTFSAccess -path .\Contacts add-ntfsaccess -path .\contacts -account first.last -accessrights read
Passing Passwords to PSSession
[6] Convert to secure string then call from file. This following pulls from stdin as a secure string (converts what you type), then converts that to something (I'm still new to Microsoft's ways of doing things), then stores as a file.
read-host -assecurestring | convertfrom-securestring | out-file C:\securestring.txt
- ↑ https://msdn.microsoft.com/en-us/powershell/reference/5.1/microsoft.powershell.core/enable-psremoting
- ↑ https://stackoverflow.com/questions/1825585/determine-installed-powershell-version
- ↑ https://blogs.technet.microsoft.com/heyscriptingguy/2015/11/25/introducing-the-powershell-excel-module-2/
- ↑ https://gallery.technet.microsoft.com/scriptcenter/1abd77a5-9c0b-4a2b-acef-90dbb2b84e85
- ↑ https://blogs.technet.microsoft.com/fieldcoding/2014/12/05/ntfssecurity-tutorial-1-getting-adding-and-removing-permissions/
- ↑ http://web.archive.org/web/20160822030847/http://geekswithblogs.net/Lance/archive/2007/02/16/106518.aspx
