topic Re: xmc device mapping in ExtremeCloud IQ- Site Engine Management Center

xmc device mapping

Rasolo_Rija — Tue, 22 Sep 2020 21:05:58 GMT

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

Re: xmc device mapping

Zdeněk_Pala — Tue, 22 Sep 2020 21:09:46 GMT

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

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

Re: xmc device mapping

Rasolo_Rija — Tue, 22 Sep 2020 21:28:35 GMT

Thank you fr the information.

I’ll ask the GTAC to know if its possible

Regards

Rija

Re: xmc device mapping

Zdeněk_Pala — Tue, 22 Sep 2020 21:59:35 GMT

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

Re: xmc device mapping

Rasolo_Rija — Wed, 23 Sep 2020 14:36:32 GMT

This is exactly what i need.

Thank you so much !!!

Re: xmc device mapping

MaxHibbin — Tue, 10 Dec 2024 01:20:07 GMT

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