Jump to content

Search the Community

Showing results for tags 'wildcards'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • MSPGeek
    • Announcements
    • The Geek Cast
  • ConnectWise Automate / Labtech
    • ConnectWise Automate / LabTech
    • ConnectWise Automate / LabTech - Development

Categories

  • ConnectWise Automate
    • Scripts
    • Plugins
    • SQL Snippets
    • Role Definitions
    • Automate PowerShell Code
    • Reports
    • Internal Monitors
    • Remote Monitors
  • ConnectWise Manage
    • API Interacting Code

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Agent Count


INTERESTS


OCCUPATION


ICQ


WEBSITE


WLM


YAHOO


AOL


FACEBOOK


GOOGLEPLUS


SKYPE


TWITTER


YOUTUBE

Found 1 result

  1. The "SW - BlackListed Install" and "SW - Unclassified Apps" monitors do not support wildcard matching, so whitelisted or blacklisted application entries with wildcards are not used in these monitor results. This causes false positives, extra ticket noise, etc. These monitors can be adjusted to support wildcards. For the "SW - Unclassified Apps" monitor, the default "Result" field value is: (Select Name from Applicationblacklist union select name from applicationwhitelist) To enable Wildcard matching, replace the Result value with the following: (SELECT DISTINCT `Name` FROM (SELECT Software.Name FROM Software JOIN (SELECT REPLACE(`Name`,'*','%') AS `Name` FROM ApplicationBlacklist WHERE INSTR(REPLACE(`Name`,'*','%'),'%')>0 UNION SELECT REPLACE(`Name`,'*','%') FROM ApplicationWhitelist WHERE INSTR(REPLACE(`Name`,'*','%'),'%')>0) AS AppMatches ON Software.`Name` LIKE AppMatches.`Name` UNION SELECT Software.Name FROM Software JOIN (SELECT `Name` FROM ApplicationBlacklist WHERE INSTR(`Name`,'%')=0 UNION SELECT `Name` FROM ApplicationWhitelist WHERE INSTR(`Name`,'%')=0) AS AppList ON Software.Name = AppList.Name) AS Applications) For the "SW - BlackListed Install" monitor, the default "Result" field value is: (Select Name from Applicationblacklist) To enable Wildcard matching, replace the Result value with the following: (SELECT DISTINCT `Name` FROM (SELECT Software.Name FROM Software JOIN (SELECT REPLACE(`Name`,'*','%') AS `Name` FROM ApplicationBlacklist WHERE INSTR(REPLACE(`Name`,'*','%'),'%')>0) AS AppMatches ON Software.`Name` LIKE AppMatches.`Name` UNION SELECT Software.Name FROM Software JOIN (SELECT `Name` FROM ApplicationBlacklist WHERE INSTR(`Name`,'%')=0) AS AppList ON Software.Name = AppList.Name) AS Applications) I hope this helps! It has been reported that some browsers are not copying the text correctly. Chrome is believed to work, Firefox may be suspect. If you have any errors try copying the text using a different browser.
×
×
  • Create New...