Wildcards
When the setting "EnableWildcardsInSearch" is activated: SQL Wildcards can be used to search for computers. A wildcard character is used to substitute one or more characters.
Example
This will help you to find the computers you are looking for.
e.g. a search for "B-IT-Win[7-8]-VM%" will find computer that contain Win7 or Win8 in its name.
e.g. a search for "B-IT-Win[7-8]-VM%" will find computer that contain Win7 or Win8 in its name.
List of Symbols
Symbol | Description | Example |
|---|---|---|
% | Represents zero or more characters | M-IT-WIN%-VM001 |
_ | Represents a single character | _-IT-Win10-VM001 |
[ ] | Represents any character within the brackets | [MBF]-IT-Win10-VM001 |
^ | Represents any character not in the brackets | [^M]-IT-Win10-VM001 |
- | Represents a range of characters | B-IT-Win[7-8]-VM001 |
Document information
Last Modified Date
08.05.2023
Verified versions
five(9)s Console version 4.2
five(9)s Console version 4.1 or below
Disclaimer
five(9)s Console version 4.1 or below
Disclaimer
Even though every care has been taken by five(9)s GmbH to ensure that the information contained in this publication is correct and complete, it is possible that this is not the case. five(9)s GmbH provides the publication "as is", without any warranty for its soundness, suitability for a different purpose or otherwise. five(9)s GmbH is not liable for any damage which has occurred or may occur as a result of or in any respect related to the use of this publication. five(9)s GmbH may change or terminate this publication at any time without further notice and shall not be responsible for any consequence(s) arising there from. Subject to this disclaimer, five(9)s GmbH is not responsible for any contributions by third parties to this publication.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article