Question I am testing a custom inventory, and the default behavior is to not reload matching data. How can I remove or delete records for a given resource from a custom inventory table?
If you only want to delete data for one resource, the following query can help. To delete records for a single resource from a custinv table:
-- @rguid is the _resourceguid for the client computer -- @dcguid is the dataclass guid. It can be found in various ways, including: -- select * from dataclass where name = '<dataclass name>' DECLARE @rguid varchar(36) DECLARE @dcguid varchar(36) DECLARE @custtablename varchar(256)
set @rguid = ‘???’ set @dcguid = '???' set @custtablename = ‘???’
delete from @custtablename where _resourceguid = @rguid delete from resourceupdatesummary where resourceguid = @rguid and inventoryclassguid = @dcguid
Imported Document Id
This is machine translated content
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Didn't find the article you were looking for? Try these resources.