SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib

From Wiki_dbSQWare
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

shell functions library $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib:
lib for sqwmsq_GatherIndicators.ksh
Functions explanation: 

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'|tr '\t' ' '|sed 's,  *$,,g' |tee $gvsqw_TmpFile
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1|tr -d '\r' |sed 's,\\,/,g' |sed 's,  *$,,g'> $gvsqw_TmpFile
gfsqw_ExecSql $gvsqw_TmpFile.sql |sed 's,  *$,,g'> $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_GatherAuditLogon
gfsqw_GatherAuditLogon => 
gfsqw_GatherHostInfosGenInsert
gfsqw_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_InitPurges
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_GatherDrivesOle => 
lfsqw_GatherDrivesWmic
lfsqw_GatherDrivesWmic => 
lfsqw_GatherFs => 
lfsqw_GatherHostInfos
lfsqw_GatherHostInfos => 
lfsqw_GatherInstance
lfsqw_GatherInstance => 
lfsqw_GatherOverLoaded
lfsqw_GatherSpace => 
lfsqw_GatherSpace_old => 
lfsqw_GatherTables
lfsqw_GatherTables => 
lfsqw_GatherUsers
lfsqw_GatherUsers => 
lfsqw_GenerateInsertAlert
lfsqw_GenerateListFsDbf => 
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


Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_GatherIndicators.lib

by function with same name in $gvsqw_MsqBin/../lib_cust/sqwmsq_GatherIndicators.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_GatherIndicators.lib specifically for this user .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:lib:sqwmsq_GatherIndicators.lib&oldid=33223"