topic Re:SQL Script to delete stale records in Intel vPro® Platform

SQL Script to delete stale records

KevSchu — Sat, 10 Feb 2024 18:39:25 GMT

Is there a SQL script that would allow me to delete stale device records? Have devices that havent checked-in in over 2 years. I have tried using the JavaScript website to delete multiple devices and it times out if I select too many records.

Re:SQL Script to delete stale records

Eduardo_B_Intel — Mon, 12 Feb 2024 21:07:09 GMT

Hello KevSchu,

I wish you an excellent day, Sir.

The endpoints can be manually removed from the databases, but we currently do not possess a script for this to happen automatically.

Warm regards,

Eduardo B

Re: Re:SQL Script to delete stale records

KevSchu — Mon, 12 Feb 2024 21:16:58 GMT

Is there any chance we could get a configurable maintenance task to auto purge devices that haven’t checked in within a certain amount of time ? Say, 90 or 120 days as an example.

Re:SQL Script to delete stale records

Eduardo_B_Intel — Tue, 13 Feb 2024 16:44:51 GMT

Hello KevSchu,

I wish you an excellent Tuesday, Sir.

We currently do not have a way to get that set up, but that is definitely something I'll take to my team as a consideration. What we currently have are the Intel AMT APIs, you can take these examples and modify them as needed:

Intel® Endpoint Management Assistant (Intel® EMA) API Sample Scripts

Intel® AMT High-level API

With the download comes a guide with examples you can check, Sir.

Please let me know if there are any other questions or concerns,

Warm regards,

Re:SQL Script to delete stale records

Eduardo_B_Intel — Mon, 19 Feb 2024 17:12:53 GMT

Hello KevSchu,

I wish you an excellent day and week's start, Sir.

This is a follow up message for your case, where I would like to know if there are additional questions, concerns or would like to have another date for me to check. I will monitor today and check one last time on the 22nd.