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