Report and Alert on Long OnDemand Scans

[shocko]

Guys, running ePO 5.10 and ENS on desktop but VSE on server estate (all windows). I'd like to run a report showing how long the ODS scans are running to identify servers with long running times or servers that are not completing their scans within the window allotted. 

[shocko]

Anyone?

[Former Member · Accepted solution]

Hi @shocko 

You won't be able to generate a report that shows you the run time. But what you can do is generate a report for Start and Completed Events which in turn will lead you to be able to work out run time:

https://kc.mcafee.com/corporate/index?page=content&id=KB69428

[shocko]

Hi, yes this is what I had done in the past. I can update it again. I had built this out with simple VB and Excel but will look to something more modern like PowerBI or Tableau. 

[shocko]

Actually, I see these reports.

[shocko]

I see one of the reports above is backed by this SQL:

select top 200 count(*) as 'count', [AM_CustomProps].[ODSFullAverageScanDuration], [AM_CustomProps].[ODSFullAverageScanDuration] from [AM_CustomProps] where ( [AM_CustomProps].[ODSLastFullScanDate] >= '2020-06-04T15:22:10.441' ) group by [AM_CustomProps].[ODSFullAverageScanDuration] order by [AM_CustomProps].[ODSFullAverageScanDuration] asc

[shocko]

Just for posterity, my last reply is actually a new capability in ENS but it has limitations. ENS stores the latest value of the ODS scan duration in a custom property and reports back to ePO:

• It only stores the last value sent from the client. No historical data
• It's a summary value and not exact e.g. > 1 hr rather than 43.23 mins 

See here.