This isn't ready for public consumption quite yet, but I wanted to give you guys a peek of what I'm working with for my next set of web templates.
Go to: http://www.brentozar.com/SangfroidJr/default.asp You'll see two groups of servers, Dallas and Local. Click on "Show All Checks" for the Local group, and it shows all of the checks in that group. No big news there. But click on an individual check - let's say BrentOzar.com [W], which is my web server. You can see the most recent records from ServersAlive's Stats and Interchange tables, and you can click View All next to either one to see all of the related records. Below the Most Recent stuff, you'll see a list of related links. You can set up related links for each check - in this case, you're looking at my MRTG bandwidth chart for this server, the Motherboard Monitor temperature report for it, and the Monitored Page, which is the page SA checks for this server. The MRTG data is limited because I just reinstalled MRTG due to moving a drive around, long story. If you're not familiar with MRTG, it's a free Perl package that graphs traffic using SNMP: http://people.ee.ethz.ch/~oetiker/webtools/mrtg/ Motherboard Monitor is a free Windows program to monitor motherboard temps, fan speeds, etc: http://mbm.livewiredev.com Anyway, this web reporting will integrate with pretty much anything that has a web link or produces web images. I'll put it up on my ServersAlive tips & tricks page, probably tomorrow night, after I put some more work into it. Right now it only works with SQL because of some problems I had with ODBC logging, but I should have that fixed tomorrow. Plus, you can click on Log Search at the left side of the page and search by date or by keyword. I've only got a few days of data in there, since 3/19/2003, and it's chock full of errors because I've been doing a bunch of testing with different builds. The look and feel of it is in two files, a header and a footer, and the colors are done with CSS, so it's pretty easy to modify. The downside is that it requires the Enterprise Edition of SA, because it runs off ODBC, but Dirk's been kind enough to work on an updated build of SA that will let us do URL links in other versions of SA as well. More on that later - it's naptime. :-D Brent -- BrentO Famous Last Words #32: "We hire Orcus to be our guide..." To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
