cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Level 8
Report Inappropriate Content
Message 1 of 6

Need to pull last information regarding a node from database

Jump to solution
I have some servers that were powered off and then shut down. I would like to pull from the ePO database the last communication time and the last DAT that was installed. I have tried performing a SQL query on leafnode, but all relevant values return 'NULL'. Is there any way to gather the information?
1 Solution

Accepted Solutions
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

NULL means it's never communicated to ePO server. Do you see entry managed or unmanaged under EpoLeafNode?

View solution in original post

5 Replies
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

Hello @fking1 

Thanks for the post.

You can also view this from ePO Query and Reports.

There are several by default query which you can run it or if you want to modify you can duplicate the query and made the changes and run it.

Try using Agent Communication Summary or Inactive Agents  query.

Also you can built a new query,
Query and Reports>New Query>Systems>Table>Add the columns>Add the filter like last communication, DAT Version, OS Type and save it or run it.

Once this will executed successfully you will get the output.

Also once the Query will get saved the please select the query and from actions you can get the View SQL which you can execute to the database and you have the output.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Highlighted
Level 8
Report Inappropriate Content
Message 3 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

Basically I need to know DAT version of the node before it was destroyed.
The ePO dashboard shows no information for the node.
For last update information I ran the SQL query against the database:
select * from EPOLeafNode where NodeName = '<nodename>'
It returned values of NULL for 'LastUpdate'
Is there a way to find out the dat version from another table?

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

NULL means it's never communicated to ePO server. Do you see entry managed or unmanaged under EpoLeafNode?

View solution in original post

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

If the system doesn't exist in the system tree with relevant info, it isn't in the database.  Perhaps it was deleted with an inactive agent server task?  Otherwise you would need to restore the database to different sql server for when the system did exist to pull data from that db.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Level 8
Report Inappropriate Content
Message 6 of 6

Re: Need to pull last information regarding a node from database

Jump to solution

I apparently was looking at the new database instead of the older database which had the hosts that I needed with the required information. Thanks.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community