Auto Delete DB Records

[Jayachandran Anbalagan]

Is there any way to delete DB records automatically(weekly schedule)  in #devtest10.2

[wooda20]

We have a way to delete the test reports over a given age. This clean-up process removes records over 30 days old by default, but is configurable.  

 

For more information, please see Database Maintenance - DevTest Solutions - 10.2 - CA Technologies Documentation 

 

We also have an equivalent for VSE metrics, that have the defaults shown below. Should you wish to override any of these then the properties should be added to your local.properties file

 

# These properties are used to control metrics collection in VSE servers. The metrics
# collected can be viewed in the web-based VSE dashboard. The values here are the defaults.

# Main property to turn overall metrics collection on (true) or off (false).
lisa.vse.metrics.collect=true

# This property controls the level at which transaction counts are recorded. Options are none
# (or false), service (the default), operation, or arguments.
lisa.vse.metrics.txn.counts.level=service

# This property controls how often transaction rate and response times are sampled.
lisa.vse.metrics.sample.interval=5m

# These properties control how often old metric data is scanned for and deleted, along with what
# counts as old.
lisa.vse.metrics.delete.cycle=1h
lisa.vse.metrics.delete.age=30d

[Jayachandran Anbalagan]

Hi Dave,

 

This will delete all the suite transaction records every 30d?+

[Jayachandran Anbalagan]

 Is this parameter purges / cleansing data only for VSE or all (incl ACL, registry, etc...)?

[Jayachandran Anbalagan]

Is this parameter purges / cleansing data only for VSE or all (incl ACL, registry, etc...)?

[wooda20]

Hi.

 

As per the defaults, these properties will delete all metrics (test or VSE) that are older than 30 days. The ACL etc will not be affected, only test and VSE metrics