Menu
▾
▴
[Perfparse-users] SQL Command
|
From: <Ric...@eq...> - 2005-04-11 15:53:12
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0"> <TITLE>SQL Command</TITLE> </HEAD> <BODY> <!-- Converted from text/rtf format --> <P><FONT SIZE=2 FACE="Arial">Hi All,</FONT><FONT FACE="Times New Roman"> </FONT> <BR><FONT SIZE=2 FACE="Arial">My management has requested that I put together a report from the data gathered by PerfParse into an Excel spreadsheet. I have the PHP script that can generate Excel using the PEAR plugin "Spreadsheet_Excel_Writer." But I am not very good at SQL and was hoping I could find an SQL query that would suit my needs. What I want to do is have an SQL query that when given a server / service will request:</FONT><FONT FACE="Times New Roman"> </FONT></P> <P><FONT SIZE=2 FACE="Arial">1. Date / Time</FONT><FONT FACE="Times New Roman"> </FONT> <BR><FONT SIZE=2 FACE="Arial">2. Performance Data</FONT><FONT FACE="Times New Roman"> </FONT> <BR><FONT SIZE=2 FACE="Arial">3. State</FONT><FONT FACE="Times New Roman"> </FONT> <BR><FONT SIZE=2 FACE="Arial">4. Output from the plugin.</FONT><FONT FACE="Times New Roman"> </FONT> <BR><FONT FACE="Times New Roman">What I need is an SQL Query that will output</FONT><FONT SIZE=2 FACE="Arial"> like this:</FONT><FONT FACE="Times New Roman"></FONT> <FONT SIZE=2 FACE="Arial">"2005-04-11 07:30:00","13","0","USERS OK - 13 users currently logged in"</FONT><FONT FACE="Times New Roman"></FONT> <FONT SIZE=2 FACE="Arial">Could you assist with the correct SQL query?</FONT><FONT FACE="Times New Roman"></FONT> <FONT SIZE=2 FACE="Arial">Thanks,</FONT><FONT FACE="Times New Roman"> </FONT></P> <BR> <P><FONT SIZE=2 FACE="Bitstream Vera Sans">Richard Masci<BR> (OSS/I&S/CAS)Network Facing Tools<BR> </FONT> </P> </BODY> </HTML> |
