I have made ??a comparison of query and snetworkname item_keya. Below the syntax:

SELECT

snetworkname,

REPLACE(sNetworkName,'.noc','')

FROM WhatsUp_Assyst_replicatie3.dbo.NetworkInterface

RIGHT OUTER JOIN WhatsUp_Assyst_replicatie3.dbo.device

ON WhatsUp_Assyst_replicatie3.dbo.NetworkInterface.nNetworkInterfaceID = WhatsUp_Assyst_replicatie3.dbo.device.nDefaultNetworkInterfaceID

WHERE REPLACE(sNetworkName,'.noc','') NOT IN (SELECT

REPLACE(item_keya,'.noc','') AS NUMBER

FROM dbo.item

WHERE item_keya IS NOT NULL

AND item_keya <> '')

The syntax is the following:

ASR-AMF-SW-012.NOC

asr-amf-sw-200.noc

asr-utr-sw-118.noc

asr-woe-px-110.noc

ess-es1nl032itasa01.noc

ess-es1nl300nsoss001

ess-es1nl317ns1s001.noc

ess-es1nl317ns37s001.noc

Now I just I want to get a percentage as a percentage of how many devices from the result, eg the result;

item_keya / snetworkname * 100 = much percentage is not present or something ...

In Item_keya are all devices of customers and snetworkname all devices that have. Item_keya in