Symantec Version Filter

[bdirkx]

Dear forum members.

I have build a new report for symantec antivirus. But i will build a filter for this report.

My report lookes like this.

Select Top 100 Percent tblComputers.Computername, tblSoftware.SoftwarePublisher, tblSoftware.softwareName, tblSoftware.softwareVersion, tblADusers.Firstname, tblADusers.Lastname From tblComputers Inner Join tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join tblADusers On tblComputers.Username = tblADusers.Username Where tblSoftware.SoftwarePublisher = 'Symantec Corporation' Order By tblComputers.Computername

Now i want filter the live update status out of the report.

Because we have multiple versions of symantec antivirus and whe must upgrade them to one version. So i only want to see the versions and not the live update versions.

Please can somebody help me.

Greetings Bart Dirkx

[bdirkx]

Thanks for your help.

It works fine.

[Hemoco]

Select Top 1000000 tblComputers.Computername, tblSoftware.SoftwarePublisher, tblSoftware.softwareName, tblSoftware.softwareVersion, tblADusers.Firstname, tblADusers.Lastname From tblComputers Inner Join tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join tblADusers On tblComputers.Username = tblADusers.Username Where tblSoftware.SoftwarePublisher = 'Symantec Corporation' and tblsoftware.softwarename not like 'liveupdate%' Order By tblComputers.Computername

[bdirkx]

This is the output of the report.


Computername SoftwarePublisher softwareName softwareVersion Firstname Lastname
IBLAMEMS Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Ivan van der Vat
IBLAMEMS Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Ivan van der Vat
VW08524 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Jordy de Jong
VW08524 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Jordy de Jong
VW08245 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Albert-Rienk Douwsma
VW08245 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Albert-Rienk Douwsma
VW11305 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bart Dirkx
VW11305 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Bart Dirkx
VW11367 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bart Dirkx
VW11367 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Bart Dirkx
KWS-EHV Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Robert Rietveld
KWS-EHV Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Robert Rietveld
KWS-DC Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Robert Rietveld
KWS-DC Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Robert Rietveld
KWS-ZWYN Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Robert Rietveld
KWS-ZWYN Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Robert Rietveld
KWS-HARDE Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Robert Rietveld
KWS-HARDE Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Robert Rietveld
VW06942 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Anne Kazen
VW06942 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Anne Kazen
HC202777 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Berend Jan Blok
HC202777 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Berend Jan Blok
VW04182 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Gerben Boer
VW04182 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Gerben Boer
VW06179 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Stephanie Kole
VW06179 Symantec Corporation Symantec Endpoint Protection 11.0.4014.26 Stephanie Kole
HC200758 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Joke Scholte
HC200758 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Joke Scholte
HC204689 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Ron, den Dulk
HC204689 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Ron, den Dulk
HC202736 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Henk Vessies
HC202736 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Henk Vessies
HC200643 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Sjoerd van Doren
HC200643 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Sjoerd van Doren
VW08905 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Patrick Kooker
VW08905 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Patrick Kooker
VW13538 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Cees Jan Klos
HC201902 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Paul Vessies
HC201902 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Paul Vessies
VW10990 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Marten, van der Laan
VW10990 Symantec Corporation Symantec Endpoint Protection 11.0.4202.75 Marten, van der Laan
VW13120 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 P. Sardjoe Mishre
VW13120 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 P. Sardjoe Mishre
VW08540 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Sylvia Hakkaart
VW08540 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Sylvia Hakkaart
KWS-CTX10 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Arjan van der Heijden
KWS-CTX10 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Arjan van der Heijden
VW04549 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Cees Patijn
VW04549 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Cees Patijn
AVANWITSENBURG1 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Kees van Dalen
AVANWITSENBURG1 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Kees van Dalen
KWS-CTX01 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Marco Bevaart
KWS-CTX01 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Marco Bevaart
HC202787 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Corstiaan de Groot
HC202787 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Corstiaan de Groot
KWS-CTX07 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Daan Berkouwer
KWS-CTX07 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Daan Berkouwer
LT-07575 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Joost Hornes
LT-07575 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Joost Hornes
VW07039 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Mick Molle
VW07039 Symantec Corporation Symantec Endpoint Protection 11.0.4202.75 Mick Molle
HC202773 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Daan Berkouwer
HC202773 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Daan Berkouwer
KWS-CTX02 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Peter Lap
KWS-CTX02 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Peter Lap
VW08975 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Arjan van Es
VW08975 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Arjan van Es
VW08903 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Frank Peters
VW08903 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Frank Peters
VW13978 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Eelke de Vries
VW13978 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Eelke de Vries
VW12761 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Radjinkoemar Gowricharn
VW12761 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Radjinkoemar Gowricharn
VW13192 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Piet Neeleman
VW13192 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Piet Neeleman
KWS-CTX09 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Jos Stuifzand
KWS-CTX09 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Jos Stuifzand
KWS-CTX05 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bob Rijks
KWS-CTX05 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Bob Rijks
VW13540 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Willem Jan van Dorp
VW13540 Symantec Corporation Symantec Endpoint Protection 11.0.4014.26 Willem Jan van Dorp
VW07983 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Martijn van Eendenburg
VW07983 Symantec Corporation Symantec Endpoint Protection 11.0.4202.75 Martijn van Eendenburg
VW08298 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bart Dirkx
VW08298 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Bart Dirkx
VW08607 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bob Rijks
VW08607 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Bob Rijks
HC204988 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Jack, de Jong
HC204988 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Jack, de Jong
KWS-CTX06 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Pim Koning
KWS-CTX06 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Pim Koning
KWS-CTX04 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Peter Poldervaart
KWS-CTX04 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Peter Poldervaart
VW13784 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Pim Koning
VW13784 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Pim Koning
KWS-CTX08 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Arjan van Es
KWS-CTX08 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Arjan van Es
VW05858 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Martijn Verheuvel
VW05858 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Martijn Verheuvel
ANIJHOFF1 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Amer Radjkoemar
ANIJHOFF1 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Amer Radjkoemar
VW07192 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Wim Sol
VW07192 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Wim Sol
VW06519 Symantec Corporation LiveUpdate 2.0 (Symantec Corporation) 2.39 Ger Boer
VW06519 Symantec Corporation Symantec AntiVirus 9.0.210 Ger Boer
VW08127 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Jordy de Jong
VW08127 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Jordy de Jong
EVANDERLINDEN1 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Ellen, van der Linden
EVANDERLINDEN1 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Ellen, van der Linden
vw10780 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Leon Zwiers
vw10780 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Leon Zwiers
VW12768 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Marjan, van der Meer-Boer
VW12768 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Marjan, van der Meer-Boer
LT-08244 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Jan de Lange
LT-08244 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Jan de Lange
KWS-CTX03 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Ron, den Dulk
KWS-CTX03 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Ron, den Dulk
VW10984 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Robert Rietveld
VW10984 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Robert Rietveld
VW13194 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Ron, van den Hondel
VW13194 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Ron, van den Hondel
KWS-IAS Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3
KWS-IAS Symantec Corporation Symantec Endpoint Protection 11.0.5002.333
VW06904 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Sjef Roijen
VW06904 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Sjef Roijen
HC102808 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Cees Sulkers
HC102808 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Cees Sulkers
LABDORD-XP Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Labdord
LABDORD-XP Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Labdord
VW06850 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Rienus, de Vries
VW06850 Symantec Corporation Symantec Endpoint Protection 11.0.4014.26 Rienus, de Vries
KWS-HISEC-TS Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Receptie
KWS-HISEC-TS Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Receptie
VW05815 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Gerard Cuppens
VW05815 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Gerard Cuppens
KWS-TS06 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Bregje Onland
KWS-TS06 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Bregje Onland
HC202653 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Willem Hoogeveen
HC202653 Symantec Corporation Symantec Endpoint Protection 11.0.4000.2295 Willem Hoogeveen
VW13725 Symantec Corporation LiveUpdate 3.3 (Symantec Corporation) 3.3 Martin Geene
VW13725 Symantec Corporation Symantec Endpoint Protection 11.0.5002.333 Martin Geene

[Hemoco]

Could you post the output of the report (part of it)