Video Screencast Help

Unable to Delete Computers from Console

Created: 17 Apr 2013 • Updated: 18 Apr 2013 | 2 comments
This issue has been solved. See solution.

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.

 

 

Operating Systems:

Comments 2 CommentsJump to latest comment

andykn101's picture

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

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

jpellet2's picture

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
SOLUTION