cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
matthewellis
Level 8

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.

0 Kudos
1 Solution

Accepted Solutions
McAfee Employee

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

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.

matthewellis
Level 8

Re: help with queries

Jump to solution

Perfect!

 

Thank you.