SQL statement to delete data in bulk

Discussion created by sachinsharma on Sep 9, 2010
Latest reply on Jan 19, 2011 by chris.luekermann

I'm looking for a SQL statement I can run that will delete all data in the NMS SLM db that hasn't been updated in like 3 months. For example, delete any QoS object whose last sample time collected was more than 3 months ago, meaning the data used to be collected but isn't being collected anymore. Using the SLM is a nightmare for this. Any ideas?