find all virtual groups a device belongs to.

find all virtual groups a device belongs to.

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

tia.

2 Answers

Order By:   Standard | Newest | Votes
KKMOD@SOTI | posted this 08 December 2019

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.

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |

  • 0
  • 0
Scott | posted this 09 December 2019

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

  • 0
  • 0

Give us your feedback
Give us your feedback
Feedback