select	
IA.Name [Equipo],
doc.[User] [usuario],
doc.Domain [Dominio],
ia.[Operating System][Sistema Operativo],
IA.[Computer Model] [Modelo],
IA.[Memory (MB)] as 'Parametro de memoria Anterior',
IH.[Memory (MB)] as 'Parametro de memoria Actual',
IH.[Serial number]  [Serial],
IA.[Dirección IP] as 'Direccion IP' ,
-----------------------------------------------------------------
CASE 
	WHEN doc.[IP Address] like '10.16.33.%' THEN 'AGUACHICA-CESAR'
        WHEN doc.[IP Address] like '10.16.34.%' THEN 'APARTADO-ANTIOQUIA'
        WHEN doc.[IP Address] like '10.16.35.%' THEN 'ARIGUANI (ELDIFÍCIL)'
	WHEN doc.[IP Address] like '10.16.36.%' THEN 'BARRANCABERMEJA- SANTANDER'
	WHEN doc.[IP Address] like '10.16.37.%' THEN 'BARRANQUILLA-ATLÁNTICO'
	WHEN doc.[IP Address] like '10.16.38.%' THEN 'CIUDADBOLÍVAR- BOGOTA '
	WHEN doc.[IP Address] like '10.16.39.%' THEN 'ENGATIVA- BOGOTA'
	WHEN doc.[IP Address] like '10.16.40.%' THEN 'KENNEDY- BOGOTA'
	WHEN doc.[IP Address] like '10.16.41.%' THEN 'RAFAELURIBE- BOGOTA'
	WHEN doc.[IP Address] like '10.16.42.%' THEN 'BUCARAMANGA-SANTANDER'
	WHEN doc.[IP Address] like '10.16.43.%' THEN 'CALI- VALLE '
	WHEN doc.[IP Address] like '10.16.44.%' THEN 'CARTAGENA-BOLÍVAR'
	WHEN doc.[IP Address] like '10.16.45.%' THEN 'CAUCASIA-ANTIOQUIA'
	WHEN doc.[IP Address] like '10.16.46.%' THEN 'CUCUTA- NORTEDE SANTANDER'
	WHEN doc.[IP Address] like '10.16.47.%' THEN 'FLORENCIA-CAQUETÁ'
	WHEN doc.[IP Address] like '10.16.48.%' THEN 'IBAGUÉ- TOLIMA'
	WHEN doc.[IP Address] like '10.16.49.%' THEN 'PAZ Y RECONCILIACIÓN- MEDELLÍN'
	WHEN doc.[IP Address] like '10.16.50.%' THEN 'MONTERÍA-CÓRDOBA'
	WHEN doc.[IP Address] like '10.16.51.%' THEN 'NECOCLI-ANTIOQUIA'
	WHEN doc.[IP Address] like '10.16.52.%' THEN 'NEIVA- HUILA'
	WHEN doc.[IP Address] like '10.16.53.%' THEN 'PASTO- NARIÑO'
	WHEN doc.[IP Address] like '10.16.54.%' THEN 'PEREIRA-RISARALDA'
	WHEN doc.[IP Address] like '10.16.55.%' THEN 'PUERTOBERRIO-ANTIOQUIA'
	WHEN doc.[IP Address] like '10.16.56.%' THEN 'SANTA MARTA-MAGDALENA'
	WHEN doc.[IP Address] like '10.16.57.%' THEN 'SINCELEJO-SUCRE'
	WHEN doc.[IP Address] like '10.16.58.%' THEN 'TIERRALTA-CÓRDOBA'
	WHEN doc.[IP Address] like '10.16.59.%' THEN 'VALLEDUPAR-CESAR'
	WHEN doc.[IP Address] like '10.16.60.%' THEN 'VILLAVICENCIO-META'
	WHEN doc.[IP Address] like '10.16.61.%' THEN 'YOPAL-CASANARE'
	WHEN doc.[IP Address] like '10.16.62.%' THEN 'SEDE CENTRAL- BOGOTÁ'
	WHEN doc.[IP Address] like '10.16.63.%' THEN 'ALPUJARRA- MEDELLÍN'
	WHEN doc.[IP Address] like '10.16.64.%' THEN 'MOCOA-PUTUMAYO'
	WHEN doc.[IP Address] like '10.16.65.%' THEN 'POPAYAN-CAUCA'
	WHEN doc.[IP Address] like '10.16.66.%' THEN 'AGUA BLANCA-CALI'
        WHEN doc.[IP Address] like '10.15.3.%'   THEN 'Sede Central Piso 2'
	WHEN doc.[IP Address] like '10.15.5.%'   THEN 'Sede Central Piso 7'
	WHEN doc.[IP Address] like '10.15.6.%'  THEN 'Sede Central Piso 3'
        WHEN doc.[IP Address] like '10.15.7.%'   THEN 'Sede Central Piso 5'
        WHEN doc.[IP Address] like '10.15.9.%'   THEN 'Red Inalambrica Sede Central'
        WHEN doc.[IP Address] like '10.15.10.%'   THEN 'Segmento Desconocido'
	WHEN doc.[IP Address] like '10.15.14.%'   THEN 'Sede Central Piso 4'
	WHEN doc.[IP Address] like '10.15.15.%'   THEN 'Sede Central Piso 5'
	WHEN doc.[IP Address] like '10.15.16.%'   THEN 'Sede Central Piso 5'
	WHEN doc.[IP Address] like '10.15.17.%'   THEN 'Sede Central Piso 6'
	WHEN doc.[IP Address] like '10.15.18.%'   THEN 'Sede Central Piso 8'
	WHEN doc.[IP Address] like '10.212.134.%' THEN 'VPN'
    	WHEN doc.[IP Address] like '100.70.38.%' THEN 'Pendiente identificar'
    	WHEN doc.[IP Address] like '192.168.0.%' THEN 'Pendiente Identificar'
    	WHEN doc.[IP Address] like '192.168.1.%' THEN 'Pendiente identificar'
    	WHEN doc.[IP Address] like '192.168.43.%' THEN 'Pendiente identificar'
    	WHEN doc.[IP Address] like '192.168.100.%' THEN 'Pendiente identificar'
        WHEN doc.[IP Address] like '10.212.134.%' THEN 'VPN'
        WHEN doc.[IP Address] like '100.70.38.%' THEN 'Pendiente identificar'
        WHEN doc.[IP Address] like '192.168.0.%' THEN 'Pendiente Identificar'
        WHEN doc.[IP Address] like '192.168.1.%' THEN 'Pendiente identificar'
        WHEN doc.[IP Address] like '192.168.43.%' THEN 'Pendiente identificar'
        WHEN doc.[IP Address] like '192.168.100.%' THEN 'Pendiente identificar'
    ELSE 'Pendiente identificar'
END [Ubicacion]
from dbo.temp_InventarioAyer IA
join dbo.vInventarioActual IH on  IA.guid = IH.guid
join vComputer doc on  IA.guid = doc.guid
where IA.[Memory (MB)] > IH.[Memory (MB)]
and IA.[Operating System] not like '%server%' and IA.[Serial Number] is not null