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_ConvertBackslashToSlash $gvsqw_TmpFile.drivesraw | ||
| + | gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1 > ${gvsqw_TmpFile} | ||
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 |grep -iv Password|sed 's, *$,,g'|sed 's,^ *,,g'|tr '\t' ' '|sed 's, *, ,g' > ${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 | ||
gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile} | gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile} | ||
| + | gfsqw_ExecXpCmdShell $gvsqw_TmpFile.drives|tr -d '\r'| tr -s ' '| sed 's, *$,,' > $gvsqw_TmpFile.drivesraw | ||
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | ||
gfsqw_InsertIndicators "Alert" | gfsqw_InsertIndicators "Alert" | ||
gfsqw_InsertIndicators "archivingDb" | gfsqw_InsertIndicators "archivingDb" | ||
| − | gfsqw_InsertIndicators " | + | gfsqw_InsertIndicators "DrivesOle" |
| + | gfsqw_InsertIndicators "DrivesWmic" | ||
gfsqw_InsertIndicators "Instance" | gfsqw_InsertIndicators "Instance" | ||
| + | gfsqw_InsertIndicators "JobStats" | ||
| + | gfsqw_InsertIndicators "JobStatsMonth" | ||
gfsqw_InsertIndicators "License" | gfsqw_InsertIndicators "License" | ||
gfsqw_InsertIndicators "LinkedServers" | gfsqw_InsertIndicators "LinkedServers" | ||
gfsqw_InsertIndicators "Parameters" | gfsqw_InsertIndicators "Parameters" | ||
| + | gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_GatherIndicators.ksh $gvsqw_InputParameters" | ||
| + | gfsqw_XpCmdShellGlobalDisable | ||
lfsqw_ArchivingDb => | lfsqw_ArchivingDb => | ||
lfsqw_ArchivingParameters | lfsqw_ArchivingParameters | ||
| Ligne 24 : | Ligne 31 : | ||
lfsqw_GatherDrives | lfsqw_GatherDrives | ||
lfsqw_GatherDrives => | lfsqw_GatherDrives => | ||
| + | lfsqw_GatherDrivesOle => | ||
| + | lfsqw_GatherDrivesWmic | ||
| + | lfsqw_GatherDrivesWmic => | ||
lfsqw_GatherInstance | lfsqw_GatherInstance | ||
lfsqw_GatherInstance => | lfsqw_GatherInstance => | ||
| Ligne 38 : | Ligne 48 : | ||
lfsqw_GenInsertSpace => | lfsqw_GenInsertSpace => | ||
lfsqw_GenInsertTables => | lfsqw_GenInsertTables => | ||
| + | lfsqw_Jobs => | ||
lfsqw_License => | lfsqw_License => | ||
lfsqw_LinkedServers | lfsqw_LinkedServers | ||
Version du 2 juillet 2021 à 16:36
librairies de fonctions shell $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Explication des fonctions:
gfsqw_ConvertBackslashToSlash $gvsqw_TmpFile.drivesraw
gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1 > ${gvsqw_TmpFile}
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 |sed 's,\\,/,g'|sed 's, $,,g' |tee $gvsqw_TmpFile
gfsqw_ExecSql "sp_helpdb" 2>&1 > ${gvsqw_TmpFile}
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.drives|tr -d '\r'| tr -s ' '| sed 's, *$,,' > $gvsqw_TmpFile.drivesraw
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "archivingDb"
gfsqw_InsertIndicators "DrivesOle"
gfsqw_InsertIndicators "DrivesWmic"
gfsqw_InsertIndicators "Instance"
gfsqw_InsertIndicators "JobStats"
gfsqw_InsertIndicators "JobStatsMonth"
gfsqw_InsertIndicators "License"
gfsqw_InsertIndicators "LinkedServers"
gfsqw_InsertIndicators "Parameters"
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_GatherIndicators.ksh $gvsqw_InputParameters"
gfsqw_XpCmdShellGlobalDisable
lfsqw_ArchivingDb =>
lfsqw_ArchivingParameters
lfsqw_Backups
lfsqw_Backups =>
lfsqw_GatherAlertLogFile =>
lfsqw_GatherDatabases =>
lfsqw_GatherDrives
lfsqw_GatherDrives =>
lfsqw_GatherDrivesOle =>
lfsqw_GatherDrivesWmic
lfsqw_GatherDrivesWmic =>
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_Jobs =>
lfsqw_License =>
lfsqw_LinkedServers
lfsqw_LinkedServers =>
lfsqw_Parameters =>
lfsqw_SqlInsertSpace =>
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql
