SQL Script to delete stale records

[KevSchu]

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.

[Eduardo_B_Intel]

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

[KevSchu]

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.

[Eduardo_B_Intel]

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,

[Eduardo_B_Intel]

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.