A student of mine asked a great question around call forwarding rules. He wanted to know where the information is stored and how it can be access. I had no clue, so I asked others.
Brad Wilson and Ty Ryan at Microsoft did a little testing and sent me a way to pull the information pretty easily. I suppose once you know where to get the info, it should be possible to update it in the database.
So, anyway, if you run the following command from an OCS 2007 R2 front-end server, you should get similar results.
C:Program FilesMicrosoft Office Communications Server 2007 R2 ResKit>DBAnalyze.exe /v /report:user /user:ConfusedUserName@TheirSIPDomain.com /sqlserver:SQLServerNameSQLInstanceName > c:DBanalyze.txt
Category Name : routing
Container Number : 0
Instance Number : 0
Version : 2
LastPubTime : 8/5/2010 5:26:11 PM
ExpiresAt : NULL
Data : <routing xmlns="http://schemas.microsoft.com/02/2006/sip/routing" name="rtcdefault" version="2" minSupportedClientVersion="184.108.40.206"><preamble><flags name="clientflags" value="enablecf forward_immediate"></flags><wait name="total" seconds="20"></wait><list name="forwardto"><target uri="sip:+13035551212@TheirSIPDomain.com;user=phone"></target></list><wait name="user" seconds="0"></wait><wait name="team1" seconds="0"></wait><wait name="team2" seconds="0"></wait></preamble></routing>
The important part is the setting shown in red, above.