Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
shell functions library $gvsqw_MssBin/../lib/sqwmsq_GatherIndicators.lib:<br>
+
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:<br>
 
{{SQWareProduction_sqwmsq_GatherIndicators.lib_presentation}}
 
{{SQWareProduction_sqwmsq_GatherIndicators.lib_presentation}}
 
<br>
 
<br>
Line 28: Line 28:
 
lfsqw_License =>  
 
lfsqw_License =>  
 
lfsqw_Parameters =>  
 
lfsqw_Parameters =>  
lfsqw_SizeInstance=0
 
 
lfsqw_SqlInsertSpace =>  
 
lfsqw_SqlInsertSpace =>  
 
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
 
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
Line 34: Line 33:
 
</pre>
 
</pre>
 
<br>
 
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_GatherIndicators.lib}}
+
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_GatherIndicators.lib}}
 
<br>
 
<br>

Revision as of 20:21, 16 June 2014

shell functions library $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Functions explanation:

gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1 > ${gvsqw_TmpFile}
gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile}
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "Instance"
gfsqw_InsertIndicators "License"
gfsqw_InsertIndicators "Parameters"
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabases => 
lfsqw_GatherInstance
lfsqw_GatherInstance => 
lfsqw_GatherSpace => 
lfsqw_GenerateInsertAlert
lfsqw_GenInsertDatabases => 
lfsqw_GenInsertInstance => 
lfsqw_GenInsertInstance|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertLicense => 
lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertParameters => 
lfsqw_GenInsertParameters|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertSpace => 
lfsqw_GenInsertTables => 
lfsqw_License => 
lfsqw_Parameters => 
lfsqw_SqlInsertSpace => 
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
lfsqw_Tables => 


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib

by function with same name in $gvsqw_MsqBin/../lib_cust/sqwmsq_GatherIndicators.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_GatherIndicators.lib specifically for this user .