--reporte porvenir


Select distinct 
    pcaliasname nombre_equipo,
	SO.OPNAME SISTEMA_OPERATIVO,
SO.TYPE TIPO,
system.LOADINGDATE Fecha_cargado_inicial,
system.ASSETDATE Fecha_ultimo_inventario,
system.DOMAIN dominio,
SYSTEMDETAILS.stype tipo_equipo,
IPMACADDRESS.IPADDRESS ip,
usuarios.uname,
system.username usuario_red




From SYSTEM
INNER join SYSTEMDETAILS on SYSTEMDETAILS.pcid = SYSTEM.PcId
INNER JOIN FILTERTREE ON FILTERTREE.FTR_INDEX = SYSTEM.LEVELFILTER
INNER JOIN ipMACADDRESS ON ipMACADDRESS.PCID = SYSTEM.PCID and IPMACADDRESS.IPDefault=1
INNER JOIN PROCESSOR ON PROCESSOR.PCID = SYSTEM.PCID
INNER JOIN MEMORY ON MEMORY.PCID = SYSTEM.PCID
INNER JOIN DISK_INFO ON DISK_INFO.PCID = SYSTEM.PcId and disk_info.FL_STR_REMOVABLE_TYPE like '%FIXED%'
INNER JOIN OPSYSTEM ON OPSYSTEM.PCID = SYSTEM.PCID
INNER JOIN SO ON SO.SOID = OPSYSTEM.SOID
left join usuarios on usuarios.username = system.username

        
Order by nombre_equipo




https://live.paloaltonetworks.com/t5/VirusTotal/Aranda-Software-Agent-False-Positive-generic-ml/m-p/283753#M1153