Bulk Edit Request - Bridge information in User Profile

[Ginger Dillon]

Hello -

Would you consider making the Bridge fields (Unity node serial number and Legacy Mailbox ID) available on the User profile tab of the Bulk Edit tool? Thank you very much for considering this request :-)

Sincerely,

Ginger

[lindborg]

I'm not sure how BulkEdit would update the Legacy Mailbox Id value for users - this would be something more appropriate to a CSV file type mapping since those values will be different for each user. BulkEdit is a "pattern" edit type tool - this would work better in a CUBI (or CUBI-like) tool I'd think...

[Ginger Dillon]

Hi Jeff -

Thanks for responding! I'll take a look at the CUBI and take some time to investigate using a CSV file next time I need to make multiple changes.

Sincerely,

Ginger

[lindborg]

Actually, I don't think CUBI can do those fields today (I'll have to check) - but that would be the tool you'd want to update to handle this I'd think.

[baldwinj]

CUBI can be used to create Unity subscribers with the properties required for Bridge networking and to modify these properties for existing Unity subscribers. See the CUBI help file for additional information on using the REMOTE_NODE_ID and LEGACY_MAILBOX values.

[dcavanaugh]

CUBI can do these fields but how does CUBI remove the values from these fields. I want to remove the REMOTE_NODE_ID and LEGACY_MAILBOX_ID from all accounts. Does CUBI understand a NULL keyword?

[lindborg]

I don't believe CUBI can remove values for those fields.

Why do you want to remove them? If you're removing Bridge support those values aren't going to hurt anything - they're only used for routing bridge messages and if the bridge is being taken out, no harm will comes to the system just leaving them there.

You can remove them via an SQL query if you really are wanting to be rid of them...

[dcavanaugh]

We are done with the bridge and are looking to upgrade to Unity 4.2. I would just like to clean up the database for future upgrades. Information regarding the SQL query would be helpful.

[lindborg]

If you're all done with the bridge then you can remove those properties for all subscribers with this query:

UPDATE subscriber

SET LegacyMailbox = NULL, RemoteNodeID=NULL

WHERE subscribertype IN (1,3)

You can enter that into the Query builder found in the Data Link Explorer found in the tools depot or using the query build found under the SQL tools from MS if you have full SQL 2000 installed (it does not come with MSDE). Either way works.