This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Stale computer objects showing up in EM Console 4

I can't recall if we had a similar problem with the version 3 console, but now it seems whenever we remove a machine from AD (we are using AD-Sync) the computer object still shows up in the console. If we delete the object from the Sophos Console then it shows back up in the unassigned computers.

We have in the 4-5k machine range and now our console is showing us clocking in at almost 8000 machines because of all the old objects.

I can run a query against the ComputersAndDeletedComputers table and see over 1400 objects that have not contacted the server this calendar year, yet they still show up in my SEM Console.

I'm trying to get the SEM Console showing an accurate number of machines both from a licensing standpoint as well as a metrics standpoint. I have a hard time telling the management teams that we have 7800 machines out of 7950 machine managed when the asset lists say we only own about 4200 devices.

Am I missing something that allows me to actually turn off everything that's gone or are they some types of cleanup scripts that should be running against the database that purges this type of stuff that's failing?

Thanks,

-Ryan

:3950


This thread was automatically locked due to age.
Parents
  • select * from computersanddeletedcomputers

    This gives me 7947 rows

    select * from computersanddeletedcomputers where deleted=0


    This gives me 7940 rows

    select * from computersanddeletedcomputers where managed=1

    This gives me 7811 rows

    these queries are not really coming close to taxing the system they take less than 1 second to return. If this was something we were planning to run on an ongoing basis we would be more concerened.

    The PurgeDB command does not work on 64-bit machines so no luck there as both the system running the console as my own workstation are 64-bit.

    :4034
Reply
  • select * from computersanddeletedcomputers

    This gives me 7947 rows

    select * from computersanddeletedcomputers where deleted=0


    This gives me 7940 rows

    select * from computersanddeletedcomputers where managed=1

    This gives me 7811 rows

    these queries are not really coming close to taxing the system they take less than 1 second to return. If this was something we were planning to run on an ongoing basis we would be more concerened.

    The PurgeDB command does not work on 64-bit machines so no luck there as both the system running the console as my own workstation are 64-bit.

    :4034
Children
No Data