Report about printers, model, printed pages, ..

[FrankW]

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

[Hemoco]

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 · Accepted solution]

i woke up: i replaced the "*" with "%" ... that did the trick 🙂