Mase2k

IT Professional

Albert Widjaja

<div>
Interesting. That could explain some weird results we get from time to time. I modified the way you recommended and got the following. Any thoughts? <br />
<br />
WARNING: Memory usage of a cmdlet has exceeded a warning level. To avoid this situation, try one of the following: 1)<br />
Lower the rate at which CIM operations produce data (for example, by passing a low value to the ThrottleLimit<br />
parameter), 2) Increase the rate at which data is consumed by downstream cmdlets, or 3) Use the Invoke-Command cmdlet<br />
to run the whole pipeline on the server. The cmdlet that exceeded a warning level of memory usage was started by the<br />
following command line: Get-SmbOpenFile | Where-Object {($_.ShareRelativePath -like &quot;C:\Application\S2K*&quot;) -and<br />
($_.ShareRelativePath -notlike &quot;*IMAGES*&quot;)} | Sort-Object ClientUsername | Select-Object -ExpandProperty ClientUsername
</div>


<div>
I was able to implement your instructions successfully. I no longer required the -and for images since I was keying in on a folder specifically. Also I needed to specify Path instead of ShareRelativePath in order to see the whole path. This is working well for me now:<br />
<br />
Get-SmbOpenFile | Where-Object {($_.Path -like &quot;C:\Application\S2K*&quot;)} | Sort-Object ClientUsername | Select-Object -ExpandProperty ClientUsername
</div>


<div>
I really appreciate your assistance on this.
</div>


<div>
<div class="content wysiwyg-content">
Regarding the previous case (<a href="https://www.experts-exchange.com/questions/29109977/Powershell-assistance-needed-breaking-up-results-being-read-as-a-string-and-creating-attachment-of-results.html" rel="ugc">29109977</a> I am running into another issue. Originally this was completed on a system which only had one set of users in it but we are now looking to run it where individual users need to be further broken up. Attached are the Results.ps1 and SendEmail.ps1 scripts which are in use. This statement specifically is what results in the information we require: Where-Object -Property ShareRelativePath -Match &quot;S2K&quot;. However, we need to be able to specify an entire path of C:\Application\S2K1, S2K2, S2K3, etc. Right now it is giving me all of the D:\Application\S2K1, S2K2, etc and other drives. However, I only want to receive one drives information. Please let me know if any further clarification is needed.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/11_w45/1399766/Results.ps1" target="_blank" class="file-inline" title="Results.ps1 (209 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Results.ps1</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2018/11_w45/1399767/SendEmail.ps1" target="_blank" class="file-inline" title="SendEmail.ps1 (694 bytes)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SendEmail.ps1</a>
</div>
</div>


Results.ps1

SendEmail.ps1

Regarding the previous case (29109977 (https://www.experts-exchange.com/questions/29109977/Powershell-assistance-needed-breaking-up-results-being-read-as-a-string-and-creating-attachment-of-results.html) I am running into another issue. Originally this was completed on a system which only had one set of users in it but we are now looking to run it where individual users need to be further broken up. Attached are the Results.ps1 and SendEmail.ps1 scripts which are in use. This statement specifically is what results in the information we require: Where-Object -Property ShareRelativePath -Match "S2K". However, we need to be able to specify an entire path of C:\Application\S2K1, S2K2, S2K3, etc. Right now it is giving me all of the D:\Application\S2K1, S2K2, etc and other drives. However, I only want to receive one drives information. Please let me know if any further clarification is needed.

Further restrict powershell results by drive path

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.