SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| Line 1: | Line 1: | ||
shell functions library $ | 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_SqlInsertSpace => | lfsqw_SqlInsertSpace => | ||
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql | lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql | ||
| Line 34: | Line 33: | ||
</pre> | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|mssql| | {{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_GatherIndicators.lib}} | ||
<br> | <br> | ||
Revision as of 21: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 =>
