All,

 

We have a test SD Plus installation which is an exact mirror of our production environment.  We export the SQL 2008 to a .bak file and import it just fine.  Before we start the SD service though, I would like to make a few modifications to the database so that alerts and notifications are not being sent out to people.

 

For example, Scheduled PM tasks that were sitting in the queue would get sent out as soon as we turn the test environment on and that is confusing

 

Here is what we would like to modify.  Can anyone provid me the location and the variable in the table to do this. If so, we can sript the whole thing to export production, import into test, make the changes, and then turn on.  Very easy in my opinion.

 

1.  Disable Mail Fetching (So it doesn't pull tickets from the SD mailbox)

2.  Disable All notification rules (So if we test create tickets, we aren't sending out email to people and confusing them.)

3.  Disable Audit Rules (I don't want the test environment to scan our AD domain like the production environment does each day)

4.  Disable SLA Esclation (Technicans should not get overdue notifications or the test environment)

5.  Change the alias URL from servicedesk:8080 to sdtest:8080 

 

Thanks for any input you can provide.