Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 7: | Line 7: | ||
gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile} | gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile} | ||
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | ||
| − | gfsqw_InsertIndicators " | + | gfsqw_InsertIndicators "Alert" |
| + | gfsqw_InsertIndicators "Instance" | ||
gfsqw_InsertIndicators "License" | gfsqw_InsertIndicators "License" | ||
gfsqw_InsertIndicators "Parameters" | gfsqw_InsertIndicators "Parameters" | ||
| − | + | lfsqw_GatherAlertLogFile => | |
lfsqw_GatherDatabases => | lfsqw_GatherDatabases => | ||
| + | lfsqw_GatherInstance | ||
| + | lfsqw_GatherInstance => | ||
lfsqw_GatherSpace => | lfsqw_GatherSpace => | ||
| − | lfsqw_GenerateInsertAlert | + | lfsqw_GenerateInsertAlert |
lfsqw_GenInsertDatabases => | lfsqw_GenInsertDatabases => | ||
| − | + | lfsqw_GenInsertInstance => | |
| + | lfsqw_GenInsertInstance|tee ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertLicense => | lfsqw_GenInsertLicense => | ||
lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql | lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql | ||
Revision as of 18:33, 5 April 2014
shell functions library $gvsqw_MssBin/../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_SizeInstance=0
lfsqw_SqlInsertSpace =>
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
lfsqw_Tables =>
