cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

help with queries

Jump to solution

{running ePO 5.9.1}

Greetings,

I am trying to build two queries and having difficulties getting the data I need.  Any chance someone can assist?

Query 1:  total number of new workstations reporting in to ePO for time period X to Y

Query 2: total number of unique workstations reporting into to ePO since ePO inception.

Thanks for any assistance.

1 Solution

Accepted Solutions
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: help with queries

Jump to solution

query 1 - Under queries & reports section, choose new query, managed systems, set it as table or whatever result you prefer.  Choose the columns you want to see, then in the filter section choose last communication under managed systems properties.  for the filter, choose "is between", then enter your specific dates.

query 2 - Same basic query, just don't use a filter.  It will not return any systems that have been deleted but used to talk to epo, as they no longer exist.

2 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: help with queries

Jump to solution

query 1 - Under queries & reports section, choose new query, managed systems, set it as table or whatever result you prefer.  Choose the columns you want to see, then in the filter section choose last communication under managed systems properties.  for the filter, choose "is between", then enter your specific dates.

query 2 - Same basic query, just don't use a filter.  It will not return any systems that have been deleted but used to talk to epo, as they no longer exist.

Re: help with queries

Jump to solution

Perfect!

 

Thank you.