How can I automatically remove resources from a Custom Data Class?

[AndreasMuller]

Someone who can help me with this?

I have a CSV file with the colums "ComputerName" and "UserName". The CSV file is configured as a data source and that data source is imported into a custom data class on a schedule. This works as it should.

Now, I would like to make computers not in the CSV file to be removed from the custom data class. I cannot find that it is possible with the import task - it just adds or updates, and is not removing entries from the custom data class. Is it possible to do this? I guess it is possible to clear the custom data class and then let it repopulate, but how can I do that and schedule it?

[Alex Hedley]

Are you creating new Computer Resources from this CSV or is this a Data Class attached to another Resource?

[AndreasMuller]

Hi Alex,

The CSV updates existing Computer Resources;

 

[Igor Perevozchikov]

Well, "Purging Maintenance" doesn't allow to purge data from 'Inventory' data classes type and purges only from 'Event' data classes type.

About custom scheduled server job with few tasks sequence: You can create a Server Job -> include there SQL Query task to remove all data from custom data class and add 2nd task which will import fresh data via data connector import rule into this custom data class - set schedule with repeation for this "Server Job"

Andreas, did you try to use 'Update Mode:" - Replace , instead of current 'Update Mode: - Update" in your data connector import rule?

[AndreasMuller]

Thank you Igor,

Changing the update mode did nothing, so I created a Server Job that deletes the rows in the Custom Data Class and have scheduled it to happen before the import.

[Igor Perevozchikov]

Great that it works for you!

Just a Note about such solution with sql query task to manually remove records from custom data class:

Do not manually delete rows from custom data classes in case if you are populating there data using custom vbs client script tasks which are running on client side and agents sending 'nse' files with inventory data in these custom data classes.

Best regards,

IP.