Need to update the record count in software package table

[suuriyas]

HI Community,

I have a requirement, we have schedule job which run daily in software instances table if record is not updated for more than 7 days then install on field is made empty. now in software package table the count needs to be reflected.

For example there is" x " software record in software instances table and there are 12 records and 3 of them are not updated for more than 7 days so for 3 records  install on is made empty now in the software package table the install count should be display as 9 instead of 12.

How can we achieve this?

Thanks in advance

[suuriyas]

HI @Abhijit4 ,

Can you please help me with the script, i need to create a new scheduled job for this which will run daily