xmc device mapping

[Rasolo_Rija]

Hi,

We installed a new xmc server from scratch. Now after re-creating Sites/devices/profiles/users/scripts …

We would like to associate profiles to device like on the old server without creating it by hand.

Is it possible to retrieve from our old server, the “Administration → Profiles → Device Mapping” spreadsheet via an API script ?

Or is there an entry corresponding to this table into the NBI or else where (sql database) ?

If anybody can help.

Regards

Rija

[Rasolo_Rija]

This is exactly what i need.

Thank you so much !!!

[Zdeněk_Pala]

here is the command you can use to get the data through the XMC 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 know it is not API call, but may help you...

[MaxHibbin]

Thanks for this query!   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 etc. according to its site. I am not familiar with writing sql but could we modify the above query to insert a new entries for a new IP with all the operators getting this or that 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 do that in a workflow. I just don't know sql at all. Thanks

[Rasolo_Rija]

Thank you fr the information.

I’ll ask the GTAC to know if its possible

Regards

Rija