Para localizar a última data e a hora em que um produto de McAfee foi instalado, execute a consulta SQL a seguir no banco de dados principal do ePO:
- Entre no SQL Server Management Studio.
- Clique com o botão direito do mouse no banco de dados da McAfee ePO e selecione Nova consulta.
- Copie o script de SQL fornecido abaixo e cole na janela de consulta SQL
OBSERVAÇÃO: Para obter ajuda, consulte KB67591-como executar uma script de SQL fornecida pelo Suporte técnico em relação ao banco de dados do ePolicy Orchestrator.
----------------------------------------------------------------------------------------------------------------------
create table #temp
(ProductCode nvarchar(50),
ProductVersion nvarchar(50),
ParentID int,
LastInstalled datetime
)
Insert into #temp
SELECT EPOProductProperties.ProductCode AS ProductCode, EPOProductProperties.ProductVersion AS ProductVersion,EPOProductProperties.ParentID,
COALESCE(MAX(EPOProductProperties.LastInstalled),MAX(EPOProductEvents.ReceivedUTC)) AS LastInstalled
FROM EPOProductProperties WITH (NOLOCK)
LEFT JOIN EPOProductEvents WITH (NOLOCK) ON EPOProductProperties.ProductCode=EPOProductEvents.ProductCode
AND EPOProductProperties.ParentID=EPOProductEvents.NodeID AND EPOProductEvents.Type='Install'
WHERE EPOProductProperties.ParentID in (SELECT ParentID FROM EPOComputerProperties) GROUP BY EPOProductProperties.ProductCode, EPOProductProperties.ProductVersion,EPOProductProperties.ParentID
Select #temp.ProductCode, #temp.ProductVersion,#temp.ParentID,#temp.LastInstalled,EPOComputerProperties.ComputerName
FROM #temp JOIN EPOComputerProperties ON #temp.ParentID = EPOComputerProperties.ParentID
If(OBJECT_ID('tempdb..#temp') Is Not Null)
Begin
Drop Table #temp
End
------------------------------------------------------------------------------------------------------------------
Veja abaixo uma amostra dos resultados que a consulta gera:
| ProductCode |
ProductVersion |
ParentID |
LastInstalled |
ComputerName |
| DXLBROKR1000 |
5.0.2.140 |
1 |
12/8/2020 17:20 |
tie301 |
| DXLJ____1000 |
5.0.2.140 |
1 |
12/8/2020 17:23 |
tie301 |
| DXLJ____1001 |
4.1.1.113 |
1 |
12/8/2020 17:27 |
tie301 |
| EPOAGENT3000 |
5.6.5.236 |
1 |
12/8/2020 17:20 |
tie301 |
| MARSERV1000 |
2.4.3.357 |
1 |
12/8/2020 17:27 |
tie301 |
| TIESVR__1000 |
3.0.1.119 |
1 |
12/8/2020 17:20 |
tie301 |
| ENDP_AM_1070 |
10.7.0.2298 |
2 |
12/9/2020 12:07 |
RGCEPO510 |
| ENDP_GS_1070 |
10.7.0.2174 |
2 |
12/9/2020 12:07 |
RGCEPO510 |
| EPOAGENT3000 |
5.5.1.342 |
2 |
12/8/2020 21:44 |
RGCEPO510 |
| TELEMTRY1000 |
2.1.0.700 |
2 |
12/8/2020 21:45 |
RGCEPO510 |
