|
| | | Supreme Being
Group: Forum Members
Last Login: 11/21/2008 11:36:18 AM
Posts: 113, Visits: 133 |
| Hi, I am trying to create a world map for our networked sites. I need to dynamically query all folders and their devices in Whatsup. What would the SQL query look like to retrieve device groups/folders from Whatsup.
--
carlo
|
| |
| | | Supreme Being
Group: Forum Members
Last Login: 11/21/2008 11:36:18 AM
Posts: 113, Visits: 133 |
| | bump! Anyone have any idea how to query groups instead of devices? |
| |
| | | Forum Member
Group: Forum Members
Last Login: Today @ 2:12:00 PM
Posts: 48, Visits: 409 |
| carlo88 (10/9/2008)
Hi, I am trying to create a world map for our networked sites. I need to dynamically query all folders and their devices in Whatsup. What would the SQL query look like to retrieve device groups/folders from Whatsup.
--
carlo
Here is a query to list all the groups and devices, but I don't think you can use it to create a dynamic query:
SELECT DeviceGroup.sGroupName, Device.sDisplayName
FROM Device, DeviceGroup, PivotDeviceToGroup
WHERE PivotDeviceToGroup.nDeviceID = Device.nDeviceID AND PivotDeviceToGroup.nDeviceGroupID = DeviceGroup.nDeviceGroupID AND Device.bRemoved=0 |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 11/21/2008 11:36:18 AM
Posts: 113, Visits: 133 |
| | That worked great, except now they would need to be grouped. All devices under the same folder. Perhaps this is not feasible with WU. |
| |
|
|