RE: [WhatsUp Forum] Bulk Add Active Monitor

[Sean McAnally]

Title: Message

INSERT INTO             [WhatsUp].[dbo].[PivotActiveMonitorTypeToDevice]             (                         [nDeviceID],                         [nActiveMonitorTypeID],                         [nNetworkInterfaceID],                         [bAssumedState],                         [nMonitorStateID],                         [dLastInternalStateTime],                         [nActionPolicyID],                         [nPollInterval],                         [bGatherPerformanceData],                         [bFireActions],                         [bDisabled],                         [bRemoved],                         [sArgument],                         [sComment]             ) SELECT                         [nDeviceID],                         85,                         NULL,                         0,                         5,                         '5/27/2005 8:00:00',                         111,                         1800,                         NULL,                         0,                         0,                         0,                         '',                         '' FROM             [WhatsUp].[dbo].[Device] WHERE             nDeviceTypeID = 64     First, I added the new ActiveMonitor.  I then looked at the new row in PivotActiveMonitorTypeToDevice to obtain the values I needed for the insert.  I wanted to add this monitor to every device of a certain type, so I looked up the DeviceTypeID to use in the query.  You can easily adjust this to do it by group.       From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patel, Kushal Sent: Tuesday, May 31, 2005 8:09 AM To: WhatsUp_Forum@list.ipswitch.com Subject: RE: [WhatsUp Forum] Bulk Add Active Monitor   Can you share your SQL INSERT query out? Do you also insert the device’s location on the page using SQL?   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sean McAnally Sent: Saturday, May 28, 2005 8:41 AM To: WhatsUp_Forum@list.ipswitch.com Subject: RE: [WhatsUp Forum] Bulk Add Active Monitor   I was able to write a SQL INSERT query to do this for me.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Donnelly Sent: Friday, May 27, 2005 4:39 PM To: WhatsUp_Forum@list.ipswitch.com Subject: FW: [WhatsUp Forum] Bulk Add Active Monitor   Sean,   No Bulk add, but a Discovery will find new monitors. You could create an Active Discovery and run that and it will present you with a list of new devices/monitors and when you approve it, they will be added. May take a few minutes to run the discovery...and not quite as simple as Bulk change, but easier than doing it by hand...   Daniel Donnelly   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Sean McAnally Sent: Friday, May 27, 2005 8:43 AM To: WhatsUp_Forum@list.ipswitch.com Subject: [WhatsUp Forum] Bulk Add Active Monitor Is there not a way to add a new monitor to a group of devices without have to do it one at a time?