SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib : Différence entre versions

De WikiFr_dbSQWare
Aller à : navigation, rechercher
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|sed 's,  *$,,g'|sed 's,^ *,,g'|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 $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


Information.png
Information:
Vous pouvez surcharger les fonctions contenues dans $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib

en redeclarant une fonction du meme nom $gvsqw_MsqBin/../lib_cust/sqwmsq_GatherIndicators.lib pour tous les environnements
ou dans $HOME/sqwConfig/sqwmsq_GatherIndicators.lib specifiquement pour ce user .