Thread Info
Options
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

RyanKane

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.
  • 0

    Try re-running the command with the following options individually set...

    where managed=1

    (for your management and licensing report)

    where deleted=0

    (to discount deleted machines as these are hidden in the console and will not be reported on)

    If you do a lot of SQL commands I suggest you always include either of the above to prevent the entire contents of the Sophos database pouring out.  You may also want to look at...

    http://www.sophos.com/support/knowledgebase/article/109884.html

    :3952

     - - - - - - - - - - - -

    Communities Moderator, SOPHOS
    Knowledge Base  |  @SophosSupport  |  Video tutorials
    Remember to like a post.  If a post (on a question thread) solves your question use the 'This helped me' link.

    • 0

      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
      • 0

        Hi,

        PurgeDB will work on 64-bit machines but you have to make it :)

        http://www.sophos.com/support/knowledgebase/article/66929.html

        This is fixed in SEC 4.5.

        Thanks,

        Jak

        :4059
        Unfiltered HTML