When we add a new device to XIQ-SE, I would like it to automatically get a "device mapping" of what operators can see it or what operators cannot according to its site its placed in and a particular operator authorization group. I remember seeing a thread where @Zdeněk_Pala gave a sql query to run in the shell.
cd /usr/local/Extreme_Networks/NetSight/scripts/
./mysql.sh
use netsight
select nsdevices.ip, nsusergroups.groupname,nsprofiles.profilename from nsgrouptoprofile inner join nsusergroups on nsgrouptoprofile.GROUPID = nsusergroups.GROUPID INNER JOIN nsdevices on nsdevices.DeviceID = nsgrouptoprofile.DeviceID inner join nsprofiles on nsgrouptoprofile.profileid = nsprofiles.profileid;
I am not familiar with writing sql but could we modify the above query to modify a certain IP address and change the values of the group and the profile?
I am asking because it does not seem that "Device mapping" matrix values are available in the NBI to manipulate with a workflow.
With the above ask to insert in the sql database I think I could get python to execute that,. I just don't know sql at all. Thanks
