RE: [SA-list] question regarding quotes in the SQL statement of the ODBC Com check

2004-03-16 Thread Brent G. Ozar
Hmm - try using square brackets like [Count] instead of the single quotes and see what happens. Brent Ozar - UniFocus "Stoop and you'll be stepped on; stand tall and you'll be shot at." Carlos A. Urbizo -Original Mes

RE: [SA-list] Logging in to website

2004-02-04 Thread Brent G. Ozar
Assuming your extranet is database-driven, use a separate database-driven page that doesn't require login - say, called, /serversalive.asp. That page should do a simple database query that should always return data. In my case, I do a select sum(1) from our clients table - which should always

RE: [SA-list] Monitoring the monitoring software

2004-01-28 Thread Brent G. Ozar
set that up as an external check some how to have SA look at the webpage that is generated? I can't think of a way to do it with SA's built in web check. That sounds like an ideal method just to be able to keep a watch on it...     Thanks   Jesse. From: Brent G. Ozar [

RE: [SA-list] On Call Rota

2004-01-28 Thread Brent G. Ozar
Title: RE: [SA-list] On Call Rota The way we do it is to set up all alerts for every check, and use teams.  Every check has an email, MSN, ICQ, and AIM alert on it for the default team.   Then, each user can have their own alerting preferences for different hours.  For example, I have mine se

RE: [SA-list] Monitoring the monitoring software

2004-01-28 Thread Brent G. Ozar
I have a low-tech method of monitoring it.  I have a "home page" that I leave my browser up on my desktop at all times, and it's set to refresh to itself every 5 minutes.  That page is actually an ServersAlive ASP template (among other things) so I can see how my servers are doing.   The pag

RE: Betr.: [SA-list] Exporting host file to SQL

2004-01-26 Thread Brent G. Ozar
Yeah, actually, I'm thinking about doing something similar to what you're doing: - Create a template that has the fields I need, but a comma-delimited file instead of HTML - At the end of each cycle, have a batch file call a DTS job to import that data into SQL It's extremely duct-tape-y, but it

[SA-list] Exporting host file to SQL

2004-01-23 Thread Brent G. Ozar
Is there a way we could add an additional output to database that would list all of the current checks?  I'm trying to build an uptime page, but when a server has never gone down, it won't show up in the Stats table.  I'd love it if we could have an output table that included the UniqueID, P

RE: [SA-list] Using dial up as alternate SMTP alert

2004-01-12 Thread Brent G. Ozar
Right, that's why we all said to try it manually - meaning, tracerts, pings, etc. Whenever I have connectivity issues, the first thing I do is try to replicate it outside of ServersAlive. If I can verify that the ping/tracert/etc works while SA fails, then it's an SA problem. Otherwise (and usual

RE: [SA-list] Using dial up as alternate SMTP alert

2004-01-12 Thread Brent G. Ozar
Along the lines of Michael's suggestion, I would also try disconnecting the lan, manually connecting the dialup, and doing various ping/tracert manual tests from the command line to make sure the SMTP host was actually reachable over the DUN connection. Brent Oza

RE: [SA-list] DB logging error

2004-01-07 Thread Brent G. Ozar
Ahmed, here's a thought.  Everybody here is more than willing to help you, but you gotta put in a little effort.  Time after time, I see you whining about why things don't work, but you won't read manuals and won't take troubleshooting steps that people suggest.    Dirk, the author of a sof

RE: [SA-list] URL Testing and template code

2003-12-19 Thread Brent G. Ozar
What web server are you using for your template? If you're using Microsoft IIS, you can write VBscript code to modify SA's default output for any tag and modify it. If you email me the template code offlist, I can probably code it pretty easily. Brent From

RE: [SA-list] Check Webpage For Value

2003-12-15 Thread Brent G. Ozar
If you "own" the web page, and you can put some ASP (or whatever language) code into it, it'd be pretty easy. Can you change the content, and what language is it in? Brent -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Sent: Sunday, December 14,

RE: [SA-list] and you thought some of the other ideas were weird....

2003-12-08 Thread Brent G. Ozar
uot; Where his screen shot is captured as a image. If he made a CRC of the image for either both the good or the good and bad. Then it may work. Any way just ramblings of a Mad Man. Davey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent G. Ozar Sent

RE: [SA-list] and you thought some of the other ideas were weird....

2003-12-08 Thread Brent G. Ozar
He's not talking about a web page, but rather a Windows program. Brent Brent Ozar - UniFocus "Kids, this is a message from your Uncle Billy. Don't buy drugs. Become a pop star, and they give them to you for free!" Billy

RE: [SA-list] and you thought some of the other ideas were weird....

2003-12-05 Thread Brent G. Ozar
Does the window title of the application change? If so, you can use a program like Winbatch to monitor for certain window titles, like any that contain "My Program Name - Error" and have Winbatch do certain things that would trigger an SA alert. Brent Ozar - Uni

RE: [SA-list] Configuring a feature or maybe a feature request

2003-12-05 Thread Brent G. Ozar
I think he means if a check is on maintenance for X hours, he wants to be alerted. Brent Ozar - UniFocus "Kids, this is a message from your Uncle Billy. Don't buy drugs. Become a pop star, and they give them to you for free!"

RE: [SA-list] SMTP alerts

2003-12-04 Thread Brent G. Ozar
Here comes the web developer again. :-D Here's what I would do: create a web template that only shows the down checks. This template could be HTML, or for that matter, it could be plain text. Then, send the contents of the file using Postie, my favorite command-line email tool: http://www.infr

RE: [SA-list] New type of check?

2003-11-21 Thread Brent G. Ozar
O!  Even better.  Good one.   Brent Ozar - UniFocus "All of a sudden you're a black man, then you're Diana Ross,  now you're Audrey Hepburn.  Then he's got the little beard  going on.  He's like Lord of the Rings, the e

RE: [SA-list] New type of check?

2003-11-21 Thread Brent G. Ozar
t] New type of check? Our prod servers must be physically logged in... we have the registry set to clear the last used userid and such these are all servers,  NT 4.0 & Win2K. Our security gestapo have an issue with auto-logged in servers...  guess I do too...   Greg

RE: [SA-list] New type of check?

2003-11-21 Thread Brent G. Ozar
What do you mean by "logged in"?  Is this a server OS, or a workstation OS?  Does a user have to physically log in, or is it using a TweakUI-style utility to automatically log in a user?       Brent Ozar - UniFocus "All of a

RE: [SA-list] Database Logging

2003-10-31 Thread Brent G. Ozar
Hi, Jim! I'd definitely be interested. I've been logging to SQL since v4 came out, and loving every minute of it. I've written a low-end system to do some basic reading out of the log database - it's listed as the last template in my set at http://www.brentozar.com/salive/ - and I enjoy playi

RE: [SA-list] sa_group_name variable problems...

2003-10-28 Thread Brent G. Ozar
t Quinn -----Original Message- From: Brent G. Ozar [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 13:51 To: [EMAIL PROTECTED] Subject: RE: [SA-list] sa_group_name variable problems... For a list of most of the tags (not including some that have been added in beta versions), you can look at

RE: [SA-list] sa_group_name variable problems...

2003-10-28 Thread Brent G. Ozar
Also, almost forgot - you probably want to go to beta.woodstone.nu and grab the latest version. It's got a lot of cool new template tag improvements. You can install it without losing functionality or anything like that - it's just a straight upgrade over the old one. -

RE: [SA-list] sa_group_name variable problems...

2003-10-28 Thread Brent G. Ozar
For a list of most of the tags (not including some that have been added in beta versions), you can look at the SA manual, also available online here: http://www.woodstone.nu/salive/doc/html/ The way you're trying to use the tag won't work because the tag is only valid inside a group header. He

RE: [SA-list] salive and VPN

2003-10-27 Thread Brent G. Ozar
This is where the SA dependencies are helpful. You set up one basic ping check to make sure the VPN is up, then you can set your other checks to depend on that check. That way, when the VPN link fails, you don't get 50 different alerts for remote machines when the real problem is just the VPN lin

RE: [SA-list] salive and VPN

2003-10-27 Thread Brent G. Ozar
At the risk of sounding flippant, Gene, instead of asking us what's important to your business, it would probably be better to tell us what's important to your business, and then asking us how to monitor it. For example, if I just ask you guys what I should monitor here at my company, I'd get a th

RE: [SA-list] salive and VPN

2003-10-27 Thread Brent G. Ozar
And we'll answer it again: yes, lots of us are. RealVNC is not a VPN. If you've got specific questions, like "How do I set up a VPN from one office to another?" we can definitely point you toward resources, but the question here is kind of general because there are dozens and dozens of VPN product

RE: [SA-list] Dreaming of features for version 5.....

2003-10-27 Thread Brent G. Ozar
Just a thought: you can create XML files with ServersAlive that accomplish the 3rd part, and use those as a datasource for most modern programming languages & web scripting languages. I've got an example on my tutorials at http://www.brentozar.com/salive/default.aspx of how to do it. I'm not show

RE: [SA-list] Statistical database question....

2003-10-24 Thread Brent G. Ozar
But you don't want to build reports around the up/down numbers. Remember, you can change check frequencies, like have 2 minutes per check during 8am-6pm, 5 minutes per check off hours and weekends. Plus, different checks can have different frequencies (some checks are only done once every 3-4-5 pa

RE: [SA-list] Stats

2003-10-23 Thread Brent G. Ozar
They always get reset. If you want real accuracy, what you really want to do is use the Enterprise version and log to SQL, so you can run trending reports. Brent -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Fowkes Sent: Thursday, October 23, 2

RE: [SA-list] Monitoring SA

2003-10-22 Thread Brent G. Ozar
-- Brent Ozar - UniFocus -------- "Aluminum to me, aluminium to some You can shine like silver all you want But you're just aluminum." Barenaked Ladies, Aluminum -Original Message- From: [EMAIL PROTECTED] [mailto:[EM

RE: [SA-list] Monitoring SA

2003-10-22 Thread Brent G. Ozar
Interesting idea! You could do it with an ASP web template pretty easily. You can add the below code to an existing template, or add a new one with just this code, which checks to see if the template has been updated in the last 15 minutes: <% Dim intMinSinceLastCheck intMinSinceLastCheck = Date

RE: [SA-list] SMTP mail problem

2003-10-22 Thread Brent G. Ozar
The SMTP server you're using in SA probably refuses to forward messages to VZW.  Try checking the "Send Direct" mail in the ServersAlive SMTP setup screen.   Refusing to forward for other domains is a pretty common effort to stop spam.   Brent     Brent Oza

RE: [SA-list] Wish List - Multiple threads for servers alive

2003-10-22 Thread Brent G. Ozar
-- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brent G. Ozar Sent: Tue Oct 21 11:58 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Wish List - Multiple threads for servers alive I hate to disagree with you about your own program, but per this page: http://www.woodstone.nu/saliv

RE: [SA-list] Templates

2003-10-22 Thread Brent G. Ozar
arted = What am I doing wrong? Thanks in advance!! Regards Mark -Original Message- From: Brent G. Ozar [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 12:32 To: [EMAIL PROTECTED] Subject: RE: [SA-list] Templates Hi, Mark! I'm the guy who wrote the templates. On the page

RE: [SA-list] Templates

2003-10-22 Thread Brent G. Ozar
Hi, Mark! I'm the guy who wrote the templates. On the page you linked to, I've got several tutorials that explain how the ASP code works, but I guess I'm missing some basic info. There's a great getting-started tutorial about ASP at http://webproasp.com/webproasp-27-20030211A-Beginners-Guide-t

RE: [SA-list] Wish List - Multiple threads for servers alive

2003-10-21 Thread Brent G. Ozar
I hate to disagree with you about your own program, but per this page: http://www.woodstone.nu/salive/purchase.asp "With the Standard Edition you can check upto 1000 entries, with the Enterprise Edition upto 5000 entries. The Enterprise edition also includes ODBC logging (direct logging to a data

RE: [SA-list] Wish List - Multiple threads for servers alive

2003-10-21 Thread Brent G. Ozar
Title: Message N, no no no.  Mind your language.  You should never use the FF word in public.  Use XML, you naughty boy.     Brent Ozar - UniFocus A man is known by the company he avoids.   From: [EMAIL PROTECTED] [ma

RE: [SA-list] Wish List - Multiple threads for servers alive

2003-10-21 Thread Brent G. Ozar
Title: Message The easy way to do this is to run VMware from www.VMware.com.  You can run multiple instances of operating systems on a single machine, so for example you can have 3 different Windows versions running simultaneously on the same box.   It's not cheap, but the great part is that

RE: [SA-list] Wish List - Multiple threads for servers alive

2003-10-21 Thread Brent G. Ozar
Send Dirk $179, and he'll tell you how. ;-) Brent Brent Ozar - UniFocus A man is known by the company he avoids. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook Sent: Tues

RE: [SA-list] Installing Servers Alive via Terminal Services

2002-11-21 Thread Brent G. Ozar
Actually, it depends on the Terminal Services mode. If Terminal Services is installed in Administrator Mode (meaning only 2 users can be logged in simultaneously), then Windows doesn't map the home directories like that. You can install it just fine in Admin Mode. I office out of Houston, all

RE: [SA-list] ServersAlive and Exchange Server 5.5

2002-10-30 Thread Brent G. Ozar
Title: ServersAlive and Exchange Server 5.5 Works great for us with both Exchange 5.5 and 2000, but remember that if you’re trying to send an email to domainA.com and your Exchange server is domainB.com, if you have relaying turned off then it won’t work.     -

RE: [SA-list] Service Monitor Failure

2002-10-28 Thread Brent G. Ozar
Title: RE: [SA-list] SMTP setup Have you let it run through a few updates?  If you’ve got dependencies, and you’re checking the dependent items first, then it may take a few passes through the updates to get them marked as available again.   Ideally, if you’ve got a check that other thin

RE: [SA-list] Bar graphs for disk space

2002-10-25 Thread Brent G. Ozar
dennis.uxb.net/ -Original Message- From: [EMAIL PROTECTED] [mailto:salive-owner@;woodstone.nu]On Behalf Of Brent G. Ozar Sent: Thursday, October 24, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Bar graphs for disk space Wooo! Due to instant demand, I just went ahead and put my template

RE: [SA-list] v4 request

2002-10-25 Thread Brent G. Ozar
ve-owner@;woodstone.nu]On Behalf Of Brent G. Ozar Sent: Fri Oct 25 4:41 AM To: [EMAIL PROTECTED] Subject: RE: [SA-list] v4 request HAHAHAHAHA, ah-thankyou, ah-thankyouverramuch. If that blows you away, just wait til SA4 comes out. I'm building a web-based help desk system that integrates wit

RE: [SA-list] v4 request

2002-10-24 Thread Brent G. Ozar
rent Ozar - UniFocus "Don't wear rollerskates to a tug-of-war." Larry Wall -Original Message- From: Roland Gaspar [mailto:rgaspar@;patlq.com] Sent: Thursday, October 24, 2002 9:35 PM To: Brent G. Ozar; [EMAIL PROTECTED] Subject: RE: [SA-list] v4 request No no no no

RE: [SA-list] v4 request

2002-10-24 Thread Brent G. Ozar
[SA-list] v4 request   Holy brackets BatMan ;-) Very slick!   -----Original Message- From: Brent G. Ozar [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 10:19 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] v4 request Wooohoo!  Here we go.  Dynamic filtering

RE: [SA-list] v4 request

2002-10-24 Thread Brent G. Ozar
n order for these bar graphs to work. Have you managed to correct this?  Because I think I have but something else is flaky and not working as I expected.  I'll let you know shortly. - Mark > -Original Message- > From: Brent G. Ozar [mailto:[EMAIL PROTECTED]] > Sent:

RE: [SA-list] v4 request

2002-10-24 Thread Brent G. Ozar
Mark, I tell ya, you're just a fountain of inspiration. (Just FYI, I added pie charts to my examples at http://www.brentozar.com/salive.) It'd actually be pretty easy to create multiple pages out of just a single SA template page. I can think of two ways off the top of my head: by using the SA r

RE: [SA-list] Bar graphs for disk space

2002-10-24 Thread Brent G. Ozar
intStart-1))) intGreen = Round(intResponse / intFullSize * 100,0) intRed = 100 - intGreen Response.Write("") Response.Write("") End If %> ServersAlive Version 3.3.1135. 1 cycles since started. "Brent G. Ozar" <[EMAIL PROTECTED]>@woodstone.nu on 24/10/2002

RE: [SA-list] Bar graphs for disk space

2002-10-24 Thread Brent G. Ozar
Gaskell@;eu.fmo.com] Sent: Thursday, October 24, 2002 5:43 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Bar graphs for disk space Brent, I have tried you template with 1 check. I can't seem to get it to work. The bar chart box appears blank. Is there something I am doing wrong or doe

RE: [SA-list] Bar graphs for disk space

2002-10-24 Thread Brent G. Ozar
ace Looks good. I'd like a copy of your template. p.s. the link to your tips gives 404!! -----Original Message- From: Brent G. Ozar [mailto:brento@;brentozar.com] Sent: 24 October 2002 12:54 To: [EMAIL PROTECTED] Subject: [SA-list] Bar graphs for disk space OK, Mark, here's the

RE: [SA-list] Bar graphs for disk space

2002-10-24 Thread Brent G. Ozar
From: Mike Tree [mailto:mike.tree@;clever4.net] Sent: Thursday, October 24, 2002 7:03 AM To: '[EMAIL PROTECTED]' Subject: RE: [SA-list] Bar graphs for disk space Looks good. I'd like a copy of your template. p.s. the link to your tips gives 404!! -----Original Message- From

[SA-list] Bar graphs for disk space

2002-10-24 Thread Brent G. Ozar
OK, Mark, here's the full answer, assuming your web server (that's serving up the SA report template) can handle VBscript ASP. You'll want to name the output file with an .asp extension, like default.asp, so that the web server knows to process the logic. The objective here is to end up with a re

RE: [SA-list] v4 request

2002-10-23 Thread Brent G. Ozar
Mark - what a brilliant idea! I couldn't go to bed until I worked it out! I'll post a more detailed message tomorrow, but the ServersAlive HTML template I'm using is here: http://www.brentozar.com/salive/explanation.aspx To see an example of what it looks like, go here and look at the last chec

RE: [SA-list] v4 request

2002-10-23 Thread Brent G. Ozar
Why don't you set up dependencies? I've got a similar situation (on a much smaller scale) and I set up a ping check for each server. All of the other checks for that particular server are dependent on the ping check. If I put the ping check into maintenance, then they all go into maintenance.

RE: [SA-list] v4 prerelease screenshots

2002-10-23 Thread Brent G. Ozar
Looks great! Can't wait to get it! Brent Ozar - UniFocus "I think it's a new feature. Don't tell anybody it was an accident." Larry Wall -Original Message- From: Dirk Bulinckx [mailto:dirk@;woodstone.nu] Sent: We

RE: [SA-list] URL check

2002-10-23 Thread Brent G. Ozar
Try using the full page name that gets returned, such as /Katalog/default.jsp or whatever the page name is. Brent Ozar - UniFocus "I feel like a fugitive from the law of averages." William H. Mauldin -Original Message

RE: [SA-list] Reporting

2002-10-22 Thread Brent G. Ozar
There's no reporting tool for the checks and dependencies right now other than the built-in HTML reporting in ServersAlive, which can be set up to show a little info on the check. Brent Ozar - UniFocus "I think it's a new feature.

RE: [SA-list] Exchange Monitoring

2002-10-21 Thread Brent G. Ozar
Check out the external check samples at http://www.woodstone.nu/salive/addons.asp for the SMTP2POP3 check, which basically sends a message via SMTP then checks to make sure it arrived via POP3. That would address the issue, I bet. Brent Ozar - UniFocus --

RE: [SA-list] scheduled, positive "I'm here" message

2002-10-18 Thread Brent G. Ozar
It's actually really easy to do. Set up a web page that returns "ALIVE" all the time except at whatever time you want to check, and at that time it should return "EMAIL" (or whatever else you want to say, as long as it's not "ALIVE"). In pseudocode, it would look like this: If timenow >= 7:55 AM

RE: [SA-list] scheduled, positive "I'm here" message

2002-10-18 Thread Brent G. Ozar
. And if it's running at 8am, SA should send a mail saying that it's running. (and I suppose that if it's not running at 8am that you want a mail saying that it's not running?) dirk. -----Original Message- From: [EMAIL PROTECTED] [mailto:salive-owner@;woodstone.nu]On

RE: [SA-list] scheduled, positive "I'm here" message

2002-10-18 Thread Brent G. Ozar
just like a stroll in the park. Jurassic Park, that is." Larry Wall -Original Message----- From: Brent G. Ozar Sent: Friday, October 18, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] scheduled, positive "I'm here" message Not hard either, believe it or

RE: [SA-list] W2Knews: 2002 Target Award_Winner!

2002-09-25 Thread Brent G. Ozar
WHOO! Congratulations, you deserved it. Brent Ozar - UniFocus "If you can count your money, you don't have a billion dollars." J. Paul Getty -Original Message- From: Dirk Bulinckx [mailto:[EMAIL PROTECTED]]

RE: [SA-list] email options?

2002-09-25 Thread Brent G. Ozar
You can use the People feature to set up multiple people. For example, I use BrentPager and BrentMail, each with their own schedules. (V4 will take care of this more elegantly.) Brent Ozar - UniFocus "No one can possibly achieve

RE: [SA-list]

2002-09-05 Thread Brent G. Ozar
It seems like what we really need is just a special check whenever anyone comes on schedule. When they come on schedule after being off, then run a cycle (or make a note of it for the next cycle) and email them of anything down, regardless of their settings. That introduces a ton of problems, th

RE: [SA-list]

2002-09-05 Thread Brent G. Ozar
Yeah, queuing is definitely not the answer. I don't want to get 20 old emails at 4am when my alerting shift starts, and have all of them be the ones from the last guy's shift. Brent Ozar - UniFocus He does the work of three men

RE: [SA-list] countfiles problems

2002-08-29 Thread Brent G. Ozar
Is the service running under the same account that you’re logged in with?  Meaning, if you’re logged in with your personal account, is the service using that same account?  If it’s not, stop the service, change it to your account, and then start the service again, and see if it works.  If i

RE: [SA-list] countfiles problems

2002-08-28 Thread Brent G. Ozar
I’d have to go with Dirk on this one.  You’ll see it as a rights problem because the account SA is using for the check has either had its password change, or else no longer has permissions on this particular directory.  Happens all the time at our shop when overzealous admins try to lock do

RE: [SA-list] Checking NT Server Times

2002-08-28 Thread Brent G. Ozar
We do something similar with our in-house programs. (We have racks of machines that just sit and do OCR processing all day, and it'd be tough for us to know if they went down. Bear with me, this is actually relevant, hahaha.) Every minute, the in-house OCR program running on each machine update

RE: [SA-list] suggestion - IMs

2002-08-20 Thread Brent G. Ozar
Disclaimer: I'm not affiliated with ServersAlive in any way, but I bet I can answer this, having tried to write some instant-messaging integration stuff in the past. AOL is not an open protocol in any way, shape, or form. They actively try to break any program that directly interfaces with them.

RE: [SA-list] suggestion

2002-08-20 Thread Brent G. Ozar
Ah, yes, premature sending, I know it well. Happens to the best of us, especially when we get this excited. It'll get better as you get older, son. Brent - Brent Ozar - UniFocus - "The towels were so thick the

RE: [SA-list] suggestion

2002-08-20 Thread Brent G. Ozar
Awesome! Here's my first bug reports: On v4-tree-02.jpg, the main screen, the second column in the main window says "Entry's". The proper spelling is "Entries". - Brent Ozar - UniFocus - "You can observe a lot just by watchin'.