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...

[Rasolo_Rija]

Thank you fr the information.

I’ll ask the GTAC to know if its possible

Regards

Rija

[Zdeněk_Pala · Accepted solution]

following NBI can give you the mapping for XMC. I am not aware of group to profile mapping.

{
  network {
    devices {
      ip
      deviceData {
        profileName
      }
    }
  }
}