#!/bin/bash
current_date=`date +%d-%m-%Y_%H.%M.%S`
Date=`date +%d%m%Y`
Lfriday=`date +%d%m%Y -d last-friday`
RootPath=/var/domaincount/com
mysql zonefile<<EOFMYSQL || echo "query failed" | sendmail 'username@where'
CREATE TABLE com$Date(domain VARCHAR(255),col2 VARCHAR(255),col3 VARCHAR(255),col4 VARCHAR(255),id INT(25) NOT NULL AUTO_INCREMENT, KEY (id));
LOAD DATA INFILE '$RootPath/$today.com' INTO TABLE com$Date FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n';
delete from com$Date limit 35;
delete from com$Date order by id desc limit 2;
select count(distinct(SUBSTRING_INDEX(domain, '.',-1))) from com$Date INTO OUTFILE '$RootPath/$today.count';
select count(distinct(SUBSTRING_INDEX(a.domain, '.',-1))) from com$Date a, com$Lfriday b where a.domain=b.domain INTO OUTFILE '$RootPath/$today.overall';
EOFMYSQL
To have sendmail, you have to have an MTA of some sort installed. If you have none and don't want to bother setting up a mail server, ssmtp is a simple stub of a mailserver that only sends, and sends by logging in as a mail client to something else.
hi all,
have a script which i am using to generate a log file. i use "touch out.log" command to create the file and later on i want to echo lines to this file.
for some reason it keeps giving me this error when i try and create the file ;
touch: out.log cannot create
i have... (3 Replies)
hi,
How to create a log file of a script. Like spool does .
I want to create a log file of whatever the script is doing step wise.
like -xvf does or something better then that.
thanks ... (3 Replies)
Hello everybody,
I need some help here to create a script to parse a log file. Here is a sample of the log file :
0x42258940 (Debug) Cache SUMMARY attrs now/668 min/668 max/668.
0x42258940 (Debug) RSVD SUMMARY reserved space max requested/128 MB accounted now/0 MB
0x42258940 (Debug)... (12 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Write an automated shell program(s) that can create, monitor the log files and report the issues for matching... (0 Replies)
I was going write a script from following site.
Unix Shell Script to Execute Oracle SQL Query (link removed)
My configuration setting for oracle XE.
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=XE
but after... (4 Replies)
Hi Guys,
Im a newbie to scripting and have a small assignment. can someone please confirm if the script i have written would work fine as we dont have a test server to test :(
Scenario - copy 2 files from an ftp server (windows) to a linux machine (a perticular folder). run 2 different... (0 Replies)
Plese help I need a urgent requirement.
Ex: test.log
requirement : using shell script I need to archive the log file and nil and the content of (test.log) file to 0 kb
and then in the archive folder log files are name to test.tar
test1.tar
test2.tar
EX:
/home/abc/
test.log ... (1 Reply)
Hi,
I trust that you are well - I'm a bit new into AIX and I've been assigned a task to write a script that will always validate between our two Prod (Prod A and Prod B) environments to confirm which prod we live at. The two environments are exact replicas and this check I need to put in... (5 Replies)
Hi All,
I am really struggling to solve this problem, this might be small but I am not able to, can somebody help me?
I have few directories and these directories receives text files in large amount with in fraction of seconds. So I just want to send all the files in current directory to... (2 Replies)
Hi,
I need to develop a bash script to create customized report from the server log (red hat 5.8 64 bit Operating system). The following is one of the log for our internal application task.
<2015.03.03 20:09:52 274 +0800><I><DSCTH01><http-0.0.0.0-443-2><security> GUI request succeeded for... (1 Reply)
Discussion started by: pugazhendhi_r
1 Replies
LEARN ABOUT DEBIAN
ost_date
ost::Date(3) Library Functions Manual ost::Date(3)NAME
ost::Date -
The Date class uses a julian date representation of the current year, month, and day.
SYNOPSIS
#include <numbers.h>
Inherited by ost::DateNumber, and ost::Datetime.
Public Member Functions
Date (time_t tm)
Date (tm *dt)
Date (char *str, size_t size=0)
Date (int year, unsigned month, unsigned day)
Date ()
virtual ~Date ()
int getYear (void) const
unsigned getMonth (void) const
unsigned getDay (void) const
unsigned getDayOfWeek (void) const
char * getDate (char *buffer) const
time_t getDate (void) const
time_t getDate (tm *buf) const
long getValue (void) const
void setDate (const char *str, size_t size=0)
bool isValid (void) const
operator long () const
String operator() () const
Date & operator++ ()
Date & operator-- ()
Date & operator+= (const long val)
Date & operator-= (const long val)
int operator== (const Date &date)
int operator!= (const Date &date)
int operator< (const Date &date)
int operator<= (const Date &date)
int operator> (const Date &date)
int operator>= (const Date &date)
bool operator! () const
Protected Member Functions
void toJulian (long year, long month, long day)
void fromJulian (char *buf) const
virtual void update (void)
A method to use to 'post' any changed values when shadowing a mixed object class.
Protected Attributes
long julian
Friends
Date operator+ (const Date &date, const long val)
Date operator- (const Date &date, const long val)
Date operator+ (const long val, const Date &date)
Date operator- (const long val, const Date &date)
Detailed Description
The Date class uses a julian date representation of the current year, month, and day.
This is then manipulated in several forms and may be exported as needed.
Author:
David Sugar dyfet@ostel.com julian number based date class.
Constructor & Destructor Documentation
ost::Date::Date (time_ttm)
ost::Date::Date (tm *dt)
ost::Date::Date (char *str, size_tsize = 0)
ost::Date::Date (intyear, unsignedmonth, unsignedday)
ost::Date::Date ()
virtual ost::Date::~Date () [virtual]
Member Function Documentation
void ost::Date::fromJulian (char *buf) const [protected]
char* ost::Date::getDate (char *buffer) const
time_t ost::Date::getDate (void) const
time_t ost::Date::getDate (tm *buf) const
unsigned ost::Date::getDay (void) const
unsigned ost::Date::getDayOfWeek (void) const
unsigned ost::Date::getMonth (void) const
long ost::Date::getValue (void) const
int ost::Date::getYear (void) const
bool ost::Date::isValid (void) const
Reimplemented in ost::Datetime.
ost::Date::operator long () const [inline]
bool ost::Date::operator! (void) const [inline]
Reimplemented in ost::Datetime.
int ost::Date::operator!= (const Date &date)
String ost::Date::operator() () const
Date& ost::Date::operator++ ()
Date& ost::Date::operator+= (const longval)
Date& ost::Date::operator-- ()
Date& ost::Date::operator-= (const longval)
int ost::Date::operator< (const Date &date)
int ost::Date::operator<= (const Date &date)
int ost::Date::operator== (const Date &date)
int ost::Date::operator> (const Date &date)
int ost::Date::operator>= (const Date &date)
void ost::Date::setDate (const char *str, size_tsize = 0)
void ost::Date::toJulian (longyear, longmonth, longday) [protected]
virtual void ost::Date::update (void) [protected], [virtual]
A method to use to 'post' any changed values when shadowing a mixed object class. This is used by DateNumber.
Reimplemented in ost::DateNumber.
Friends And Related Function Documentation
Date operator+ (const Date &date, const longval) [friend]
Date operator+ (const longval, const Date &date) [friend]
Date operator- (const Date &date, const longval) [friend]
Date operator- (const longval, const Date &date) [friend]
Member Data Documentation
long ost::Date::julian [protected]
Author
Generated automatically by Doxygen for GNU CommonC++ from the source code.
GNU CommonC++ Sat Jun 23 2012 ost::Date(3)