SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Ligne 4 : | Ligne 4 : | ||
Explication des fonctions: | Explication des fonctions: | ||
<pre> | <pre> | ||
− | gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's, *$,,g'|sed 's,^ *,,g'|tr '\t' ' '|sed 's, *, ,g' | + | 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 > ${gvsqw_TmpFile} | ||
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |sed 's,\\,/,g'|sed 's, $,,g' |tee $gvsqw_TmpFile | gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |sed 's,\\,/,g'|sed 's, $,,g' |tee $gvsqw_TmpFile | ||
Ligne 29 : | Ligne 29 : | ||
lfsqw_GenInsertDatabases => | lfsqw_GenInsertDatabases => | ||
lfsqw_GenInsertInstance => | lfsqw_GenInsertInstance => | ||
− | lfsqw_GenInsertInstance | + | lfsqw_GenInsertInstance> ${gvsqw_TmpFile}.sql |
lfsqw_GenInsertLicense => | lfsqw_GenInsertLicense => | ||
lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql | lfsqw_GenInsertLicense|tee ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertParameters => | lfsqw_GenInsertParameters => | ||
− | lfsqw_GenInsertParameters | + | lfsqw_GenInsertParameters> ${gvsqw_TmpFile}.sql |
lfsqw_GenInsertSpace => | lfsqw_GenInsertSpace => | ||
lfsqw_GenInsertTables => | lfsqw_GenInsertTables => |
Version du 8 mars 2020 à 18:28
librairies de fonctions shell $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Explication des fonctions:
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 "Drives" gfsqw_InsertIndicators "Instance" gfsqw_InsertIndicators "License" gfsqw_InsertIndicators "LinkedServers" gfsqw_InsertIndicators "Parameters" 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