Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SQL Inventory manager discovers the same application multiple times which makes the applications table grow exponentially large and causes performance issues. To overcome this issue you can add a regular expression to the SQLInventoryManagerCollectorService.exe.config page


Code Block
languagexml
themeEclipse
<setting name="ApplicationFilterPatterns" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>(?<=[(TSS)({)
{0,1}[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}(}){0,1}
])(.+)</string>
</ArrayOfString>
</value>
</setting>

...