RE: [WhatsUp Forum] Applying Actions to Multiple Devices

[Wittke, Marc]

Title: RE: [WhatsUp Forum] Applying Actions to Multiple Devices

try query express

 

http://www.albahari.com/query%20express.html

 

it's a freeware "query analyzer" missing all those query optimizing tools. for just accessing the db it is just right, if you got the basics from sql

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff Cook
Sent: Monday, November 22, 2004 1:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices

My understanding was that the desktop version that WUP runs does not allow network connections.  If it does then you are correct I can use Access from my desktop to get to it.  Does anyone know if you can get to the WUP database form a remote computer.

 

Thank You

---

From: [EMAIL PROTECTED] on behalf of Eugene Pressley
Sent: Fri 11/19/2004 6:29 PM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices

The data is stored in an SQL database, you can query it from any
workstation with proper permissions.

>>> [EMAIL PROTECTED] 11/19/2004 7:14:44 PM >>>
Oh, but there we go again installing MS Office on a server.

Jeff Cook
Network Administrator
Whatcom Educational Credit Union


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Eugene
Pressley
Sent: Friday, November 19, 2004 4:10 PM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices


For basic DB access MS Excel would work.

>>> [EMAIL PROTECTED] 11/19/2004 7:05:22 PM >>>
What other options are out there to connect to the database except
purchasing and installing MS Access onto one of my servers?  I have
found a few products that will let me view the database without a
large
program.  However I have not found one that will let me edit. 

Thank You


Jeff Cook
Network Administrator
Whatcom Educational Credit Union


-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Steve
Warnock
Sent: Thursday, November 18, 2004 7:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices



Most of that information is in the table called Device in the
database.
   It might be best for you to create a blank MS Access database and
then link the Whats Up database to that via a DSN.    Then you can use
the Device table just like a Access database and easily make queries
against it.   



I would caution not to change anything unless you absolutely know what
it is.    I noticed the Device Type is a number in the database so you
need to find the corresponding number.    



I was able to quickly create a query and change over 500 SMNP
communities this way in about 1 minute (the time it took to write the
query). 



I think will some experience with the database,  the multiple select
issue becomes very minor. (IMO)



Thanks,

Steve Warnock

Advanced Computer Connections

419-668-4080




  _____ 


From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of David
Summers
Sent: Thursday, November 18, 2004 10:24 AM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices



I just spoke with support and they have identified this as something
they are working on, hopefully for SP1.  I still need to modify the
properties of several devices at once, i.e. SNMP communities, device
types, actions, dependencies.



If there is anyone who knows the database way of doing this, then
please let me know.  I am not a DBA and really only work with
databases
in a limited way.  Please let me know how to do this.



Thanks,



David Summers
214.706.1147


  _____ 


From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Steve
Warnock
Sent: Wednesday, November 17, 2004 2:30 PM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices



I remember reading that some of this will be addressed in a service
pack.  Until then,  can't you access the database directly and make
multiple changes there en mass?



Thanks,

Steve Warnock

Advanced Computer Connections

419-668-4080




  _____ 


From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Auger,
Jay (IS)
Sent: Wednesday, November 17, 2004 11:14 AM
To: [EMAIL PROTECTED]
Subject: RE: [WhatsUp Forum] Applying Actions to Multiple Devices



Also, how about the ability to change the properties of multiple
devices at once.  For instance, i am going through (1 by 1) and
changing
the devices types from the default of 'Workstation' to what they
actually are.  If I could select multiple it would save a lot of
time...



Jay






  _____ 


From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of David
Summers
Sent: Wednesday, November 17, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: [WhatsUp Forum] Applying Actions to Multiple Devices

I would like to know if there is any way to apply an action or action
policy to multiple devices at once.  I need to apply the same action
for
up/down alerting to over 200 devices.  In WUG, you could apply an
alert
to multiple devices at once.  Where has that feature gone.



David Summers
Network Analyst, Information Technology

American Heart Association
National Center
7272 Greenville Avenue
Dallas, Texas 75231-4596
214.706.1147
214.706.1211 FAX
[EMAIL PROTECTED] < mailto:[EMAIL PROTECTED]>

"With a fool no season spend, lest ye be counted as his friend."




Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.

An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/

Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.

An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/


Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.

An Archive of this list is available at:
http://www.mail-archive.com/whatsup_forum%40list.ipswitch.com/