Client Management Suite

Hello,

I would like know if any one can help me to provide SQL Query that returns package download History details with event type (Start & End) as well as duration of download time.

example.

Machine Name, Package Name, event time (as Start), event tiem (as End), Pacakge size, downlaod size, duration time (as End - Start).

Regards

KR

You can try this SQL Query

SELECT DISTINCT
vc.Name AS [Client PC Name],
vc.[OS Name],
vc.[IP Address],
vc.Domain,
swd.[PackageName],
swd.[_eventTime],
swd.[EventType],
swd.[Status],
swd.[Time],
swd.[TransferRate]/(1024*1024) AS [Package Size in MB],
swd.URL

FROM Evt_AeX_SWD_Package swd
INNER JOIN [vComputer] vc ON swd.[_ResourceGuid] = vc.[Guid]
ORDER BY _eventTime
DESC

Hi, just be aware that especially for the large packages it is not 100% reliable. If you just need to know that the package download had been completed – here is some workaround https://www.symantec.com/connect/forums/force-agent-re-send-package-download-status