Context Navigation

← Previous Changeset
Next Changeset →

Changeset 1855

Timestamp:

01/19/12 11:26:12 (4 months ago)

Author:

Dylan

Message:

unxsVZ added uNode filter for tDatacenter left panel mini reports.

Files:

: 1 modified

trunk/tdatacenterfunc.h (modified) (10 diffs)

Legend:

: Unmodified
: Added
: Removed

trunk/tdatacenterfunc.h

r1736	r1855
11	11	static unsigned uClone=0;
12	12	static unsigned uOldDatacenter=0;
	13	static unsigned uTargetNode=0;
	14	static char cuTargetNodePullDown[256]={""};
	15
13	16	//ModuleFunctionProtos()
14	17	void tDatacenterNavList(void);
…	…
41	44	strcpy(cForClientPullDown,entries[i].val);
42	45	uForClient=ReadPullDown(TCLIENT,"cLabel",cForClientPullDown);
	46	}
	47	else if(!strcmp(entries[i].name,"cuTargetNodePullDown"))
	48	{
	49	sprintf(cuTargetNodePullDown,"%.255s",entries[i].val);
	50	uTargetNode=ReadPullDown("tNode","cLabel",cuTargetNodePullDown);
43	51	}
44	52	}
…	…
435	443
436	444
	445	printf("<p>Select uNode<br>");
	446	tTablePullDownDatacenter("tNode;cuTargetNodePullDown","cLabel","cLabel",uTargetNode,1,
	447	"",0,uDatacenter);//0 does not use tProperty, uses uDatacenter
	448
437	449	//1-. Disk space usage/soft limit ratio
438	450	//1a-. Create temp table
…	…
449	461
450	462	//1b-. Populate with data per container
451		sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue,tContainer.cLabel FROM tProperty,tContainer"
	463	if(uTargetNode)
	464	sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue,tContainer.cLabel FROM tProperty,tContainer"
	465	" WHERE tProperty.uKey=tContainer.uContainer AND tProperty.uType=3 AND"
	466	" tProperty.cName='1k-blocks.luUsage' AND tContainer.uDatacenter=%u"
	467	" AND tContainer.uNode=%u"
	468	" AND tContainer.uStatus=1",uDatacenter,uTargetNode);
	469	else
	470	sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue,tContainer.cLabel FROM tProperty,tContainer"
452	471	" WHERE tProperty.uKey=tContainer.uContainer AND tProperty.uType=3 AND"
453	472	" tProperty.cName='1k-blocks.luUsage' AND tContainer.uDatacenter=%u"
…	…
475	494	mysql_free_result(res);
476	495
477		sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue FROM tProperty,tContainer"
	496	if(uTargetNode)
	497	sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue FROM tProperty,tContainer"
	498	" WHERE tProperty.uKey=tContainer.uContainer AND tProperty.uType=3 AND"
	499	" tProperty.cName='1k-blocks.luSoftLimit' AND tContainer.uDatacenter=%u"
	500	" AND tContainer.uNode=%u"
	501	" AND tContainer.uStatus=1",uDatacenter,uTargetNode);
	502	else
	503	sprintf(gcQuery,"SELECT tProperty.uKey,tProperty.cValue FROM tProperty,tContainer"
478	504	" WHERE tProperty.uKey=tContainer.uContainer AND tProperty.uType=3 AND"
479	505	" tProperty.cName='1k-blocks.luSoftLimit' AND tContainer.uDatacenter=%u"
…	…
539	565
540	566	//2-. None zero historic fail counters
541		sprintf(gcQuery,"SELECT cValue,uKey,cLabel,cName FROM tProperty,tContainer WHERE"
	567	if(uTargetNode)
	568	sprintf(gcQuery,"SELECT cValue,uKey,cLabel,cName FROM tProperty,tContainer WHERE"
	569	" tProperty.uKey=tContainer.uContainer AND"
	570	" tContainer.uDatacenter=%u AND"
	571	" tContainer.uNode=%u AND"
	572	" cValue!='0' AND uType=3 AND cName LIKE '%%.luFailcnt'"
	573	" ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uDatacenter,uTargetNode);
	574	else
	575	sprintf(gcQuery,"SELECT cValue,uKey,cLabel,cName FROM tProperty,tContainer WHERE"
542	576	" tProperty.uKey=tContainer.uContainer AND"
543	577	" tContainer.uDatacenter=%u AND"
…	…
564	598
565	599	//3a-. Todays top in
566		sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
	600	if(uTargetNode)
	601	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
567	602	" tProperty,tContainer WHERE"
568	603	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
569	604	" tContainer.uStatus=%u AND"
570	605	" tContainer.uDatacenter=%u AND"
	606	" tContainer.uNode=%u AND"
	607	" cName='Venet0.luMaxDailyInDelta'"
	608	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter,uTargetNode);
	609	else
	610	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
	611	" tProperty,tContainer WHERE"
	612	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
	613	" tContainer.uStatus=%u AND"
	614	" tContainer.uDatacenter=%u AND"
571	615	" cName='Venet0.luMaxDailyInDelta'"
572	616	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter);
…	…
590	634
591	635	//3b-. Todays top out
592		sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
	636	if(uTargetNode)
	637	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
593	638	" tProperty,tContainer WHERE"
594	639	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
595	640	" tContainer.uStatus=%u AND"
596	641	" tContainer.uDatacenter=%u AND"
	642	" tContainer.uNode=%u AND"
	643	" cName='Venet0.luMaxDailyOutDelta'"
	644	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter,uTargetNode);
	645	else
	646	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000),2),uKey,cHostname,TIME(FROM_UNIXTIME(tProperty.uModDate)) FROM"
	647	" tProperty,tContainer WHERE"
	648	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
	649	" tContainer.uStatus=%u AND"
	650	" tContainer.uDatacenter=%u AND"
597	651	" cName='Venet0.luMaxDailyOutDelta'"
598	652	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter);
…	…
616	670
617	671	//4-. Last 5 min top talkers
618		sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/2000),2),uKey,cHostname FROM"
	672	if(uTargetNode)
	673	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/2000),2),uKey,cHostname FROM"
619	674	" tProperty,tContainer WHERE"
620	675	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
621	676	" tContainer.uStatus=%u AND"
622	677	" tContainer.uDatacenter=%u AND"
	678	" tContainer.uNode=%u AND"
	679	" (cName='Venet0.luInDelta' OR cName='Venet0.luOutDelta')"
	680	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter,uTargetNode);
	681	else
	682	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/2000),2),uKey,cHostname FROM"
	683	" tProperty,tContainer WHERE"
	684	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
	685	" tContainer.uStatus=%u AND"
	686	" tContainer.uDatacenter=%u AND"
623	687	" (cName='Venet0.luInDelta' OR cName='Venet0.luOutDelta')"
624	688	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter);
…	…
642	706
643	707	//4-. Top talkers
644		sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000000000),2),uKey,cHostname FROM"
	708	if(uTargetNode)
	709	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000000000),2),uKey,cHostname FROM"
	710	" tProperty,tContainer WHERE"
	711	" tContainer.uStatus=%u AND"
	712	" tContainer.uDatacenter=%u AND"
	713	" tContainer.uNode=%u AND"
	714	" tProperty.uKey=tContainer.uContainer AND cValue!='0' AND uType=3 AND"
	715	" (cName='Venet0.luIn' OR cName='Venet0.luOut')"
	716	" GROUP BY uKey ORDER BY CONVERT(cValue,UNSIGNED) DESC LIMIT 10",uACTIVE,uDatacenter,uTargetNode);
	717	else
	718	sprintf(gcQuery,"SELECT FORMAT(SUM(cValue/1000000000),2),uKey,cHostname FROM"
645	719	" tProperty,tContainer WHERE"
646	720	" tContainer.uStatus=%u AND"

Context Navigation

Changeset 1855

Legend:

trunk/tdatacenterfunc.h

Download in other formats: