External interaction with Prizm/BAM

Hi everybody,

I’m trying to write a web-based tool to help our support guys out - in particular I’m looking for a way to change the VLAN on an SM through a PHP page.

I’ve cracked open the database (oh my god what a mess… varchar(1500) and NO indexes!) and find multiple places for the VLAN profile name and actual untagged ingress VID - does anybody know if I can get away with just updating this information? Pushing to the SM is not a problem, it is trivial to get a customer to reboot their unit.

Using Prizm on RHEL/PostGRES with full EMS management of all nodes, etc.