32 or 64 bit version of product: 64
Operating system: Windows 10
32 or 64 bit OS: 64
PowerShell Version: 5
The Copy HTML feature does not detect all carriage returns.
- <pre><span style="color: #8B0000;">$CWlist</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF; font-weight: bold;">import-csv</span><span style="color: #000000;"> </span><span style="color: #5A0032;">c:\Powershell\BOWS\CW_Users_without_laptops.csv</span><span style="color: #000000;">
- </span><span style="color: #8B0000;">$ACSlist</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF; font-weight: bold;">Import-Csv</span><span style="color: #000000;"> </span><span style="color: #5A0032;">c:\Powershell\BOWS\report-consolidated.csv</span><span style="color: #000000;">
- </span><span style="color: #8B0000;">$matches</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> @()
- </span><span style="color: #0000FF;">foreach</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;"> </span><span style="color: #0000FF;">in</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$ACSlist</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.Username </span><span style="color: #00008B;">-like</span><span style="color: #000000;"> </span><span style="color: #FF0000;">"*@*"</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">foreach</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;"> </span><span style="color: #0000FF;">in</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$CWlist</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">.</span><span style="color: #FF0000;">"Email"</span><span style="color: #000000;"> </span><span style="color: #00008B;">-notlike</span><span style="color: #000000;"> </span><span style="color: #FF0000;">""</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.UserName </span><span style="color: #00008B;">-like</span><span style="color: #000000;"> </span><span style="color: #FF0000;">"</span><span style="color: #8B0000;">$</span><span style="color: #000000;">(</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">.</span><span style="color: #FF0000;">'Email'</span><span style="color: #000000;">)</span><span style="color: #FF0000;">"</span><span style="color: #000000;">) {
- </span><span style="color: #00008B;">[</span><span style="color: #0F5186;">Management.Automation.PSObject</span><span style="color: #00008B;">]</span><span style="color: #8B0000;">$object</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">
- </span><span style="color: #0000FF; font-weight: bold;">Add-Member</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-InputObject</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$object</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-NotePropertyName</span><span style="color: #000000;"> </span><span style="color: #5A0032;">NASIPAddress</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-NotePropertyValue</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.</span><span style="color: #FF0000;">"NAS-IP-Address"</span><span style="color: #000000;">
- </span><span style="color: #8B0000;">$matches</span><span style="color: #000000;"> </span><span style="color: #00008B;">+=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$object</span><span style="color: #000000;">
- }
- }
- }
- }
- </span><span style="color: #0000FF;">Else</span><span style="color: #000000;"> {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.Username </span><span style="color: #00008B;">-like</span><span style="color: #000000;"> </span><span style="color: #FF0000;">"*\*"</span><span style="color: #000000;">) {
- </span><span style="color: #8B0000;">$ACSsplit</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.Username).split(</span><span style="color: #FF0000;">"\\"</span><span style="color: #000000;">)
- </span><span style="color: #8B0000;">$ACSuid</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$ACSsplit</span><span style="color: #00008B;">[</span><span style="color: #8B0000;">$ACSsplit</span><span style="color: #000000;">.count </span><span style="color: #00008B;">-</span><span style="color: #000000;"> </span><span style="color: #4B0082;">1</span><span style="color: #00008B;">]</span><span style="color: #000000;">
- }
- </span><span style="color: #0000FF;">Else</span><span style="color: #000000;"> {
- </span><span style="color: #8B0000;">$ACSuid</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.Username
- }
- </span><span style="color: #0000FF;">foreach</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;"> </span><span style="color: #0000FF;">in</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$CWlist</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">.</span><span style="color: #FF0000;">"User ID"</span><span style="color: #000000;"> </span><span style="color: #00008B;">-notlike</span><span style="color: #000000;"> </span><span style="color: #FF0000;">""</span><span style="color: #000000;">) {
- </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> (</span><span style="color: #8B0000;">$ACSuid</span><span style="color: #000000;"> </span><span style="color: #00008B;">-like</span><span style="color: #000000;"> </span><span style="color: #FF0000;">"</span><span style="color: #8B0000;">$</span><span style="color: #000000;">(</span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">.</span><span style="color: #FF0000;">'User ID'</span><span style="color: #000000;">)</span><span style="color: #FF0000;">"</span><span style="color: #000000;">) {
- </span><span style="color: #00008B;">[</span><span style="color: #0F5186;">Management.Automation.PSObject</span><span style="color: #00008B;">]</span><span style="color: #8B0000;">$object</span><span style="color: #000000;"> </span><span style="color: #00008B;">=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$CW</span><span style="color: #000000;">
- </span><span style="color: #0000FF; font-weight: bold;">Add-Member</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-InputObject</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$object</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-NotePropertyName</span><span style="color: #000000;"> </span><span style="color: #5A0032;">NASIPAddress</span><span style="color: #000000;"> </span><span style="color: #3399FF;">-NotePropertyValue</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$ACS</span><span style="color: #000000;">.</span><span style="color: #FF0000;">"NAS-IP-Address"</span><span style="color: #000000;">
- </span><span style="color: #8B0000;">$matches</span><span style="color: #000000;"> </span><span style="color: #00008B;">+=</span><span style="color: #000000;"> </span><span style="color: #8B0000;">$object</span><span style="color: #000000;">
- }
- }
- }
- }
- }
- </span></pre>