cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Glenn_Gagne
Engaged Sweeper III

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

3 REPLIES 3
Mercedes_O
Community Manager
Community Manager

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

Mister_Nobody
Honored Sweeper II
Mister_Nobody
Honored Sweeper II

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.

 

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now