• Replies 8 replies
  • Subscribers 339 subscribers
  • Views 57 views
  • Users 0 members are here
Related

Clean Up TX_MACHINE_LOCATION

Beth Hawryluk
$organization

Hey there,

I notice that there is no "inactivate" option for TX_MACHINE_LOCATION. Is it ok to delete old rows here or should this be an ever growing list? How are other orgs keeping this table clean?

Thanks!

Parents
  • $organization

    Unknown said:

    I notice that there is no "inactivate" option for TX_MACHINE_LOCATION. Is it ok to delete old rows here or should this be an ever growing list? How are other orgs keeping this table clean?

    We have a scheduled SQL Agent job that deletes machines that haven't been logged in from in the last 90 days, with some exclusions. 

Reply
  • $organization

    Unknown said:

    I notice that there is no "inactivate" option for TX_MACHINE_LOCATION. Is it ok to delete old rows here or should this be an ever growing list? How are other orgs keeping this table clean?

    We have a scheduled SQL Agent job that deletes machines that haven't been logged in from in the last 90 days, with some exclusions. 

Children
No Data