Client Management Suite

 View Only
Expand all | Collapse all

Cleaning up UnManaged Records on a Reporting Server

  • 1.  Cleaning up UnManaged Records on a Reporting Server

    Posted Aug 08, 2011 02:30 PM

    Good afternoon,

    I am trying to troubleshoot some reporting anomalies in an environment I am starting to support. While reviewing the Reporting server I noticed that the Inventory and App Management licenses are exceeded and completely out of whack. We have 32K licenses and these are both showing over 50K being used in the console's licensing section.

    While our standard collections seem to be right on in terms of what is actually managed I suspected that these other licenses might be taken by records of unmanaged machines. I grabbed the 'All Computers' Collection', cloned it and flipped the isManaged value and sure enough 22K and change came up. Many of them look to have been on the server since 2008 when the architecture went up.

    So now I need to clean these up. With this many, I cannot imagine that shift selecting and deleting a 1000 at a time is going to be very effective.  Is there a recommended procedure to deleting this large number of unmanaged computers so that we can get down under our license count again and start seeing updated INV data on our managed machines again?

    Let me know if you have any advice for a good cleanup!

    Thank you

    SysMonkey



  • 2.  RE: Cleaning up UnManaged Records on a Reporting Server

    Posted Aug 08, 2011 03:22 PM

    select guid from vcomputer where ismanaged = '0' (Query)

    Pasted that into the bulk delete utility, and run it (follow the directions on the linked article).



  • 3.  RE: Cleaning up UnManaged Records on a Reporting Server

    Posted Aug 08, 2011 04:32 PM

    Thanks! I'll take a look!