find all virtual groups a device belongs to.

JW

Any idea how to use webconsole to find all the virtual groups a given device belongs to?

tia.

5 years ago
Windows
ANSWERS
K
KKMOD@SOTI
5 years ago

Hello James,

Thank you for the question. Unfortunately there is no way to display the total virtual group count through the webconsole but this might be possible through a custom report as the data is stored in the database. There is no single table to store this information so our professional services team can help you to make one.

I will suggest you to open a support case so that they can help you to set up a discovery call with our professional services team.

S
Scott
5 years ago

Yeah, webconsole no.  If you have SQL access this should give you basically what you want:

select a.Name, a.DeviceGroupPath from DeviceGroup a, DeviceGroupVirtualDevice b, DevInfo c where a.DeviceGroupId = b.DeviceGroupId and b.DeviceId = c.DeviceId and c.DevName = 'TC56-17110522502717'

Obviously, you would replace 'TC56-17110522502717' with your specific device name.  Also keep in mind that the group membership could be stale if your virtual groups have membership search filters associated with them as they are only updated periodically...