Sawmill

DOWNLOAD
SAWMILL 8.1.6
free trial!!
Home Products Downloads Purchase Support About About
Sawmill Sawmill

SAWMILLFORUM

Sawmill Discussion Forum

Subject: "Multiple Profiles - One report"     Previous Topic | Next Topic
Printer-friendly copy    
Conferences Pre-Sales Topic #821
Reading Topic #821
Dbarbeiro
Member since Sep-13-10
2 posts
Sep-13-10, 06:19 AM (PDT)
Click to EMail Dbarbeiro Click to send private message to Dbarbeiro Click to view user profileClick to add this user to your buddy list  
"Multiple Profiles - One report"
 
   I am currently evaluating sawmill for usage in several of our customers.

I know you cant have several profiles merge into a meta-profile to make a report, but...

1) if I use external databases, I should be able to get the data I want from the multiple databases sawmill creates.
Question is, do the databases have some field to indicate which machine that data is coming from (in the case of a profile that aggregates webserver logs from many machines, for example)?

2) is there any way to trigger the update of the database for a particular profile BUT not in the sawmill console? The idea being that you would hit a button on a portal to update the database log for a particular profile. i.e. having a "force refresh" option - be it a command-line option, web button, anything.

3) is the above update a "smart" update - i.e. will sawmill only read and process NEW entries in the log, or will it read the ENTIRE log then process that?


What we want is the following: Having some sort of event (lets say, mail server is down), being able to have a user generate _something_ that can show all logs on the machine (or group of machines, in case of a webserver with redundancy and load-balancing). However these logs would be mailserver logs, windows event logs, etc.

Usually, the user would work like this:
1) Some service, hosted by MachineA goes down.
2) user forces an update of the database for MachineA - sawmill reads the sysLog, downedServiceLog, someOtherLog for MachineA (or in case that isnt possible, for all logs of those types).
3) A view is generated to show the past-hour (or so) of log entries for Machine A, of all log types that are monitored (sysLog, downedServiceLog, someOtherLog).

I believe you can easily view the usefullness of this.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
Ag2000CO
Member since Jan-24-10
37 posts
Sep-14-10, 07:11 AM (PDT)
Click to EMail Ag2000CO Click to send private message to Ag2000CO Click to view user profileClick to add this user to your buddy list  
1. "RE: Multiple Profiles - One report"
In response to message #0
 
>3) is the above update a "smart" update - i.e. will sawmill
>only read and process NEW entries in the log, or will it
>read the ENTIRE log then process that?

Sticking to what I know: Yes it is a smart update, processing only new records in the the log file.

Lou

Say what you will about Sisyphus. He always has work.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
dgilmoreadmin
Member since Nov-18-04
3500 posts
Sep-16-10, 10:57 AM (PDT)
Click to EMail dgilmore Click to send private message to dgilmore Click to view user profileClick to add this user to your buddy list Click to send message via AOL IM  
2. "RE: Multiple Profiles - One report"
In response to message #1
 
Hi-

If you are querying the database directly vs. using Sawmill you can get access to the data. I'm not exactly sure what you mean by which machine, or device the data comes from, but I suspect that within the log data there's access to this within a particular field.

As for the updating or refreshing the stats, there are many ways to have Sawmill update it's database. You can setup an automated schedule that will update the database at a particular time, or you can run a command line to update the database directly.

David
Sawmill Product Support Team
support@flowerfire.com


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top
Dbarbeiro
Member since Sep-13-10
2 posts
Sep-20-10, 02:15 AM (PDT)
Click to EMail Dbarbeiro Click to send private message to Dbarbeiro Click to view user profileClick to add this user to your buddy list  
3. "RE: Multiple Profiles - One report"
In response to message #2
 
   Thank you.
Questions:
1) - Ok, I guess Ill have to datamine a bit and figure out where the machine's ID is in the database.

2) - Didnt know of the command-line option, but that is great indeed. I can have a little script that fetches the logs then force-updates the database so I can get an updated database whenever I need (say.. when things start to break).

3) I already suspected as much, a "smart" update. Just wanted to make sure.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote | Top

Conferences | Topics | Previous Topic | Next Topic
© 2010 Flowerfire | Copyright | Privacy Policy | License Agreement | Terms of Use | Contact | Feedback | About
Sawmill Software
Sawmill Software
Back to Sawmill Home