SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
(3 révisions intermédiaires par le même utilisateur non affichées) | |||
Ligne 4 : | Ligne 4 : | ||
Explication des fonctions: | Explication des fonctions: | ||
<pre> | <pre> | ||
+ | gfsqw_BeginningCom | ||
gfsqw_ConvertBackslashToSlash $gvsqw_TmpFile.drivesraw | gfsqw_ConvertBackslashToSlash $gvsqw_TmpFile.drivesraw | ||
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 |grep -iv Password|sed 's, *$,,g'|sed 's,^ *,,g'|tr -d '\r' |tr '\t' ' '|sed 's, *, ,g' > ${gvsqw_TmpFile} | gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's, *$,,g'|sed 's,^ *,,g'|tr -d '\r' |tr '\t' ' '|sed 's, *, ,g' > ${gvsqw_TmpFile} | ||
− | gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password| | + | gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|tr '\t' ' '|sed 's, *$,,g'|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} | ||
Ligne 13 : | Ligne 14 : | ||
gfsqw_GatherHostInfosGenInsert | gfsqw_GatherHostInfosGenInsert | ||
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | ||
+ | gfsqw_InsertChanges | ||
gfsqw_InsertIndicators "Alert" | gfsqw_InsertIndicators "Alert" | ||
gfsqw_InsertIndicators "archivingDb" | gfsqw_InsertIndicators "archivingDb" | ||
Ligne 25 : | Ligne 27 : | ||
gfsqw_InsertIndicators "Parameters" | gfsqw_InsertIndicators "Parameters" | ||
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_GatherIndicators.ksh $gvsqw_InputParameters" | gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_GatherIndicators.ksh $gvsqw_InputParameters" | ||
+ | gfsqw_PurgeLogDirAndFiles | ||
gfsqw_XpCmdShellGlobalDisable | gfsqw_XpCmdShellGlobalDisable | ||
+ | lfsqw_Archiving | ||
lfsqw_ArchivingDb => | lfsqw_ArchivingDb => | ||
lfsqw_ArchivingParameters | lfsqw_ArchivingParameters | ||
lfsqw_Backups | lfsqw_Backups | ||
lfsqw_Backups => | lfsqw_Backups => | ||
+ | lfsqw_GatherAlertLogFile | ||
lfsqw_GatherAlertLogFile => | lfsqw_GatherAlertLogFile => | ||
+ | lfsqw_GatherDatabases | ||
lfsqw_GatherDatabases => | lfsqw_GatherDatabases => | ||
lfsqw_GatherDrives | lfsqw_GatherDrives | ||
Ligne 37 : | Ligne 43 : | ||
lfsqw_GatherDrivesWmic | lfsqw_GatherDrivesWmic | ||
lfsqw_GatherDrivesWmic => | lfsqw_GatherDrivesWmic => | ||
+ | lfsqw_GatherHostInfos | ||
lfsqw_GatherHostInfos => | lfsqw_GatherHostInfos => | ||
lfsqw_GatherInstance | lfsqw_GatherInstance | ||
lfsqw_GatherInstance => | lfsqw_GatherInstance => | ||
+ | lfsqw_GatherOverLoaded | ||
+ | lfsqw_GatherSpace | ||
lfsqw_GatherSpace => | lfsqw_GatherSpace => | ||
+ | lfsqw_GatherTables | ||
lfsqw_GatherTables => | lfsqw_GatherTables => | ||
+ | lfsqw_GatherUsers | ||
lfsqw_GatherUsers => | lfsqw_GatherUsers => | ||
lfsqw_GenerateInsertAlert | lfsqw_GenerateInsertAlert | ||
Ligne 52 : | Ligne 63 : | ||
lfsqw_GenInsertParameters> ${gvsqw_TmpFile}.sql | lfsqw_GenInsertParameters> ${gvsqw_TmpFile}.sql | ||
lfsqw_GenInsertSpace => | lfsqw_GenInsertSpace => | ||
+ | lfsqw_Jobs | ||
lfsqw_Jobs => | lfsqw_Jobs => | ||
+ | lfsqw_License | ||
lfsqw_License => | lfsqw_License => | ||
lfsqw_LinkedServers | lfsqw_LinkedServers | ||
lfsqw_LinkedServers => | lfsqw_LinkedServers => | ||
+ | lfsqw_Main => | ||
+ | lfsqw_Parameters | ||
lfsqw_Parameters => | lfsqw_Parameters => | ||
+ | lfsqw_PostArchivingParameters | ||
lfsqw_SqlInsertSpace => | lfsqw_SqlInsertSpace => | ||
lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql | lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql |
Version du 25 février 2024 à 21:12
librairies de fonctions shell $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Explication des fonctions:
gfsqw_BeginningCom 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 -d '\r' |tr '\t' ' '|sed 's, *, ,g' > ${gvsqw_TmpFile} gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|tr '\t' ' '|sed 's, *$,,g'|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_GatherHostInfosGenInsert gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst gfsqw_InsertChanges gfsqw_InsertIndicators "Alert" gfsqw_InsertIndicators "archivingDb" gfsqw_InsertIndicators "Del Tables" 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_PurgeLogDirAndFiles gfsqw_XpCmdShellGlobalDisable lfsqw_Archiving lfsqw_ArchivingDb => lfsqw_ArchivingParameters lfsqw_Backups lfsqw_Backups => lfsqw_GatherAlertLogFile lfsqw_GatherAlertLogFile => lfsqw_GatherDatabases lfsqw_GatherDatabases => lfsqw_GatherDrives lfsqw_GatherDrives => lfsqw_GatherDrivesOle => lfsqw_GatherDrivesWmic lfsqw_GatherDrivesWmic => lfsqw_GatherHostInfos lfsqw_GatherHostInfos => lfsqw_GatherInstance lfsqw_GatherInstance => lfsqw_GatherOverLoaded lfsqw_GatherSpace lfsqw_GatherSpace => lfsqw_GatherTables lfsqw_GatherTables => lfsqw_GatherUsers lfsqw_GatherUsers => 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_Jobs lfsqw_Jobs => lfsqw_License lfsqw_License => lfsqw_LinkedServers lfsqw_LinkedServers => lfsqw_Main => lfsqw_Parameters lfsqw_Parameters => lfsqw_PostArchivingParameters lfsqw_SqlInsertSpace => lfsqw_SqlInsertSpace >> ${gvsqw_TmpFile}.sql