Solved

xmc device mapping

  • 22 September 2020
  • 4 replies
  • 37 views

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

icon

Best answer by Zdenek Pala 22 September 2020, 16:09

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

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

 

View original

4 replies

Userlevel 7

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

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

 

Thank you fr the information.

I’ll ask the GTAC to know if its possible

Regards

Rija

Userlevel 7

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

This is exactly what i need.

Thank you so much !!!

Reply