48 lines
1.9 KiB
Batchfile
48 lines
1.9 KiB
Batchfile
@echo off
|
|
|
|
:MAIN
|
|
echo ^<html^>
|
|
echo ^<head^>
|
|
echo ^<title^>FAI Report^</title^>
|
|
echo ^<meta http-equiv="Content-Type" content="text/html; charset=utf-8"^>
|
|
echo ^<style type="text/css"^>
|
|
echo table {
|
|
echo border-collapse: separate;
|
|
echo border-spacing: 1px;
|
|
echo position: static;
|
|
echo }
|
|
echo th {
|
|
echo background-color: #5182bb;
|
|
echo color: #fff;
|
|
echo border: 1px solid #5182bb;
|
|
echo padding: 5px 10px;
|
|
echo font-size: 14px;
|
|
echo font-family: Consolas;
|
|
echo font-weight: bold;
|
|
echo text-align: left;
|
|
echo }
|
|
echo tr {
|
|
echo border: 1px solid #5182bb;
|
|
echo }
|
|
echo td {
|
|
echo color: #000;
|
|
echo padding: 5px 10px;
|
|
echo font-size: 14px;
|
|
echo font-family: Consolas;
|
|
echo }
|
|
echo ^</style^>
|
|
echo ^</head^>
|
|
echo ^<body^>
|
|
echo ^<table^>
|
|
echo ^<tr^>^<th^>USN^</th^>^<th^>MO^</th^>^<th^>SKU^</th^>^<th^>Model Family^</th^>^<th^>Server^</th^>^<th^>Item^</th^>^<th^>Status^</th^>^<th^>Message^</th^>^<th^>Line^</th^>^<th^>Location^</th^>^<th^>Last Change^</th^>^</tr^>
|
|
|
|
for /f "tokens=1-11 delims=," %%a in ('mysql -B -s -h 10.60.230.109 -uapisvc -pwcqte -D ewsv3_f716 -e "SELECT CONCAT_WS(',',USN,MO,SKU,ModelFamily,Server,Item,Status,Message,Line,Location,Last_Change) FROM (SELECT u.USN,u.MO,u.SKU,u.PARTNO AS ModelFamily,u.relay AS Server,u.Item,u.Status,IF(u.Message='','NULL',u.Message) as Message,l.Line,CONCAT_WS('-',l.col,l.row,l.num) AS Location,u.Last_Change FROM uutinfo u LEFT JOIN locinfo l ON u.mac=l.mac WHERE STATUS='FAI') AS tmp ORDER BY tmp.MO,tmp.USN ASC;"') do (
|
|
echo ^<tr^>^<td^>%%a^</td^>^<td^>%%b^</td^>^<td^>%%c^</td^>^<td^>%%d^</td^>^<td^>%%e^</td^>^<td^>%%f^</td^>^<td^>%%g^</td^>^<td^>%%h^</td^>^<td^>%%i^</td^>^<td^>%%j^</td^>^<td^>%%k^</td^>^</tr^>
|
|
)
|
|
|
|
echo ^</table^>
|
|
echo ^</body^>
|
|
echo ^</html^>
|
|
|
|
:END
|