SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
No edit summary |
||
| (15 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
Functions explanation: | Functions explanation: | ||
<pre> | <pre> | ||
gfsqw_BeginningCom | |||
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|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_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_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst | ||
gfsqw_InitPurges | |||
gfsqw_InsertChanges | |||
gfsqw_InsertIndicators "Alert" | gfsqw_InsertIndicators "Alert" | ||
gfsqw_InsertIndicators "archivingDb" | |||
gfsqw_InsertIndicators "Del Tables" | |||
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 "Parameters" | 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_GatherAlertLogFile => | ||
lfsqw_GatherDatabases | |||
lfsqw_GatherDatabases => | lfsqw_GatherDatabases => | ||
lfsqw_GatherDrives => | |||
lfsqw_GatherDrivesOle => | |||
lfsqw_GatherDrivesWmic | |||
lfsqw_GatherDrivesWmic => | |||
lfsqw_GatherFs => | |||
lfsqw_GatherHostInfos | |||
lfsqw_GatherHostInfos => | |||
lfsqw_GatherInstance | lfsqw_GatherInstance | ||
lfsqw_GatherInstance => | lfsqw_GatherInstance => | ||
lfsqw_GatherOverLoaded | |||
lfsqw_GatherSpace => | lfsqw_GatherSpace => | ||
lfsqw_GatherSpace_old => | |||
lfsqw_GatherTables | |||
lfsqw_GatherTables => | |||
lfsqw_GatherUsers | |||
lfsqw_GatherUsers => | |||
lfsqw_GenerateInsertAlert | lfsqw_GenerateInsertAlert | ||
lfsqw_GenerateListFsDbf => | |||
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_Jobs | |||
lfsqw_Jobs => | |||
lfsqw_License | |||
lfsqw_License => | lfsqw_License => | ||
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 | ||
</pre> | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_GatherIndicators.lib}} | {{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_GatherIndicators.lib}} | ||
<br> | <br> | ||
Latest revision as of 18:47, 1 July 2025
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
