‎04-19-2023 10:34 PM - last edited on ‎04-02-2024 11:22 AM by Mercedes_O
Hi,
It happen very often that I need to search many assets, but with the main asset (All assets) view I'm unable to filter properly what I need. Then, I have no choice to create a report where I can make a search with conditions "and/or/like/etc."
I give you some examples:
It is possible to filter asset type to get a result with all asset but not "monitor" type (NOT) ?
It is possible to filter asset type to get a result with Windows and Linux only (AND) ?
It is possible to filter asset where the IP address start with 10. and end with .1 (10.*.*.1) (regex) ?
It is possible to filter asset where the model contain the text "laser" instead starting with HP LaserJet, Brother laserXXX, etc. (like) ?
Thank you !!!
‎04-24-2023 08:49 PM
@Glenn_Gagne did you try the suggestion below from @Mister_Nobody ?
‎04-21-2023 08:02 AM - edited ‎04-21-2023 08:11 AM
‎04-21-2023 07:56 AM - edited ‎04-25-2023 05:57 AM
If you don't want to create SQL reports but want to use search mask then you have only few options (as I know) in on-premise engine.
In Lansweeper you can create search masks in the search bar:
First option:
_ - character by character skip
Example - 2 characters skipped by specifying two underscores:
https://ls/quicksearch.aspx?q=comp__345
The second variant:
Omission of an arbitrary number of characters - % is used, but you have to type %25 (if two or more digits in a row)
https://ls/quicksearch.aspx?q=comp%25134
more parameters here
% | Any string of zero or more characters. | WHERE title LIKE '%computer%' finds all book titles with the word computer anywhere in the book title. |
_ (underscore) | Any single character. | WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean , Sean , and so on). |
[ ] | Any single character within the specified range [a-f] or set [abcdef] . | WHERE au_lname LIKE '[C-P]arsen' finds author last names ending with arsen and starting with any single character between C and P , for example Carsen , Larsen , Karsen , and so on. In range searches, the characters included in the range may vary depending on the sorting rules of the collation. |
[^] | Any single character not within the specified range [^a-f] or set [^abcdef] . | WHERE au_lname LIKE 'de[^l]%' finds all author last names starting with de and where the following letter isn't l . |
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now