how to select software with wildcards

[wic_admin]

Hello,

first of all: great Tool!

My first question:
how could I select alle Software of one type names whithout knowing korrekt Version extens?

e.g.:
WHERE (softwareName = 'Windows Internet Explorer 7')
is the full known Software-String.

And how could I say to get ALL Windows Internet Explorer versions?
(because in the report I had to selcet every entry of IEx-Version to get to know the clients -
I want to have it in one view!)

This one does not work:
WHERE (softwareName = 'Windows Internet Explorer %')

all hints are welcome!

thanks
wic admin

[Hemoco]

An example to search everything with explorer in:

WHERE (softwareName LIKE '%Explorer%')

[Cobra7]

To do wildcards it would be

WHERE (softwareName LIKE '%Windows Internet Explorer 7%')

Use the % like you would a * and use LIKE instead of =.

As far as IE, the problem is that it is built into Windows so it does not always show up in the Add/Remove programs. To get around this you need to create a custom scan file and make reports based on that.