→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
FrankW
Engaged Sweeper III
hi there,
i'm going nuts on this one 🙂

I'm trying to generate a report which contains the following informations:

- Name "PRT-A*" or "PRT-B*"
- IPAdress "192.168.5*" or "192.168.6*"
- Manufacturer
- Model
- Serialnumber
- Printed Pages

I'm not sure if i'm just to blind to find the infos in the different tables, but i'm sure that i need some help. All i actually get are empty reports 🙂

thx in advance!

-frank
1 ACCEPTED SOLUTION
FrankW
Engaged Sweeper III
i woke up: i replaced the "*" with "%" ... that did the trick 🙂

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
Note that the Lansweeper report builder uses standard SQL queries. The % wildcard is not unique to Lansweeper. If you're unfamiliar with SQL, we would recommend reviewing some tutorials first, which will make report building a lot easier. There are several good tutorials available online, e.g.: http://www.w3schools.com/sql/default.asp
FrankW
Engaged Sweeper III
i woke up: i replaced the "*" with "%" ... that did the trick 🙂