→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
wic_admin
Engaged Sweeper
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
2 REPLIES 2
Hemoco
Lansweeper Alumni
An example to search everything with explorer in:

WHERE (softwareName LIKE '%Explorer%')
Cobra7
Champion Sweeper
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.