topic Re: Site Engine Device Mapping Spreadsheet manipulation in ExtremeCloud IQ- Site Engine Management Center

Site Engine Device Mapping Spreadsheet manipulation

MaxHibbin — Fri, 17 Jan 2025 01:15:58 GMT

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

Re: Site Engine Device Mapping Spreadsheet manipulation

Zdeněk_Pala — Fri, 17 Jan 2025 12:57:36 GMT

Hi.

Adjusting values in th SQL database manually is not recommended and unsupported. Be careful if you go that path.

The GraphQL mutation can change the device's admin profile. I do not believe we have API call to change the device mapping: Device-UserGroup-DeviceProfile

Re: Site Engine Device Mapping Spreadsheet manipulation

MaxHibbin — Fri, 17 Jan 2025 16:35:34 GMT

Thanks. Could this API call be added as a new feature in an upcoming release?

Re: Site Engine Device Mapping Spreadsheet manipulation

Zdeněk_Pala — Sun, 19 Jan 2025 20:18:08 GMT

Hi,

Please work with the local account team to raise a Feature Request. There is a procedure we follow when we prepare roadmap for the product.

Thank you