要查找最后一次安装 McAfee 产品的日期和时间,请在 ePO 核心数据库上运行以下 SQL 查询:
- 登录 SQL Server Management Studio。
- 右键单击 McAfee ePO 数据库并选择新建查询。
- 复制以下提供的 SQL 脚本,并将其粘贴到 SQL 查询窗口
注意:有关帮助,请参阅KB67591 - 如何根据系统技术支持提供的 SQL 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
------------------------------------------------------------------------------------------------------------------
下图是查询所生成结果的示例:
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 |