Per individuare l'ultima data e ora in cui è stato installato un prodotto McAfee, eseguire il seguente query SQL nel database di ePO Core:
- Accedere a SQL Server Management Studio.
- Fare clic con il pulsante destro del mouse sul database McAfee ePO e selezionare Nuova query.
- Copiare lo script SQL riportato di seguito e incollarlo nella finestra SQL query
Nota Per ulteriori informazioni, consultare KB67591-come eseguire un script SQL fornito da Assistenza tecnica nel database di 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
------------------------------------------------------------------------------------------------------------------
Di seguito è riportato un esempio dei risultati che il query genera:
| 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 |
