I have written one script which connects to MYSQL database, fires one select query and send the results over an email, if there is any Output.
But the Output which I am receiving over email is in text format. I need to get it dispalyed in tabular format to ensure better readability. Below is the script I have tried and the sample email what I am receiving:
Code:
#!/bin/bash
#MAILTO="sambit.sahu@niceactimize.com"
mysql test -e "select c.CenterID,a.MIC,c.ExchangeName,a.CountryCode,a.EventDate,a.EventDayOfWeek,b.eventName from exch_calendar_event a left join exch_calendar_eventName b on a.EventID=b.ID left join exch_calendar_mic c on a.MIC=c.MIC where EventDate=DATE_FORMAT(20170811,'%Y%m%d') order by a.MIC;" > file.tmp
if [ -s file.tmp ]
then
mailx -s "Holiday" $MAILTO <file.tmp
fi
rm file.tmp
Below is the output, what I am receiving over mail. I want to convert it into tabular format with adding HTML formatting.
Code:
CenterID MIC ExchangeName CountryCode EventDate EventDayOfWeek eventName
706 XTKS Tokyo Stock Exchange JP 20170811 Fri Mountain Day
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 08-17-2017 at 06:08 AM..
Reason: Added CODE tags.
hello all. I was hoping someone may have an idea or two.
I'm throwing together a shell script that does a lot of application and system level data collection. The idea is is you run it before/after restarting an application for later analysis. A lot of stuff is collected... resource stats,... (4 Replies)
I have a html file called myfile. If I simply put "cat myfile.html" in UNIX, it shows all the html tags like <a href=r/26><img src="http://www>. But I want to extract only text part.
Same problem happens in "type" command in MS-DOS.
I know you can do it by opening it in Internet Explorer,... (4 Replies)
I am trying to use shellinabox as a terminal emulator. Everything is working except there seems to be no way to simulate an F14 button press in shellinabox. I am already embedding shellinabox in an html page so Im am wondering if there is a way to make an html/js button that will pass F14 to the... (0 Replies)
Hi there..
I need a proper "mutt" command to send a mail with html body and html attachment at a time.
Also if possible let me know the other commands to do this task.
Please help me.. (2 Replies)
Hi I have a file as given below:
<table border=1>
<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>
<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>
<TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally... (1 Reply)
I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes .
The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (0 Replies)
I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes .
The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (7 Replies)
I tried to find elegant (or at least simple) way to remove all but couple of html tags from html file, but all examples I found dealt with removing all the tags.
The logic of the script would be:
- if there is <li> or <ul> on the line, do nothing (=write same line to output)
- if there is:... (0 Replies)
Hi all:
Been racking my brain on this for the last couple of days and what has been most frustrating is that this is the last piece I need to complete a project.
There are numerous posts discussing mutt in this forum and others but I have been unable to find similar issues.
Running with... (1 Reply)
Hi,
I have a .sh file, to email a report of our backups from a linux machine. It looks like this (minus a few bits):
echo "HELO $host.$domain"
sleep 1
echo "mail from: vdrreport@$domain"
sleep 1
echo "rcpt to:$mailto"
sleep 1
echo "data"
sleep 1
echo "subject: $host VDR-Report... (2 Replies)
Discussion started by: cognito
2 Replies
LEARN ABOUT CENTOS
hwloc_intel_mic_get_device_cpuset
Intel Xeon Phi (MIC) Specific Functions(3) Hardware Locality (hwloc) Intel Xeon Phi (MIC) Specific Functions(3)NAME
Intel Xeon Phi (MIC) Specific Functions -
Functions
static inline int hwloc_intel_mic_get_device_cpuset (hwloc_topology_t topology , int idx , hwloc_cpuset_t set)
static inline hwloc_obj_t hwloc_intel_mic_get_device_osdev_by_index (hwloc_topology_t topology, unsigned idx)
Detailed DescriptionFunction Documentation
static inline int hwloc_intel_mic_get_device_cpuset (hwloc_topology_t topology, int idx, hwloc_cpuset_tset) [static]
Get the CPU set of logical processors that are physically close to MIC device whose index is idx. Return the CPU set describing the
locality of the MIC device whose index is idx.
Topology topology and device index idx must match the local machine. I/O devices detection is not needed in the topology.
The function only returns the locality of the device. If more information about the device is needed, OS objects should be used instead,
see hwloc_intel_mic_get_device_osdev_by_index().
This function is currently only implemented in a meaningful way for Linux; other systems will simply get a full cpuset.
static inline hwloc_obj_t hwloc_intel_mic_get_device_osdev_by_index (hwloc_topology_ttopology, unsignedidx) [static]
Get the hwloc OS device object corresponding to the MIC device for the given index. Return the OS device object describing the MIC device
whose index is idx. Return NULL if there is none.
The topology topology does not necessarily have to match the current machine. For instance the topology may be an XML import of a remote
host. I/O devices detection must be enabled in the topology.
Note:
The corresponding PCI device object can be obtained by looking at the OS device parent object.
Author
Generated automatically by Doxygen for Hardware Locality (hwloc) from the source code.
Version 1.7 Sun Apr 7 2013 Intel Xeon Phi (MIC) Specific Functions(3)
08-17-2017
