locked
Around 100 Pending Uninstalls RRS feed

  • Question

  • Hello,

    I have been on leave and I have come back to around 100 Pending Uninstalls in the Pending Actions Queue which is growing. These have all been removed from the domain and I dont fancy going through the 3 step removal from the MOM console for each one as it will take an age!

    Does anyone know of any automated way of removing all of these from the MOM server using the 3 step way so they dont come back day after day?

    Many Thanks

    James

    Tuesday, June 21, 2011 7:57 AM

Answers

  • Hi,

    Thanks for the post.

    You could use the Forefront Client Security Offline Asset Removal Tool

    For more information about this tool, please visit http://support.microsoft.com/kb/2272146

    Thanks,

    Miles

     

     

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Miles Zhang Monday, July 11, 2011 2:34 AM
    Wednesday, June 22, 2011 8:12 AM
  • Hi,

    Please try the solution provided in the following KB article to delete orphaned server/s records from "OnePoint" Database:

    http://support.microsoft.com/kb/555911

    Thanks,

    Miles


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Miles Zhang Monday, July 11, 2011 2:34 AM
    Thursday, July 7, 2011 8:40 AM

All replies

  • Hi,

    Thanks for the post.

    You could use the Forefront Client Security Offline Asset Removal Tool

    For more information about this tool, please visit http://support.microsoft.com/kb/2272146

    Thanks,

    Miles

     

     

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Miles Zhang Monday, July 11, 2011 2:34 AM
    Wednesday, June 22, 2011 8:12 AM
  • Hello,

    Thanks for the reply I have now tried that and I get errors saying:

    "There were no computers called 'hostname1' found"

    "Could not delete the computer named 'hostname2' Timeout Expired or the server is not responding.

    Do you have any ideas as to why I am getting these timeout errors?

    Many Thanks

    James

    Wednesday, June 22, 2011 9:02 AM
  • Hello,

    We had some issues with SQL which are now sorted and it seems to be running quickly and efficiently. I have rejected the pending uninstalls which were still showing after running it as it says that PC's are not found so I will see wht happens tomorrow and let you know the outcome.

    Many Thanks

    James

    Thursday, June 30, 2011 2:01 PM
  • Hello,

    I have run the tool again against the pending uninstalls and they keep coming back and the tools you have suggested keeps saying they are not found.

    Do you have any idea's as to why these uninstalls keep coming back but are unable to be found in the database?

    Any help would be greatly apreciated.

    Many Thanks

    James

    Monday, July 4, 2011 11:49 AM
  • Hi,

    Please try the solution provided in the following KB article to delete orphaned server/s records from "OnePoint" Database:

    http://support.microsoft.com/kb/555911

    Thanks,

    Miles


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Miles Zhang Monday, July 11, 2011 2:34 AM
    Thursday, July 7, 2011 8:40 AM
  • hi ,

    I would like to try the below link,could you please give me a step by step guide on how to go about it.Am not good with SQL SCRIPTS but i do KNOW WHERE TO FIND 'ONEPOINT DATABASE'.The fcs server is running SQL 2005 ENTERPRISE

    Please try the solution provided in the following KB article to delete orphaned server/s records from "OnePoint" Database:

    http://support.microsoft.com/kb/55591

     

    THANKS,

    zebby


    Thursday, August 4, 2011 4:16 PM
  • hi,

    I have know how to execute to sql query but i get the following error(Msg 102, Level 15, State 1, Line 8
    Incorrect syntax near 'remove'.)s WHEN I RUN THE BELOW SCRIPT

    Use OnePoint
    Go
    Declare @computerID uniqueidentifier
    Set @computerID = (Select idComputer from Computer Where
    name = 'Management Server Name Here'AND domain
    = 'Domain Name Here')
     

    -- Perf Data --
    remove From SampledNumericData
    WHERE idSampledNumericDataSource on
    (Select idSampledNumericDataSource From
    SampledNumericDataSource where idPC = @computerID)
    remove From SampledNumericDataSource
    WHERE idPC = @computerID
    -- Events --
    remove From EventPaRandom-access memory
    WHERE idEvent on (Select idEvent FROM Event WHERE
    idloggedon=@ComputerID)
    remove From EventConsolidated
    WHERE idEvent on (Select idEvent FROM Event WHERE
    idLoggedOn=@ComputerID)
    remove From Event
    WHERE idGeneratedBy = @computerID
    -- Alerts --
    remove From alertEventSuppression
    WHERE idAlert on (Select idAlert FROM alert WHERE
    idComputer=@ComputerID)
    remove From AlertHistory
    WHERE idAlert on (Select idAlert FROM alert WHERE
    idComputer=@ComputerID)
    remove From alert
    WHERE idComputer=@ComputerID
    -- PC --
    remove From computerattribute
    WHERE idComputer=@ComputerID
    remove From ComputerResponsibility
    WHERE idConfigManager=@ComputerID
    remove From ComputerToComputerRule
    WHERE idCOmputer=@ComputerID
    remove From Configuration
    WHERE idComputer=@ComputerID
    remove From PC
    WHERE idPC = @computerID


    Msg 102, Level 15, State 1, Line 8
    Incorrect syntax near 'remove'.
    Msg 102, Level 15, State 1, Line 12
    Incorrect syntax near 'remove'.
    Msg 102, Level 15, State 1, Line 18
    Incorrect syntax near 'remove'.
    Msg 102, Level 15, State 1, Line 21
    Incorrect syntax near 'remove'.
    Msg 102, Level 15, State 1, Line 27
    Incorrect syntax near 'remove'.
    Msg 102, Level 15, State 1, Line 30
    Incorrect syntax near 'remove'.

    PLIZ ASSIST,

    THANKS

    Friday, August 5, 2011 1:48 PM
  • Hi zebby,

    In KB555911, it need to only input your pending computer name & domain name, no change with other scripts. The scripts use "delete" instead of "remove".

    Use OnePoint
    Go
    Declare @computerID uniqueidentifier
    Set @computerID = (Select idComputer from Computer Where
    name = 'Put your machine name in here' AND domain
    = 'Domain name')

    -- Perf Data --
    Delete From SampledNumericData
    WHERE idSampledNumericDataSource IN
    (Select idSampledNumericDataSource From
    SampledNumericDataSource where idComputer = @computerID)
    Delete From SampledNumericDataSource
    WHERE idComputer = @computerID
    -- Events --
    Delete From EventParam
    WHERE idEvent IN (Select idEvent FROM Event WHERE
    idloggedon=@ComputerID)
    Delete From EventConsolidated
    WHERE idEvent IN (Select idEvent FROM Event WHERE
    idLoggedOn=@ComputerID)
    Delete From Event
    WHERE idGeneratedBy = @computerID
    -- Alerts --
    Delete From alertEventSuppression
    WHERE idAlert IN (Select idAlert FROM alert WHERE
    idComputer=@ComputerID)
    Delete From AlertHistory
    WHERE idAlert IN (Select idAlert FROM alert WHERE
    idComputer=@ComputerID)
    Delete From alert
    WHERE idComputer=@ComputerID
    -- Computer --
    Delete From computerattribute
    WHERE idComputer=@ComputerID
    Delete From ComputerResponsibility
    WHERE idConfigManager=@ComputerID
    Delete From ComputerToComputerRule
    WHERE idCOmputer=@ComputerID
    Delete From Configuration
    WHERE idComputer=@ComputerID
    Delete From computer
    WHERE idComputer = @computerID


    Regards,
    Rick Tan


    Monday, August 8, 2011 5:51 AM