What is the best option for scheduled maintenance of CIs?

[Marcel H_]

I have been attempting to use Planned Maintenance to create tasks as part of regularly scheduled maintenance for CIs, but so far I haven't found this feature to be very intuitive to set up and seems to give inconsistent results.

Below is one of the scenarios that I am trying to solve for, but haven't had any real luck:

1. Create a maintenance plan/maintenance schedule that checks for any CI where a custom field "Battery schedule" is "Battery 030 Day".
2. Schedule this for every 30 days.
3. When the schedule runs, create a task (I don't really care out the task type, but Request would be preferrable) based on a template.

The issue that I'm running into is that Planned Maintenance seems geared towards Facilities or Finance, and I can't create a Schedule Template of the type that I want. Alternatively using a Scheduled Job to generate a task, there isn't a good way to associate it only to CIs that need maintenance on that schedule.

Does anyone have regular maintenance tasks that they are handling through these, or any other method that can give me some pointers on the best approach?

[SteveMacWWT]

You could certainly use a scheduled job and use  a GlideRecord query get a list of CIs that have that attribute set with the right value. Loop through those and create the necessary task for each CI. 

[Marcel H_]

That is what I'm thinking as well since Planned Maintenance doesn't seem like it will work for our environment due to the most critical features being locked behind a subscription, making the whole thing unusable.

I'm wondering what the best way to make sure the Affected CI is added to each new task.