Symantec Management Platform (Notification Server)

 View Only
  • 1.  Unable to Delete Computers from Console

    Posted Apr 17, 2013 01:28 PM

    We have a need to delete a large number of abandoned PCs or PCs that have been disposed of however when I went to do it nothing happened. Looking in the logs there appears to be a SQL SP missing! The short, key point to the error message is:

     

    Could not find stored procedure dbo.sp_Inv_Patch_Computers_Subject_For_Licensing_resource_delete

     

    The problem I have now, is A) can I just find that SP on another machine and add it back in and/or B) If I have to do a repair, does anyone know which solution or part thereof I might need to repair? Can I just do a reconfigure on a specific MSI rather than have to repair the entire solution?

     

    Any help would be appreciated. I'll put in a support case too but this often gets me faster results.

    A side note, we are at 7.1 SP2 with the latest release and roll-ups.

     

     



  • 2.  RE: Unable to Delete Computers from Console

    Posted Apr 17, 2013 03:00 PM

    You can just find it from another system and usually run it in SQL Query Analyser to create it.



  • 3.  RE: Unable to Delete Computers from Console
    Best Answer

    Posted Apr 18, 2013 09:14 AM

    I got it. Since I didn't have a different system running, support got me the query and I'm back in business.

     

    Thanks!

     

    For anyone needing it:

     

    create proc dbo.sp_Inv_Patch_Computers_Subject_For_Licensing_resource_delete
    @ResourceGuid
    uniqueidentifieras
        set
         nocount on