Suggestion - Search in all assets with not/and/or (conditions) filters capabilities

[Glenn_Gagne]

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 !!!

[Mercedes_O]

@Glenn_Gagne  did you try the suggestion below from @Mister_Nobody ? 

[Mister_Nobody]

Cloud version:

https://community.lansweeper.com/t5/cloud/introduction-to-the-cloud-report-builder/ta-p/64549

[Mister_Nobody]

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

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/like-transact-sql?view=sql-server-ver1...

%	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.