<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic PSMConfigureApplocker script with settings for Management Studio takes more than 20 minutes to run in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/psmconfigureapplocker-script-with-settings-for-management-studio/m-p/1314419#M14970</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I'm using PSM version 14.2 and recently added connection component for SQL Management Studio (Windows Authentication). When adding the settings in PSMConfigureApplocker.xml file and running the script in PowerShell as administrator, the execution of PSMConfigureApplocker.ps1 script takes more than 20 minutes?&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;P&gt;These are the settings I added:&lt;/P&gt;&lt;P&gt;&amp;lt;!-- SQL Server Management Studio 2018 processes --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;!-- SQL Server Management Studio 2018 Profiler --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018-Profiler" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\PROFILER.EXE" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;!-- SQL Server Management Studio 2018 Tunning Advisor --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018-DTAShell" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\DTASHELL.exe" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-- ALlowed DLL:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;lt;Libraries Name="mssqlnatives" Type="Dll" Path="C:\Windows\assembly\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SHELLCOMPONENTS" Type="Dll" Path="%WINDIR%\SHELLCOMPONENTS\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SHELLEXPERIENCES" Type="Dll" Path="%WINDIR%\SHELLEXPERIENCES\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SQLServer" Type="Dll" Path="%PROGRAMFILES%\MICROSOFT SQL SERVER\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="MSShared" Type="Dll" Path="%PROGRAMFILES%\COMMON FILES\MICROSOFT SHARED\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SSMS2018-Debugger" Type="Dll" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\Packages\Debugger\*" Method="Path" /&amp;gt;&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 27 Aug 2024 23:21:41 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2024-08-27T23:21:41Z</dc:date>
    <item>
      <title>PSMConfigureApplocker script with settings for Management Studio takes more than 20 minutes to run</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/psmconfigureapplocker-script-with-settings-for-management-studio/m-p/1314419#M14970</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;I'm using PSM version 14.2 and recently added connection component for SQL Management Studio (Windows Authentication). When adding the settings in PSMConfigureApplocker.xml file and running the script in PowerShell as administrator, the execution of PSMConfigureApplocker.ps1 script takes more than 20 minutes?&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;P&gt;These are the settings I added:&lt;/P&gt;&lt;P&gt;&amp;lt;!-- SQL Server Management Studio 2018 processes --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;!-- SQL Server Management Studio 2018 Profiler --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018-Profiler" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\PROFILER.EXE" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;!-- SQL Server Management Studio 2018 Tunning Advisor --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Application Name="SSMS2018-DTAShell" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\DTASHELL.exe" Method="Publisher" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;-- ALlowed DLL:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;lt;Libraries Name="mssqlnatives" Type="Dll" Path="C:\Windows\assembly\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SHELLCOMPONENTS" Type="Dll" Path="%WINDIR%\SHELLCOMPONENTS\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SHELLEXPERIENCES" Type="Dll" Path="%WINDIR%\SHELLEXPERIENCES\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SQLServer" Type="Dll" Path="%PROGRAMFILES%\MICROSOFT SQL SERVER\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="MSShared" Type="Dll" Path="%PROGRAMFILES%\COMMON FILES\MICROSOFT SHARED\*" Method="Path" /&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;lt;Libraries Name="SSMS2018-Debugger" Type="Dll" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\Packages\Debugger\*" Method="Path" /&amp;gt;&amp;nbsp;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 27 Aug 2024 23:21:41 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/psmconfigureapplocker-script-with-settings-for-management-studio/m-p/1314419#M14970</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2024-08-27T23:21:41Z</dc:date>
    </item>
    <item>
      <title>Re: PSMConfigureApplocker script with settings for Management Studio takes more than 20 minutes to run</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/psmconfigureapplocker-script-with-settings-for-management-studio/m-p/1314420#M14971</link>
      <description>&lt;P&gt;Hi @Dercel Gonzalez​&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It could be due to a few reasons,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;The script might be taking a long time to scan and validate the paths you specified, especially if there are many files in the directories like C:\Windows\assembly\* or %PROGRAMFILES%\MICROSOFT SQL SERVER\*. If these directories contain a large number of DLLs, this can significantly slow down the script.&lt;/LI&gt;&lt;LI&gt;The inclusion of many paths and libraries in the PSMConfigureApplocker.xml file could introduce performance overhead, especially if the script needs to process a large number of files.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Please try to narrow down the paths to only those strictly necessary. For example, instead of allowing all DLLs in C:\Windows\assembly\*, specify only the required subdirectories or DLLs.&lt;/LI&gt;&lt;LI&gt;Add the paths incrementally to identify which specific paths cause the slowdown&lt;/LI&gt;&lt;LI&gt;Also monitor the PSM server’s performance while running the script to check for any bottlenecks.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope it helps !&lt;/P&gt;</description>
      <pubDate>Tue, 27 Aug 2024 23:32:35 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/psmconfigureapplocker-script-with-settings-for-management-studio/m-p/1314420#M14971</guid>
      <dc:creator>M.Vora780263</dc:creator>
      <dc:date>2024-08-27T23:32:35Z</dc:date>
    </item>
  </channel>
</rss>

