|
| | | Forum Newbie
Group: Forum Members
Last Login: 10/2/2008 10:43:34 AM
Posts: 5, Visits: 31 |
| I've got an orphan problem, and this and this don't address it. I was wondering if any one else has seen this or knows a way to fix it:
I was dragging a dynamic non-group folder around on the map and all of the sudden *poof* it's gone. I've looked through every other group/folder and no sign of it or it's devices can be found. The devices DO, however, show up in dynamic groups (unacknowledged, all, etc). I cannot move them from dynamic groups into a new folder, and I cannot delete them from dynamic groups to re-create them again. They're not static objects in a dynamic group, just group-less devices that happen to show up in a few of my dynamic queries. Via the dynamic groups I can get to their dashboard and properties pages, but as far as I know you cannot 'move' devices from that. Is there anything i can do to move/delete these devices?
Thanks! |
| |
| | | Supreme Being
Group: Forum Members
Last Login: 12/1/2008 2:41:31 PM
Posts: 98, Visits: 123 |
| | I had that same problem and ended up having to delete them manually from the database. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 10/2/2008 10:43:34 AM
Posts: 5, Visits: 31 |
| Problem solved. It turns out the group in question magically became it's own parent; that is, in the DeviceGroup table, it's nParentGroupID equaled it's nDeviceGroupID. I updated it's Parent Group to 0 and it re-appeared, along with the invisible groups and devices it held.
Hindsight is always 20/20, and I noticed another way that we most likely could have solved this problem. If you KNOW the group number of the phantom group, it may be possible to reference it with a simple URL:
http://wugserver.company.com/NmConsole/DeviceManagement/DeviceList/DeviceList.asp?DeviceList.nDeviceGroupID=999
. . . where 999 is the problem group. This would at least allow you to delete the orphaned devices, if not the group itself. You can find your nDeviceGroupID number with the following commands:
osql -E -D whatsup
SELECT nDeviceGroupID,sGroupName FROM DeviceGroup
GO
Big thanks to Miken for pointing me to SQL Server Express Utility! |
| |
|
|