Jetzt Ausprobieren

Log4j Vulnerable Software Audit

Security Software Vulnerability

Find Potential Log4j Vulnerable Software

The Apache Software Foundation disclosed and fixed a critical, actively exploited zero-day known as Log4j. This vulnerability affects the widely-used Apache Log4j logging library that is java based. Tracked as CVE-2021-44228, this vulnerability has a perfect 10 on the CVSS rating. Since the library is widely used, this vulnerability impacts software across many publishers and manufacturers. The report below is based on a software GitHub list created by the Dutch national cyber security center. The report lists all software in your environment for which the publisher matches with one of the publishers listed by the Dutch cyber security center that had at one point vulnerable software. The software found can be cross-checked with the Github software list to view the most recent Log4j vulnerability status. Please note this isn’t a complete list of possible affected software and it is highly advised to read more on how to minimize your risk in our Log4j blog post. Last Update: 2022-01-19 log4j software report

Log4j Vulnerable Software Query

SELECT
Top 1000000 tblSoftwareUni.softwareName AS Software,
tblSoftware.softwareVersion AS Version,
tblSoftwareUni.SoftwarePublisher AS Publisher,
tsysAssetTypes.AssetTypename AS [Asset Type],
Count(tblSoftware.AssetID) AS Total
FROM
tblSoftware
INNER JOIN tblAssets ON tblSoftware.AssetID = tblAssets.AssetID
INNER JOIN tblSoftwareUni ON tblSoftware.softID = tblSoftwareUni.SoftID
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
(
SoftwarePublisher like '%2n%' or
SoftwarePublisher like '%3M Health Information Systems%' or
SoftwarePublisher like '%Abbott%' or
SoftwarePublisher like '%Accellence%' or
SoftwarePublisher like '%Acquia%' or
SoftwarePublisher like '%Acronis%' or
SoftwarePublisher like '%ActiveState%' or
SoftwarePublisher like '%Adaptec%' or
SoftwarePublisher like '%Addigy%' or
SoftwarePublisher like '%Adeptia%' or
SoftwarePublisher like '%Adobe%' or
SoftwarePublisher like '%Adobe ColdFusion%' or
SoftwarePublisher like 'ADP' or
SoftwarePublisher like '%AFAS Software%' or
SoftwarePublisher like '%Agilysys%' or
SoftwarePublisher like '%Alcatel%' or
SoftwarePublisher like '%Alexion%' or
SoftwarePublisher like '%AlienVault%' or
SoftwarePublisher like '%Alphatron%' or
SoftwarePublisher like '%Alphatron Medical%' or
SoftwarePublisher like '%Apache%' or
SoftwarePublisher like '%Apollo%' or
SoftwarePublisher like '%Appdynamics%' or
SoftwarePublisher like '%Appeon%' or
SoftwarePublisher like '%AppGate%' or
SoftwarePublisher like '%Application Performance Ltd%' or
SoftwarePublisher like '%APPSHEET%' or
SoftwarePublisher like '%Aqua Security%' or
SoftwarePublisher like '%Arca Noae%' or
SoftwarePublisher like '%ArcticWolf%' or
SoftwarePublisher like '%Ariba%' or
SoftwarePublisher like '%Arista%' or
SoftwarePublisher like '%Arista Networks%' or
SoftwarePublisher like '%Aruba Networks%' or
SoftwarePublisher like '%Ataccama%' or
SoftwarePublisher like '%Atera%' or
SoftwarePublisher like '%Atlassian%' or
SoftwarePublisher like '%Attivo networks%' or
SoftwarePublisher like '%AudioCodes%' or
SoftwarePublisher like '%Autodesk%' or
SoftwarePublisher like '%Automox%' or
SoftwarePublisher like '%Autopsy%' or
SoftwarePublisher like '%Auvik%' or
SoftwarePublisher like '%Avantra SYSLINK%' or
SoftwarePublisher like '%Avaya%' or
SoftwarePublisher like '%AVEPOINT%' or
SoftwarePublisher like '%AvTech RoomAlert%' or
SoftwarePublisher like '%AWS New%' or
SoftwarePublisher like '%AXON' or
SoftwarePublisher like '%AXS Guard%' or
SoftwarePublisher like '%Axways Applications%' or
SoftwarePublisher like '%BackBox%' or
SoftwarePublisher like '%Balbix%' or
SoftwarePublisher like '%Baramundi Products%' or
SoftwarePublisher like '%Barracuda%' or
SoftwarePublisher like '%Baxter%' or
SoftwarePublisher like '%Beckman Coulter%' or
SoftwarePublisher like '%Bender%' or
SoftwarePublisher like '%Best Practical Request Tracker%' or
SoftwarePublisher like '%BeyondTrust Bomgar%' or
SoftwarePublisher like '%BioMerieux%' or
SoftwarePublisher like '%BisectHosting%' or
SoftwarePublisher like '%BitNami By VMware%' or
SoftwarePublisher like '%BitRise%' or
SoftwarePublisher like '%Black Kite%' or
SoftwarePublisher like '%Blancco%' or
SoftwarePublisher like '%BleftSign%' or
SoftwarePublisher like '%Blumira%' or
SoftwarePublisher like 'BMC' or
SoftwarePublisher like '%Bosch Rexroth%' or
SoftwarePublisher like '%Bosch Security Systems%' or
SoftwarePublisher like 'Box' or
SoftwarePublisher like '%Brainworks%' or
SoftwarePublisher like '%Broadcom%' or
SoftwarePublisher like '%C4b XPHONE%' or
SoftwarePublisher like '%Camunda%' or
SoftwarePublisher like '%Canon%' or
SoftwarePublisher like '%CapStorm%' or
SoftwarePublisher like '%Carbon Black%' or
SoftwarePublisher like '%CarbonBlack%' or
SoftwarePublisher like '%CAS genesisWorld%' or
SoftwarePublisher like '%Cato Networks%' or
SoftwarePublisher like '%Cepheid%' or
SoftwarePublisher like '%Cerberus FTP%' or
SoftwarePublisher like '%CheckMK%' or
SoftwarePublisher like '%Ciphermail%' or
SoftwarePublisher like 'CIS' or
SoftwarePublisher like '%Cisco%' or
SoftwarePublisher like '%Citrix%' or
SoftwarePublisher like '%Claris%' or
SoftwarePublisher like '%Cloudera%' or
SoftwarePublisher like '%CloudFlare%' or
SoftwarePublisher like '%Cloudian HyperStore%' or
SoftwarePublisher like '%Cloudron%' or
SoftwarePublisher like '%Clover%' or
SoftwarePublisher like '%CodeBeamer%' or
SoftwarePublisher like '%Cohesity%' or
SoftwarePublisher like '%ConcreteCMS.com%' or
SoftwarePublisher like '%Confluent%' or
SoftwarePublisher like '%Connectwise%' or
SoftwarePublisher like '%ContrastSecurity%' or
SoftwarePublisher like '%cPanel%' or
SoftwarePublisher like '%Cradlepoint%' or
SoftwarePublisher like '%CrushFTP%' or
SoftwarePublisher like '%CyberRes%' or
SoftwarePublisher like '%DarkTrace%' or
SoftwarePublisher like '%Dassault Systu00e8mes%' or
SoftwarePublisher like '%Databricks%' or
SoftwarePublisher like '%Dataminer%' or
SoftwarePublisher like '%dCache.org%' or
SoftwarePublisher like '%Deepinstinct%' or
SoftwarePublisher like '%Dell%' or
SoftwarePublisher like '%Denequa%' or
SoftwarePublisher like '%Diebold Nixdorf%' or
SoftwarePublisher like '%Digicert%' or
SoftwarePublisher like '%Digital AI%' or
SoftwarePublisher like '%DNSFilter%' or
SoftwarePublisher like '%Docusign%' or
SoftwarePublisher like '%DSpace%' or
SoftwarePublisher like '%EasyRedmine%' or
SoftwarePublisher like '%Eaton%' or
SoftwarePublisher like '%EclecticIQ%' or
SoftwarePublisher like '%Eclipse Foundation%' or
SoftwarePublisher like 'EFI' or
SoftwarePublisher like '%EGroupware%' or
SoftwarePublisher like '%Elastic%' or
SoftwarePublisher like '%Ellucian%' or
SoftwarePublisher like '%EnterpriseDT%' or
SoftwarePublisher like '%Esri%' or
SoftwarePublisher like '%Evolveum Midpoint%' or
SoftwarePublisher like '%Ewon%' or
SoftwarePublisher like '%Exabeam%' or
SoftwarePublisher like '%Extreme Networks%' or
SoftwarePublisher like '%Extron%' or
SoftwarePublisher like '%F5%' or
SoftwarePublisher like '%FAST LTA%' or
SoftwarePublisher like '%Fastly%' or
SoftwarePublisher like '%FileCatalyst%' or
SoftwarePublisher like '%FileCloud%' or
SoftwarePublisher like '%FileWave%' or
SoftwarePublisher like '%FINVI%' or
SoftwarePublisher like '%FireDaemon%' or
SoftwarePublisher like '%Flexagon%' or
SoftwarePublisher like '%Flexera%' or
SoftwarePublisher like '%Forcepoint%' or
SoftwarePublisher like '%Forescout%' or
SoftwarePublisher like '%Fortinet%' or
SoftwarePublisher like '%FTAPI%' or
SoftwarePublisher like '%GE Digital%' or
SoftwarePublisher like '%GE Digital Grid%' or
SoftwarePublisher like '%GE Gas Power%' or
SoftwarePublisher like '%GE Healthcare%' or
SoftwarePublisher like '%Gearset%' or
SoftwarePublisher like '%Genesys%' or
SoftwarePublisher like '%GeoServer%' or
SoftwarePublisher like '%Gerrit code review%' or
SoftwarePublisher like 'GFI' or
SoftwarePublisher like '%Ghidra%' or
SoftwarePublisher like '%Globus%' or
SoftwarePublisher like '%GoAnywhere%' or
SoftwarePublisher like '%GoCD%' or
SoftwarePublisher like '%Google Cloud%' or
SoftwarePublisher like '%Grandstream%' or
SoftwarePublisher like '%Gravitee.io%' or
SoftwarePublisher like '%Guidewire%' or
SoftwarePublisher like '%HAProxy%' or
SoftwarePublisher like '%HarmanPro AMX%' or
SoftwarePublisher like '%Helpsystems%' or
SoftwarePublisher like '%HelpSystems Clearswift%' or
SoftwarePublisher like '%Hexagon%' or
SoftwarePublisher like '%Hikvision%' or
SoftwarePublisher like '%Hitachi Energy%' or
SoftwarePublisher like '%HMS-Networks%' or
SoftwarePublisher like '%Hologic%' or
SoftwarePublisher like '%Honeywell%' or
SoftwarePublisher like 'HPE' or
SoftwarePublisher like '%Huawei%' or
SoftwarePublisher like '%Hubspot%' or
SoftwarePublisher like '%I-Net software%' or
SoftwarePublisher like '%I2P%' or
SoftwarePublisher like '%IBA-AG%' or
SoftwarePublisher like '%Ibexa%' or
SoftwarePublisher like 'IBM' or
SoftwarePublisher like 'IFS' or
SoftwarePublisher like '%Ignite Realtime%' or
SoftwarePublisher like '%iGrafx%' or
SoftwarePublisher like '%Illuminated Cloud%' or
SoftwarePublisher like '%iManage%' or
SoftwarePublisher like '%Imperva%' or
SoftwarePublisher like '%IndustrialDefender%' or
SoftwarePublisher like '%infinidat%' or
SoftwarePublisher like '%Infor%' or
SoftwarePublisher like '%INIT GmbH%' or
SoftwarePublisher like '%Instana%' or
SoftwarePublisher like '%Instructure%' or
SoftwarePublisher like '%Intel%' or
SoftwarePublisher like '%InterSystems%' or
SoftwarePublisher like '%Intland%' or
SoftwarePublisher like '%IPRO' or
SoftwarePublisher like '%iRedMail%' or
SoftwarePublisher like '%IronNet%' or
SoftwarePublisher like '%ISLONLINE%' or
SoftwarePublisher like '%Jamasoftware%' or
SoftwarePublisher like '%Jamf Nation%' or
SoftwarePublisher like '%Jaspersoft%' or
SoftwarePublisher like '%Java Melody%' or
SoftwarePublisher like '%Jazz/IBM%' or
SoftwarePublisher like '%Jedox%' or
SoftwarePublisher like '%Jenkins%' or
SoftwarePublisher like '%Jitterbit%' or
SoftwarePublisher like '%Journyx%' or
SoftwarePublisher like '%Jump Desktop%' or
SoftwarePublisher like '%Juniper Networks%' or
SoftwarePublisher like '%Justice Systems%' or
SoftwarePublisher like '%K15t%' or
SoftwarePublisher like '%K6%' or
SoftwarePublisher like '%Kaltura%' or
SoftwarePublisher like '%Karakun%' or
SoftwarePublisher like '%Kaseya%' or
SoftwarePublisher like '%Keeper%' or
SoftwarePublisher like '%Keeper Security%' or
SoftwarePublisher like 'KEMP' or
SoftwarePublisher like '%Konica Minolta%' or
SoftwarePublisher like '%Kronos UKG%' or
SoftwarePublisher like '%Kyberna%' or
SoftwarePublisher like '%L-Soft%' or
SoftwarePublisher like '%L3Harris Geospatial%' or
SoftwarePublisher like '%Laserfiche%' or
SoftwarePublisher like '%LaunchDarkly%' or
SoftwarePublisher like '%Leica BIOSYSTEMS%' or
SoftwarePublisher like '%Lenovo%' or
SoftwarePublisher like '%LeoStream%' or
SoftwarePublisher like '%Let''s Encrypt%' or
SoftwarePublisher like '%LibreNMS%' or
SoftwarePublisher like '%LifeRay%' or
SoftwarePublisher like '%LifeSize%' or
SoftwarePublisher like '%Lime CRM%' or
SoftwarePublisher like '%Loftware%' or
SoftwarePublisher like '%LOGalyze%' or
SoftwarePublisher like '%LogiAnalytics%' or
SoftwarePublisher like '%LogMeIn%' or
SoftwarePublisher like '%Lucee%' or
SoftwarePublisher like '%Maltego%' or
SoftwarePublisher like '%ManageEngine%' or
SoftwarePublisher like '%ManageEngine Zoho%' or
SoftwarePublisher like '%MariaDB%' or
SoftwarePublisher like '%MathWorks Matlab%' or
SoftwarePublisher like '%Matillion%' or
SoftwarePublisher like '%Matomo%' or
SoftwarePublisher like '%Mattermost FocalBoard%' or
SoftwarePublisher like '%Medtronic%' or
SoftwarePublisher like '%Micro Focus%' or
SoftwarePublisher like '%MicroFocus%' or
SoftwarePublisher like '%Midori Global%' or
SoftwarePublisher like '%Mikrotik%' or
SoftwarePublisher like '%Milestone sys%' or
SoftwarePublisher like '%Mimecast%' or
SoftwarePublisher like '%Minecraft%' or
SoftwarePublisher like '%Miro%' or
SoftwarePublisher like '%Mitel%' or
SoftwarePublisher like '%MoogSoft%' or
SoftwarePublisher like '%Motorola Avigilon%' or
SoftwarePublisher like '%Mulesoft%' or
SoftwarePublisher like '%N-able%' or
SoftwarePublisher like '%Nelson%' or
SoftwarePublisher like '%Neo4j%' or
SoftwarePublisher like '%NetApp%' or
SoftwarePublisher like '%Netcup%' or
SoftwarePublisher like '%NetGate PFSense%' or
SoftwarePublisher like '%Nexus Group%' or
SoftwarePublisher like '%National Instruments%' or
SoftwarePublisher like '%Nice Software%' or
SoftwarePublisher like '%NinjaRMM%' or
SoftwarePublisher like '%NoviFlow%' or
SoftwarePublisher like '%Nutanix%' or
SoftwarePublisher like '%NVIDIA%' or
SoftwarePublisher like '%Objectif Lune%' or
SoftwarePublisher like '%Obsidian Dynamics%' or
SoftwarePublisher like '%Octopus%' or
SoftwarePublisher like '%Okta%' or
SoftwarePublisher like '%OneSpan%' or
SoftwarePublisher like '%Opengear%' or
SoftwarePublisher like '%OpenMRS%' or
SoftwarePublisher like '%OpenMRS TALK%' or
SoftwarePublisher like '%Orgavision%' or
SoftwarePublisher like '%OVHCloud%' or
SoftwarePublisher like '%OxygenXML%' or
SoftwarePublisher like '%Palo Alto%' or
SoftwarePublisher like '%Panopto%' or
SoftwarePublisher like '%Parse.ly%' or
SoftwarePublisher like '%PDQ%' or
SoftwarePublisher like '%Pentaho%' or
SoftwarePublisher like '%Pepperl+Fuchs%' or
SoftwarePublisher like '%Percona%' or
SoftwarePublisher like '%Personio%' or
SoftwarePublisher like '%Phenix Id%' or
SoftwarePublisher like '%Philips%' or
SoftwarePublisher like '%Phoenix Contact%' or
SoftwarePublisher like '%Pitney Bowes%' or
SoftwarePublisher like '%Planmeca%' or
SoftwarePublisher like '%Platform.SH%' or
SoftwarePublisher like '%Plesk%' or
SoftwarePublisher like '%Polycom%' or
SoftwarePublisher like '%Portainer%' or
SoftwarePublisher like '%PortSwigger%' or
SoftwarePublisher like '%PostGreSQL%' or
SoftwarePublisher like '%Postman%' or
SoftwarePublisher like '%Pretix%' or
SoftwarePublisher like '%PrimeKey%' or
SoftwarePublisher like '%IpSwitch%' or
SoftwarePublisher like '%Progress%' or
SoftwarePublisher like '%Proofpoint%' or
SoftwarePublisher like '%ProSeS%' or
SoftwarePublisher like '%Prosys%' or
SoftwarePublisher like '%PRTG Paessler%' or
SoftwarePublisher like 'PTC' or
SoftwarePublisher like '%Pure Storage%' or
SoftwarePublisher like '%QF-Test%' or
SoftwarePublisher like '%Qlik%' or
SoftwarePublisher like '%QNAP%' or
SoftwarePublisher like '%QOPPA%' or
SoftwarePublisher like '%QOS.ch%' or
SoftwarePublisher like '%QSC Q-SYS%' or
SoftwarePublisher like '%Quest Global%' or
SoftwarePublisher like '%R2ediviewer%' or
SoftwarePublisher like '%Radware%' or
SoftwarePublisher like '%Rapid7%' or
SoftwarePublisher like '%Raritan%' or
SoftwarePublisher like '%Ravelin%' or
SoftwarePublisher like '%Real-Time Innovations%' or
SoftwarePublisher like '%Red Hat%' or
SoftwarePublisher like '%Red Hat OpenStack Platform%' or
SoftwarePublisher like '%Red5Pro%' or
SoftwarePublisher like '%Reiner SCT%' or
SoftwarePublisher like '%ReportURI%' or
SoftwarePublisher like '%Respondus%' or
SoftwarePublisher like '%Revenera%' or
SoftwarePublisher like '%Flexera%' or
SoftwarePublisher like '%Ricoh%' or
SoftwarePublisher like '%RingCentral%' or
SoftwarePublisher like '%Riverbed%' or
SoftwarePublisher like '%Rockwell Automation%' or
SoftwarePublisher like '%Rollbar%' or
SoftwarePublisher like '%Rosette.com%' or
SoftwarePublisher like '%RSA Netwitness%' or
SoftwarePublisher like '%Rubrik%' or
SoftwarePublisher like '%Ruckus%' or
SoftwarePublisher like '%RunDeck by PagerDuty%' or
SoftwarePublisher like '%SAE-IT%' or
SoftwarePublisher like '%SAE IT-systems%' or
SoftwarePublisher like '%Safe Software%' or
SoftwarePublisher like '%SAFE FME Server%' or
SoftwarePublisher like '%Salesforce%' or
SoftwarePublisher like '%Sangoma%' or
SoftwarePublisher like '%SAP Advanced Platform%' or
SoftwarePublisher like '%SAP BusinessObjects%' or
SoftwarePublisher like 'SAS' or
SoftwarePublisher like '%SASSAFRAS%' or
SoftwarePublisher like '%Savignano software solutions%' or
SoftwarePublisher like '%ScaleComputing%' or
SoftwarePublisher like '%ScaleFusion MobileLock Pro%' or
SoftwarePublisher like '%Schneider Electric%' or
SoftwarePublisher like '%SCM Manager%' or
SoftwarePublisher like '%ScreenBeam%' or
SoftwarePublisher like '%SDL worldServer%' or
SoftwarePublisher like '%SecurePoint%' or
SoftwarePublisher like '%Security Onion%' or
SoftwarePublisher like '%Seeburger%' or
SoftwarePublisher like '%SentinelOne%' or
SoftwarePublisher like '%Sentry%' or
SoftwarePublisher like 'SEP' or
SoftwarePublisher like '%Server Eye%' or
SoftwarePublisher like '%ServiceNow%' or
SoftwarePublisher like '%Shopify%' or
SoftwarePublisher like '%Siebel%' or
SoftwarePublisher like '%Siemens%' or
SoftwarePublisher like '%Siemens Energy%' or
SoftwarePublisher like '%Siemens Healthineers%' or
SoftwarePublisher like '%Sierra Wireless%' or
SoftwarePublisher like '%Signald%' or
SoftwarePublisher like '%Silver Peak%' or
SoftwarePublisher like '%SingleWire%' or
SoftwarePublisher like '%Skillable%' or
SoftwarePublisher like '%SLF4J%' or
SoftwarePublisher like '%Smartbear%' or
SoftwarePublisher like '%SmileCDR%' or
SoftwarePublisher like '%Sn0m%' or
SoftwarePublisher like '%Software AG%' or
SoftwarePublisher like '%SolarWinds%' or
SoftwarePublisher like '%Sonatype%' or
SoftwarePublisher like '%SonicWall%' or
SoftwarePublisher like '%SOS Berlin%' or
SoftwarePublisher like '%Spambrella%' or
SoftwarePublisher like '%Spigot%' or
SoftwarePublisher like '%Splunk%' or
SoftwarePublisher like '%Spring%' or
SoftwarePublisher like '%Spring Boot%' or
SoftwarePublisher like '%Sterling Order%' or
SoftwarePublisher like '%Storagement%' or
SoftwarePublisher like '%StrangeBee%' or
SoftwarePublisher like '%Strimzi%' or
SoftwarePublisher like '%Stripe%' or
SoftwarePublisher like '%Styra%' or
SoftwarePublisher like '%SumoLogic%' or
SoftwarePublisher like '%SuperMicro%' or
SoftwarePublisher like '%Superna EYEGLASS%' or
SoftwarePublisher like '%Suprema Inc%' or
SoftwarePublisher like 'SUSE' or
SoftwarePublisher like '%Sweepwidget%' or
SoftwarePublisher like '%Swyx%' or
SoftwarePublisher like '%Synchro MSP%' or
SoftwarePublisher like '%Syncplify%' or
SoftwarePublisher like '%Synopsys%' or
SoftwarePublisher like '%Sysdig%' or
SoftwarePublisher like '%Tableau%' or
SoftwarePublisher like '%TealiumIQ%' or
SoftwarePublisher like '%TeamPasswordManager%' or
SoftwarePublisher like '%TechSmith%' or
SoftwarePublisher like '%Telestream%' or
SoftwarePublisher like '%Thales%' or
SoftwarePublisher like '%Thermo Fisher Scientific%' or
SoftwarePublisher like '%THK Group%' or
SoftwarePublisher like '%ThreatLocker%' or
SoftwarePublisher like '%Tibco%' or
SoftwarePublisher like '%Top Gun Technology%' or
SoftwarePublisher like '%Topix%' or
SoftwarePublisher like '%Trend Micro%' or
SoftwarePublisher like '%TrendMicro%' or
SoftwarePublisher like '%Tricentis Tosca%' or
SoftwarePublisher like '%Trimble%' or
SoftwarePublisher like '%Tripwire%' or
SoftwarePublisher like '%TrueNAS%' or
SoftwarePublisher like '%TRUMPF%' or
SoftwarePublisher like '%Tufin%' or
SoftwarePublisher like '%TYPO3%' or
SoftwarePublisher like '%Ubuntu%' or
SoftwarePublisher like '%Umbraco%' or
SoftwarePublisher like '%UniFlow%' or
SoftwarePublisher like '%Unify%' or
SoftwarePublisher like '%Unify ATOS%' or
SoftwarePublisher like '%Unimus%' or
SoftwarePublisher like '%USSIGNAL MSP%' or
SoftwarePublisher like '%Varian%' or
SoftwarePublisher like '%VArmour%' or
SoftwarePublisher like '%Varnish Software%' or
SoftwarePublisher like '%Varonis%' or
SoftwarePublisher like '%Venafi%' or
SoftwarePublisher like '%Veritas NetBackup%' or
SoftwarePublisher like '%Vertica%' or
SoftwarePublisher like '%Viso Trust%' or
SoftwarePublisher like '%VMware%' or
SoftwarePublisher like '%Vuze' or
SoftwarePublisher like '%Wallarm%' or
SoftwarePublisher like '%Wallix%' or
SoftwarePublisher like '%Wasp Barcode technologies%' or
SoftwarePublisher like '%WatchGuard%' or
SoftwarePublisher like '%Western Digital%' or
SoftwarePublisher like '%WindRiver%' or
SoftwarePublisher like '%Wistia%' or
SoftwarePublisher like '%Worksphere%' or
SoftwarePublisher like '%XCP-ng%' or
SoftwarePublisher like '%XenForo%' or
SoftwarePublisher like '%XPertDoc%' or
SoftwarePublisher like 'XPLG' or
SoftwarePublisher like '%XWIKI%' or
SoftwarePublisher like '%Xylem%' or
SoftwarePublisher like '%Yellowbrick%' or
SoftwarePublisher like '%YSoft SAFEQ%' or
SoftwarePublisher like '%Zaproxy%' or
SoftwarePublisher like '%Zebra%' or
SoftwarePublisher like '%Zendesk%' or
SoftwarePublisher like '%Zenoss%' or
SoftwarePublisher like '%Zimbra%' or
SoftwarePublisher like '%Zoho%' or
SoftwarePublisher like '%ZPE systems Inc%' or
SoftwarePublisher like '%Zyxel%' or
(
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Azure DevOps%'
)
OR (
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Kafka%'
)
OR (
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Team Foundation%'
) or
(
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Minecraft Java%'
)
or
(
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Team Foundation%'
)
or
(
tblSoftwareUni.SoftwarePublisher LIKE '%Microsoft%'
AND tblSoftwareUni.softwareName LIKE '%Events Hub%'
)
)
AND tblAssetCustom.State = 1
GROUP BY
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher,
tsysAssetTypes.AssetTypename
ORDER BY
Total DESC,
Publisher DESC

Show

Hide