cancel
Showing results for 
Search instead for 
Did you mean: 
Sohel
Level 10
Report Inappropriate Content
Message 1 of 2

Duplicate Systems

Jump to solution

Hello,

We use McAfee Drive Encryption, we assign laptop users to their designated laptop (from ePO v5.10 - Data Protection/Encryption Users).

Duplicate systems are causing an issue when we are trying to assign a laptop.

Is there a query or automated task available that can be set up to delete the duplicate entry based on date  (last communication)?

 

Thanks

 

 

1 Solution

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

Re: Duplicate Systems

Jump to solution

You first might want to look into why you are getting a lot of duplicates.  Does it occur after an AD sync, or when?  What version of epo and what agent version?  Do you have a task or 3rd party deployment that deploys agents with a forceinstall?  See kb's 60757 and 89427 for some issues.  Check audit log for when one of the duplicates were created and then compare it with any tasks, server or client, that might have been running at the time to possibly cause the duplicates.  Otherwise you can use this script in sql to remove duplicates.  Please validate table names, as different versions of epo name them slightly different.

delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)

SET rowcount 1000
delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)
WHILE @@rowcount > 0
BEGIN
delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)
END
SET rowcount 0

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?

View solution in original post

1 Reply
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 2

Re: Duplicate Systems

Jump to solution

You first might want to look into why you are getting a lot of duplicates.  Does it occur after an AD sync, or when?  What version of epo and what agent version?  Do you have a task or 3rd party deployment that deploys agents with a forceinstall?  See kb's 60757 and 89427 for some issues.  Check audit log for when one of the duplicates were created and then compare it with any tasks, server or client, that might have been running at the time to possibly cause the duplicates.  Otherwise you can use this script in sql to remove duplicates.  Please validate table names, as different versions of epo name them slightly different.

delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)

SET rowcount 1000
delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)
WHILE @@rowcount > 0
BEGIN
delete from epoleafnode where exists (select * from epoleafnode as l where l.nodename=epoleafnode.nodename and l.autoid!=epoleafnode.autoid and l.lastupdate>epoleafnode.lastupdate)
END
SET rowcount 0

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?

View solution in original post

More McAfee Tools to Help You

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