SQWareProduction:mssql:lib:sqwmsq GatherIndicators.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
m Updated by BatchUser
m Updated by BatchUser
Line 4: Line 4:
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_ExecSql $gvsqw_TmpFile.sql 2>&1 |grep -iv Password|sed 's,  *$,,g'|sed 's,^  *,,g'|tr '\t' ' '|sed 's,  *, ,g' | tee ${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 > ${gvsqw_TmpFile}
gfsqw_ExecSql ${gvsqw_TmpFile}.sql 2>&1 > ${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
Line 29: Line 29:
lfsqw_GenInsertDatabases =>  
lfsqw_GenInsertDatabases =>  
lfsqw_GenInsertInstance =>  
lfsqw_GenInsertInstance =>  
lfsqw_GenInsertInstance|tee ${gvsqw_TmpFile}.sql
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|tee ${gvsqw_TmpFile}.sql
lfsqw_GenInsertParameters> ${gvsqw_TmpFile}.sql
lfsqw_GenInsertSpace =>  
lfsqw_GenInsertSpace =>  
lfsqw_GenInsertTables =>  
lfsqw_GenInsertTables =>  

Revision as of 18:33, 8 March 2020

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

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 > ${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_GenDatabasesList|sed 's,\\,,g' > $gvsqw_TmpFile.lst
gfsqw_InsertIndicators "Alert"
gfsqw_InsertIndicators "Drives"
gfsqw_InsertIndicators "Instance"
gfsqw_InsertIndicators "License"
gfsqw_InsertIndicators "LinkedServers"
gfsqw_InsertIndicators "Parameters"
lfsqw_ArchivingParameters
lfsqw_Backups
lfsqw_Backups => 
lfsqw_GatherAlertLogFile => 
lfsqw_GatherDatabases => 
lfsqw_GatherDrives
lfsqw_GatherDrives => 
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_License => 
lfsqw_LinkedServers
lfsqw_LinkedServers => 
lfsqw_Parameters => 
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=14128"