SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Functions explanation:
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's, *$,,g'|sed 's,^ *,,g'|tr '\t' ' '|sed 's, *, ,g' > ${gvsqw_TmpFile}
gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1 > ${gvsqw_TmpFile}
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |sed 's,\\,/,g'|sed 's, $,,g' |tee $gvsqw_TmpFile
gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile}
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "Drives"
gfsqw_InsertIndicators "Instance"
gfsqw_InsertIndicators "License"
gfsqw_InsertIndicators "LinkedServers"
gfsqw_InsertIndicators "Parameters"
lfsqw_ArchivingDb =>
lfsqw_ArchivingParameters
lfsqw_Backups
lfsqw_Backups =>
lfsqw_GatherAlertLogFile =>
lfsqw_GatherDatabases =>
lfsqw_GatherDrives
lfsqw_GatherDrives =>
lfsqw_GatherInstance
lfsqw_GatherInstance =>
lfsqw_GatherSpace =>
lfsqw_GatherTables =>
lfsqw_GenerateInsertAlert
lfsqw_GenInsertDatabases =>
lfsqw_GenInsertInstance =>
lfsqw_GenInsertInstance> ${gvsqw_TmpFile}.sql
lfsqw_GenInsertLicense =>
lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertParameters =>
lfsqw_GenInsertParameters> ${gvsqw_TmpFile}.sql
lfsqw_GenInsertSpace =>
lfsqw_GenInsertTables =>
lfsqw_License =>
lfsqw_LinkedServers
lfsqw_LinkedServers =>
lfsqw_Parameters =>
lfsqw_SqlInsertSpace =>
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
