RELEASE NOTES
Major Versions 2025
- SQWareCentral for MsSql: enhance, add purge of tsqwmsq_DbOptions
- SQWareCentral for MsSql: enhance, add purge of tsqwmsq_DbOptionsChanges
- SQWareCentral for Oracle: bugfix, add filter on status for TBS and FRA check space
- SQWareProduction for All: bugfix, loop on search parent process when Solaris zone because PID=PPID
- SQWareProduction for All: bugfix, quote replaced by underscore _ in file name for database with quote in name
- SQWareProduction for All: enhance, add 'chmod 600 EncryptedFile ClearFile SslPassFile' when generate files
- SQWareProduction for All: enhance, add default options '-pbkdf2 -iter 100000' when encript file with openssl >= v3
- SQWareProduction for All: enhance, add gfsqw_ConvertPathToCygwin function in generic lib to convert "D:/xxx" to "/cygdrive/d/xxx"
- SQWareProduction for All: enhance, add var gvsqw_HostFullname to put "full hostname" instead of "short name"
- SQWareProduction for MongoDB: bugfix, syntax error on restore script
- SQWareProduction for MongoDB: enhance, add option -IgnoreVersion for GenerateCreateInstance script
- SQWareProduction for MongoDB: enhance, modify SetEnv to source profile when Dist mode
- SQWareProduction for MsSql: bugfix, add 'set quoted_identifier on' for rebuild when not set to OFF on db
- SQWareProduction for MsSql: bugfix, modify connection function when encript file
- SQWareProduction for MsSql: enhance, add collect of db options in tsqwmsq_DbOptions
- SQWareProduction for MsSql: enhance, add collect of db options in tsqwmsq_DbOptionsChanges
- SQWareProduction for MsSql: enhance, ignore "failed because the following SET options have incorrect settings: 'ANSI_NULLS, ..." messages when rebuild
- SQWareProduction for Oracle: bugfix, modify SchemaRefreshExpdp Impdp GenericRefresh Expdp and CopyDmpdp libs to take into account upper case files names on Windows
- SQWareProduction for Oracle: enhance, add csqwora_SetEnv_profile.ksh for example
- SQWareProduction for PostgreSQL: bugfix, modify all scripts to accept database with quote or space in name
- SQWareProduction for PostgreSQL: bugfix, modify libs to take into account db with ' or space in name 🙁
- SQWareRepository for MsSql: enhance, add table tsqwmsq_DbOptions
- SQWareRepository for MsSql: enhance, add table tsqwmsq_DbOptionsChanges
- SQWareWeb for All: bugfix, correction change password in preferences
- SQWareWeb for All: bugfix, correction of loss of column names in show/hide columns
- SQWareWeb for All: security, delete access to test.php phpinfo.php
- SQWareWeb for MsSql: enhance, add DbOptionsChanges and DbOptions all reports
- SQWareWeb for MsSql: enhance, add DbOptionsChanges and DbOptions unit reports
- SQWareCentral for All: enhance, adjust JobsParam and JobsParamPrivs because of changes in JobsParam tables (new standard)
- SQWareProduction for MongoDB: bugfix, fail to restore when 'no tar' backup
- SQWareRepository for All: bugfix, correct migrations before rename columns created_by and updated_by
- SQWareRepository for All: bugfix, some adjust after rename columns in 2025.06
- SQWareWeb for All: enhance,adjust GeneralInfos and Daybook because of changes in Management tables
- SQWareWeb for All: bugfix, correct dbalias update action
- SQWareWeb for All: bugfix, correct sql queries for lack backups db justified
- SQWareWeb for All: bugfix, correct sql queries for lack backups justified
- SQWareWeb for All: bugfix, modify check backup report (change column name)
- SQWareCentral for All: enhance, add load of SQWareAdmin param when dbspatch
- SQWareCentral for MsSql: enhance, add purge of tsqwmsq_AuditLogon
- SQWareCentral for Oracle: enhance, add purge of tsqwora_AuditLogon
- SQWarePredict for MsSql: bugfix, add 'sort' when check files to restore because of bad sort of 'dir' command when NFS mount ...
- SQWareProduction for Add: enhance, add generic function gfsqw_DisplayAllParentsProcesses for display parents processes in log+mail
- SQWareProduction for MongoDB: bugfix, fail to search file to restore
- SQWareProduction for MsSql: enhance, add collect/purge of tsqw_audit_logon
- SQWareProduction for MsSql: enhance, add CreateAuditLogon to create table tsqw_audit_logon and trigger trgsqw_audit_logon
- SQWareProduction for MySQL: bugfix, fix -Consistent option
- SQWareProduction for MySQL: enhance, add collect of data_free for tables, databases and instance
- SQWareProduction for MySQL: enhance, modify optimize to filter on $gvsqw_OptimizeMinDataFree and $gvsqw_OptimizeMinFragRatio
- SQWareProduction for Oracle: enhance, add collect/purge of TSQW_AUDIT_LOGON
- SQWareProduction for Oracle: enhance, add CreateAuditLogon to create table TSQW_AUDIT_LOGON and triggers TRGSQW_AUDIT_LOGON+TRGSQW_AUDIT_LOGOFF
- SQWareRepository for All: enhance, add created_at on tsqw_RepositoryVersion
- SQWareRepository for MsSql: enhance, add table tsqwmsq_AuditLogon
- SQWareRepository for MySQL: enhance, add column data_free on tsqwmys_VolDb
- SQWareRepository for MySQL: enhance, add column data_free on tsqwmys_VolTables
- SQWareRepository for Oracle: enhance, add table tsqwora_AuditLogon
- SQWareWeb for All: enhance, add created_at in SQWareRepositoryVersions report
- SQWareWeb for All: enhance, add criticality in repository
- SQWareWeb for All: enhance, add TargetsRdbmsHisto reports
- SQWareWeb for All: enhance, add TargetsTotalHisto and TargetsRdbmsHisto reports
- SQWareWeb for All: enhance, API modification of the admin part of SQWareWeb for merge with SQWareAdmin
- SQWareWeb for All: enhance, modification of the admin part of SQWareWeb for merge with SQWareAdmin
- SQWareWeb for MsSql: enhance, add AuditConnection report
- SQWareWeb for MySQL: enhance, add data_free on reports for tables and databases
- SQWareWeb for Oracle: enhance, add AuditConnection report
- SQWareCentral for All: enhance, add "DBMS list" when check indicators with filter
- SQWareCentral for All: enhance, add insert in tsqw_TargetsDetailHisto when check indicators
- SQWareCentral for All: enhance, add ReportSupportOs to send mail with support date
- SQWareProduction for All: bugfix, modify for Solaris collect of version
- SQWareProduction for DB2: bufix, suppress bad location of 'db2 terminate' in reorg script
- SQWareProduction for MsSql: bugfix, call tsql instead of fisql to avoid issue when collect tables size (for ex, tablename with japan chars)
- SQWareProduction for MySQL: bugfix, mail format when error on MariaBackup or XtraBackup
- SQWareProduction for Oracle: bugfix, double call of userid when impdp
- SQWareProduction for Oracle: enhance, add collect of spfile parameters
- SQWareRepository for All: enhance, add criticality_id on tsqw_Repository and tsqw_RepositoryApplication
- SQWareRepository for All: enhance, add insert histo datas in tsqw_TargetsDetailHisto
- SQWareRepository for All: enhance, add tables tsqw_RepoParam and tsqw_RepoParamTranslate
- SQWareRepository for All: enhance, add table tsqw_TargetsDetailHisto
- SQWareRepository for All: enhance, add tsqw_TargetsDetailHisto
- SQWareRepository for Oracle: enhance, add table tsqwora_SpParameters
- SQWareWeb for All: enhance, add criticality for instance and/or applications on all links reports
- SQWareWeb for All: enhance, add criticality for instance in inventory report
- SQWareWeb for All: enhance, add ReportSupport and ReportSupportOs once a month in CrontabRef example
- SQWareWeb for All: enhance, modify Support and SupportOs reports to take into account only "active" status
- SQWareWeb for Oracle: enhance, spfile parameters reports unit + all
- SQWareCentral for All: bugfix, modify ExecOnDemandJob because follow issue on Solaris
- SQWareCentral for All: enhance, add ConnectTimeout for all ssh/rsync commands
- SQWareCentral for All: enhance, add example to manage HISTFILE for each client
- SQWareCentral for All: enhance, add "pfu" alias
- SQWareCentral for All: enhance, add ReportSupport to send mail with support date
- SQWareCentral for All: enhance, make log and mail more verbose for TrtAuto when timeout (and KillAllChilds)
- SQWareCentral for All: enhance, search if client is mysql or mariadb command
- SQWareCentral for MsSql: bugfix, add 'LINUX' status for gen checks
- SQWareProduction for All: bugfix, modify RunJob to accept '>' in exec command
- SQWareProduction for All: enhance, add ConnectTimeout for all ssh/rsync commands
- SQWareProduction for All: enhance, add KillAllChilds for kill process and all this childs
- SQWareProduction for All: enhance, add "pfu" alias
- SQWareProduction for All: enhance, add var gvsqw_SshConnectTimeout to manage ConnectTimeout ssh/rsync
- SQWareProduction for All: enhance, modify Gobal.lib to gather HostTypeFamily, HostEdition, HostVersion and HostVersionMaj
- SQWareProduction for MsSql: bugfix, 'set ansi_defaults, concat_null_yields_null on', don't rebuild small tables correctly
- SQWareProduction for MsSql: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
- SQWareProduction for MySQL: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
- SQWareProduction for Orale: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
- SQWareProduction for PostgreSQL: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
- SQWareProduction for Sybase: bugfix, modify Global lib to avoid "... delimited by end-of-file (wanted `EOFSQL')" appear in bash
- SQWareProduction for Sybase: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
- SQWareRepository for Adabas: enhance, add EOL dates
- SQWareRepository for All: enhance, add HostTypeFamily, HostEdition, HostVersion and HostVersionMaj on tsqw_GenHostInfos
- SQWareRepository for All: enhance, add ProductEdition and ProductAddInfos on tsqw_GenInstance
- SQWareWeb for All: enhance, add HostTypeFamily, HostEdition, HostVersion and HostVersionMaj in LastGenHostInfos report
- SQWareWeb for All: enhance, add InventoryOverview report
- SQWareWeb for All: enhance, add ProductEdition and ProductAddInfos in HostInfos report
- SQWareWeb for All: enhance, add SupportOs and SupportOsDates reports
- SQWareWeb for All: enhance, add table tsqw_EndLifeOs
- SQWareWeb for All: enhance, add wiki, wikifr and support links on footer
- SQWareProduction for All: enhance, add -AddMail and -SendReport options for sqwgen_RunJob script
- SQWareProduction for All: enhance, add gvsqw_SendMailOnError=Disable variable to globaly deactivate sendmail on error
- SQWareProduction for All: enhance, add -SendMailOnError and -NoSendMailOnError options for sqwgen_RunJob script
- SQWareProduction for Central: bugfix, for set .profile_confort when connected
- SQWareProduction for MsSql: bugfix, bash only accep interger when test (in rebuild script)
- SQWareProduction for Oracle: bugfix, add 'eval' when echo ~$lvsqw_UserUnixSource (work in ksh but not in bash)
- SQWareProduction for Oracle: bugfix, adjust BackupPasswd
- SQWareProduction for Oracle: bugfix, for refresh imp.par not reset
- SQWareProduction for Oracle: bugfix, 'grep -a' not supported on old Solaris (ExpdpAll* + GatherStructures)
- SQWareProduction for Oracle: enhance, add gvsqw_NoASM to disable ASM indicators
- SQWareProduction for PostgreSQL: bugfix, error message when archive (introduce in v2025.01)
- SQWareProduction for PostgreSQL: bugfix, modify delete in DumpGlobalsOnly (for noexec on /var/tmp)
- SQWareProduction for PostgreSQL: enhance, add -Analyze and -NoAnalyze options for VacuumAllDatabases and VacuumDatabase scripts
- SQWareProduction for PostgreSQL: enhance, add example for dump with opt
- SQWareProduction for PostgreSQL: enhance, add gvsqw_VacuumAnalyze=Disable variable to globaly deactivate ANALYZE for VacuumDatabase script
- SQWareProduction for Sybase: bugfix, add 'eval' when echo ~$lvsqw_UserUnixSource (work in ksh but not in bash)
- SQWareProduction for Teradata: bugfix, add *.0 to avoid round in compute
- SQWareCentral for All: functionality, add sqwPredictMon deamon to async update Predict/Detect
- SQWareProduction for All: bugfix, test $SHELLOPTS before "set +H" to prevent fail
- SQWareProduction for All: enhance, add gvsqw_TraceJobDb=disable to disable trace job
- SQWareProduction for All: enhance, add gvsqw_TraceSqlDb=disable to disable load sql
- SQWareProduction for All: enhance, add var for prompt BlackWhite2LinesLong + alias : p_b2l
- SQWareProduction for All: enhance, add var for prompt BlackWhite2LinesShort + alias : p_b2s
- SQWareProduction for All: enhance, add var for prompt BlackWhiteMultiLinesLong + alias : p_bml
- SQWareProduction for All: enhance, add var for prompt BlackWhiteMultiLinesShort + alias : p_bms
- SQWareProduction for All: enhance, add var for prompt BlackWhiteOneLineLong + alias : p_bol
- SQWareProduction for All: enhance, add var for prompt BlackWhiteOneLineShort + alias : p_bos
- SQWareProduction for All: enhance, add var for prompt Color2LinesLong + alias : p_c2l
- SQWareProduction for All: enhance, add var for prompt Color2LinesShort + alias : p_c2s
- SQWareProduction for All: enhance, add var for prompt ColorMultiLinesLong + alias : p_cml
- SQWareProduction for All: enhance, add var for prompt ColorMultiLinesShort + alias : p_cms
- SQWareProduction for All: enhance, add var for prompt ColorOneLineLong + alias : p_col
- SQWareProduction for All: enhance, add var for prompt ColorOneLineShort + alias : p_cos
- SQWareRepository for All: enhance, add tsqw_CommandPathVersion + tsqw_LibsVersion in maintenance scripts
- SQWareRepository for All: enhance, update end of support dates
- SQWareRepository for PostgreSQL: enhance, add tsqwpg_CitusTables + tsqwpg_CitusTablesShards in maintenance scripts
- SQWareRepository for PostgreSQL: enhance, add tsqwpg_Extensions + tsqwpg_ExtensionsChanges in maintenance scripts
- SQWareWeb for All: enhance, add tsqw_CommandPathVersion + tsqw_LibsVersion in update dbalias scripts
- SQWareWeb for PostgreSQL: enhance, add tsqwpg_CitusTables + tsqwpg_CitusTablesShards in update dbalias scripts
- SQWareWeb for PostgreSQL: enhance, add tsqwpg_Extensions + tsqwpg_ExtensionsChanges in update dbalias scripts
- /!\ Migration du ksh au bash !
- SQWareCentral for SQWareAdmin: enhance, add ManageConnector
- SQWareCentral for All: enhance, add -CustFilter option for check indicators
- SQWareCentral for All: enhance, add gvsqw_RunSQWarePredict to globaly enable/disable Predect/Detect
- SQWareCentral for All: enhance, dbspatch wil mv all scripts, cfg and cron on sqwarebox from ksh to bash
- SQWareCentral for All: enhance, mv all scripts from ksh to bash
- SQWareCentral for All: enhance, add sqwctl_PredictUpdate.ksh
- SQWarePredict for All: enhance, add genric param (instance + FS)
- SQWarePredict for All: enhance, add param FSGrowth_used.ini
- SQWarePredict for All: functionnality, init
- SQWarePredict for MsSql: enhance, add param for databases
- SQWarePredict for MsSql: enhance, add param DatabaseGrowth_size.ini
- SQWarePredict for MsSql: enhance, add param DatabaseGrowth_used.ini
- SQWarePredict for MySQL: enhance, add param for databases
- SQWarePredict for Oracle: enhance, add param for schemas + tablespaces
- SQWarePredict for Oracle: enhance, add param SchemaGrowth_size.ini
- SQWarePredict for PostgreSQL: enhance, add param for databases
- SQWarePredict for PostgreSQL: enhance, add param DatabaseGrowth_size.ini
- SQWarePredict for Sybase: enhance, add param for databases
- SQWarePredict for Sybase: functionnality, add DatabaseGrowth_used.ini
- SQWareProduction for All: enhance, add global purge of Predect/Detect when GatherIndicators
- SQWareProduction for All: enhance, add sqwgen_MvToBash.ksh to mv all scripts, cfg and cron on local env from ksh to bash
- SQWareProduction for All: enhance, mv all scripts from ksh to bash
- SQWareProduction for MsSql: enhance, ignore deadlocks when rebuild or update stats
- SQWareProduction for Oracle: bugfix, put 'gunzip -f' to prevent errors when file exists
- SQWareProduction for Oracle: bugfix, put credentials from command line instead of parfile
- SQWareProduction for PostgreSQL: bugfix, modif DumpAllDatabases to take options for DumpGlobalsOnly
- SQWareWeb for All: enhance, add Predict report for FS
- SQWareWeb for All: enhance, add Predict report for Instances
- SQWareWeb for All: enhance, migration from c3js/d3js to Billboard
- SQWareWeb for All: enhance, upgrade DataTables version from v1.10 to v2.2
- SQWareWeb for All: bugfix, display action buttons when repository is empty
- SQWareWeb for Central: enhance, add CmdPathVersion GenHostInfos GenHostInfosChanges and GenPathInfos reports
- SQWareWeb for Central: enhance, add GenDbsVersionLast and GenDbsVersionAll reports
- SQWareWeb for MsSql: enhance, add Predict report for Databases
- SQWareWeb for MySQL: enhance, add Predict report for Databases
- SQWareWeb for Oracle: enhance, add Predict report for Schemas + Tablespaces
- SQWareWeb for PostgreSQL: enhance, add Predict report for Databases
- SQWareWeb for Sybase: enhance, add Predict report for Databases
Major Versions 2024
- SQWareCentral for All: enhance, test system prerequisites like ksh + rsync
- SQWareCentral for MsSql: enhance, modify "c" for mssql Linux
- SQWareCentral for PostgreSQL: enhance, modify check of PITR (full/incr/diff)
- SQWareProduction for All: enhance, add .bashrc_example and .vimrc links
- SQWareProduction for All: enhance, add collect of path and version for ksh, rsync, openssl, ...
- SQWareProduction for All: enhance, add function gfsqw_CheckCommandPathVersion to check command
- SQWareProduction for MsSql: enhance, some adapt for MsSql Linux
- SQWareProduction for MsSql: enhance, suppress call of sp_recompile when version >= 2017
- SQWareProduction for MsSql: functionnality, add support for Linux version (>=2017)
- SQWareProduction for PostgreSQL: bugfix, delete Dump when fail with "rm -rf" for -d format
- SQWareProduction for PostgreSQL: enhance, modify trace of PITR
- SQWareProdution for Oracle: enhance, add EXPIRY_DATE in field info3 of table tsqw_UsersDb (for UserDb report)
- SQWareProdution for Oracle: enhance, add LOCK_DATE in field info4 of table tsqw_UsersDb (for UserDb report)
- SQWareRepository for All: enhance, add new versions support dates
- SQWareRepository for All: enhance, add tsqw_CommandPathVersion
- SQWareRepository for Oracle: enhance, modify end of support for Oracle 19c ...
- SQWareRepository for PostgreSQL: enhance, modify check and traces of PITR
- SQWareWeb for All: bugfix, menu display according to admin rights
- SQWareWeb for All: bugfix, run and kill jobs on demand for all users
- SQWareWeb for All: enhance, add a message when loading a job kill report
- SQWareWeb for All: enhance, add CmdPathVersion and LastCmdPathVersion reports
- SQWareWeb for All: enhance, add report of path and version for ksh, rsync, openssl, ...
- SQWareWeb for PostgreSQL: enhance, modify check of PITR (full/incr/diff)
- SQWareCentral for All: enhance, modify ref files generation
- SQWareProduction for All: enhance, add kill all childs
- SQWareProduction for All: enhance, add script sqwgen_KillAllChildsProcesses.ksh to kill all subprocesses from a parent PID
- SQWareProduction for PostgreSQL: bugfix, bypass gather Citus information when instance is in recovery mode
- SQWareProduction for PostgreSQL: bugfix, ignore error on gather alerlog path when RDS env
- SQWareProduction for PostgreSQL: enhance, some adjust for EnterpriseDB Advanced/Extended
- SQWareWeb for All: bugfix, correct api array for php 5.3
hange column name)
- SQWareCentral for All: enhance, add purge of tsqw_DetectDatasInstance, tsqw_DetectDatasObj1 and tsqw_DetectDatasObj2 (future module SQWarePredict)
- SQWareCentral for All: enhance, add purge of tsqw_PredictDatasInstance, tsqw_PredictDatasObj1 and tsqw_PredictDatasObj2 (future module SQWarePredict)
- SQWareProduction for All: bugfix, correction of duration compute
- SQWareProduction for MsSql: bugfix, rebuild script when mix partitionned/nonepartitionned indexes
- SQWareProduction for MySQL: bugfix, fix the issue on sqwmys_RestoreDatabase.ksh which generates "lfsqw_RestoreDatabase[235]: lfsqw_ExecRestoreDatabase[189]: 8: not found"
- SQWareProduction for MySQL: bugfix, for MariaDB 10.10 must stay 101 not 10010 ...
- SQWareProduction for MySQL: bugfix, suppress message "mysql: Deprecated program name." for MariDB >= 11.x
- SQWareProduction from MongoDB: enhance, get more parameters when gather indicators
- SQWareRepository for All: bugfix, increase token size for tsqw_TokenDynamic tsqw_TokenStatic tsqw_AuditToken tsqw_AuditConnectionsApi
- SQWareRepository for All: enhance, add comment column to tsqw_EndLife table for add if version is LTS or not
- SQWareRepository for All: enhance, add is_foradmin and is_forweb column on tsqw_AdminLogins and tsqw_AdminGroups to prepare SQWareAdmin (future module SQWareAdmin)
- SQWareRepository for All: enhance, add tables tsqw_DetectDatasInstance, tsqw_DetectDatasObj1 and tsqw_DetectDatasObj2 for detect of SQWarePredict module (future module SQWarePredict)
- SQWareRepository for All: enhance, add tables tsqw_PredictDatasInstance, tsqw_PredictDatasObj1 and tsqw_PredictDatasObj2 for predict of SQWarePredict module (future module SQWarePredict)
- SQWareRepository for All: enhance, add tadm_AccessLoginsCache for SQWareAdmin
- SQWareRepository for All: enhance, add viewes vadm_AdminAllTypesGroupsLoginsPrivs, vadm_AdminAllGroupsLoginsPrivs and vadm_AdminAllLoginsAccess to prepare SQWareAdmin (future module SQWareAdmin)
- SQWareRepository for All: enhance, modify viewes vsqw_AdminAllTypesGroupsLoginsPrivs, vsqw_AdminAllGroupsLoginsPrivs and vsqw_AdminAllLoginsAccess to prepare SQWareAdmin (future module SQWareAdmin)
- SQWareWeb for All: bugfix, empty message when deleting-updating Db Alias
- SQWareWeb for All: bugfix, empty results api key
- SQWareWeb for All: enhance, add access management to SQWareWeb and SQWareAdmin for groups and logins (future module SQWareAdmin)
- SQWareWeb for All: enhance, add tokens for SQWareWeb and SQWareAdmin (future module SQWareAdmin)
- SQWareWeb for All: enhance, create api for SQWareWeb and SQWareAdmin authentification (future module SQWareAdmin)
- SQWareWeb for All: enhance, modify EndLife reports for add if version is LTS or not
- SQWareCentral for All: bugfix, format mail when error on exec on demand job
- SQWareCentral for All: enhance, add examples for param variables gvsqw_RsyncProtocol_MyHost and gvsqw_RsyncPath_MyHost
- SQWareCentral for All: enhance, exec UpdateApiList when dbspatch
- SQWareCentral for All: enhance, modify vmsqwarebox by localhost in some example parfiles
- SQWareProduction for MongoDB: bugfix, modify modify gen databases list for version <= 3.2
- SQWareProduction for MongoDB: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
- SQWareProduction for MsSql: bugfix, correction of "Error, can't read gvsqw_MssqlPassFile='' !!!"
- SQWareProduction for MsSql: enhance, add detail for login if 'SQL_LOGIN' or 'WINDOWS_LOGIN'
- SQWareProduction for MsSql: enhance, detect (and print) if we are on RDS SQL
- SQWareProduction for MsSql: enhance, don't collect users if RDS SQL (can't execute "EXECUTE AS LOGIN = '$lvsqw_Login'")
- SQWareProduction for MsSql: enhance, for gather file and log size use 'sys.dm_db_file_space_usage' and 'sys.dm_db_log_space_usage' instead of 'DBCC showfilestats' and 'DBCC LOGINFO' for version>=2012
- SQWareProduction for MsSql: enhance, just warning when collect jobs info if RDS SQL (rights on msdb.dbo.sysjobs, msdb.dbo.sysjobsteps, msdb.dbo.sysjobhistory)
- SQWareProduction for MsSql: enhance, just warning when gather structures for version<=2000
- SQWareProduction for PostgreSQL: bugfix, add "datallowconn!='f'" where clause when generate db list
- SQWareWeb for All : enhance, add logs for update instance in Repository
- SQWareWeb for All : enhance, add mass update for Repository
- SQWareWeb for All : bugfix, change param in files of OnDemandJobs
- SQWareWeb for PostgreSQL: enhance, add IsInRecovery reports (unit and all)
- SQWareCentral for PostgreSQL: enhance, add purge of tsqwpg_CitusTables table
- SQWareCentral for PostgreSQL: enhance, add purge of tsqwpg_Extensions and tsqwpg_ExtensionsChanges tables
- SQWareProduction for All: bugfix, Global.lib exit code 22 (instead 0) when can't retrieve return code on script
- SQWareProduction for Oracle: bugfix, modify RMAN script for backup controlfiles on windows ...
- SQWareProduction for PostgreSQL: bugfix, modify PITR to support conf files with space like 'C:\Program Files\...'
- SQWareProduction for PostgreSQL: enhance, add collect extensions and extensions changes indicators
- SQWareProduction for PostgreSQL: enhance, add collect of citus tables indicators
- SQWareProduction for PostgreSQL: enhance, add collect of partitionned tables (before, only partitions report)
- SQWareProduction for PostgreSQL: enhance, modify CopyDump scripts to accept all formats p,t,c,d
- SQWareProduction for PostgreSQL: enhance, modify Dump scripts to accept all formats p,t,c,d
- SQWareRepository for All: bugfix drop index on tsqw_JobsOnDemandFollow (double)
- SQWareRepository for PostgreSQL: enhance, add tsqwpg_CitusTables table
- SQWareRepository for PostgreSQL: enhance, add tsqwpg_Extensions and tsqwpg_ExtensionsChanges tables
- SQWareWeb for PostgreSQL: enhance, add reports for citus tables indicators
- SQWareWeb for PostgreSQL: enhance, add reports for extensions and extensions changes in all and unit views
- SQWareProduction for Oracle: enhance, modify RMAN Clone for SBT_TAPE
- SQWareProduction for Oracle: enhance, modify "shutdown immediate" by "shutdown abort" in MenuRman
- SQWareProduction for Oracle: enhance, suppress "format" option when SBT_TAPE in RmanBackup script (for VEEAM lib usage for example)
- SQWareProduction for PostgreSQL: bugfix, add shebang for Debian that run sh for PITR script
- SQWareRepository for All: bugfix, maintain table list to update
- SQWareRepository for All: enhance, add GenerateCreateNewTableDbaliasDate script
- SQWareWeb for All: bugfix, maintain table list to update (dbalias)
- SQWareCentral for All: bugfix, escape of quotes for parameter tracing for sqwScheduler
- SQWareCentral for All: bugfix, modify reset var order in sqwScheduler
- SQWareCentral for All: bugfix, OnDemandJobKiller kill with 31 instead of 51 (pb with old Solaris version)
- SQWareCentral for All: enhance, global review of help (-h)
- SQWareCentral for All: enhance, global review of sample (-s)
- SQWareProduction for All: bugfix, Global lib, modify trap with 31 instead of 51 (pb with old Solaris version)
- SQWareProduction for All: bugfix, modify gfsqw_GiveTraceCounterAndFile in InsertIndicators lib (pb trap errors)
- SQWareProduction for All: enhance, augment verbosity of debug for Global lib
- SQWareProduction for All: enhance, augment verbosity of debug for InsertIndicators lib
- SQWareProduction for All: enhance, global review of help (-h)
- SQWareProduction for All: enhance, global review of sample (-s)
- SQWareProduction for PostgreSQL: enhance, add -Concurrently and -NoConcurrently options for ReindexAllDatabases and ReindexDatabase scripts
- SQWareProduction for PostgreSQL: enhance, add gvsqw_Concurrently=Enable variable to globaly activate CONCURRENTLY for ReindexDatabase script
- SQWareProduction for PostgreSQL: enhance, modify gvsqw_DropTmpIndexes=Disable to gvsqw_DropTmpIndexes=Enable
- SQWareRepository for All: bugfix, modify update demo for tsqw_GenHisto
- SQWareRepository for All: enhance, modify PK of tsqw_VolBackups to add bck_type
- SQWareCentral for All: bugfix, add check option to sqwScheduler
- SQWareCentral for All: bugfix, modify formatting return code
- SQWareCentral for All: bugfix, replace ls by find for search AsyncFiles
- SQWareCentral for All: enhance, add ExecFromSQWareWeb to exec scripts from SQWareWeb
- SQWareCentral for All: enhance, add purge of tables tsqw_AuditJobsOnDemandParam, tsqw_AuditJobsOnDemandSchedule and tsqw_JobsOnDemandFollow
- SQWareCentral for All: enhance, add restart sqwScheduler when dbspatch
- SQWareCentral for All: enhance, take into acount EndDate for all check exceptions in morning mail
- SQWareCentral for All: functionality, add deamon sqwScheduler to exec OnDemandJobs
- SQWareCentral for All: functionality, add script sqwctl_ExecOnDemandJob.ksh to exec OnDemandJobs
- SQWareCentral for All: functionality, add sqwctl_ExecOnDemandJobKiller.ksh for kill on demand job from SQWareWeb
- SQWareCentral for MongoDB: bugfix, for check db backup when status "KEEP"
- SQWareCentral for MongoDB: enhance, add check backup in morning report
- SQWareCentral for MySQL: enhance, add follow of perf files volumetry
- SQWareCentral for PostgreSQL: bugfix, for check db backup when status "KEEP"
- SQWareCentral for SQWareRepository: enhance, add follow of SQWareRepository version in tsqw_RepositoryVersion
- SQWareCentral for Sybase: bugfix, for check db backup when status "KEEP"
- SQWareProduction for All: bugfix, modify formatting return code
- SQWareProduction for All: bugfix, replace ls by find for search AsyncFiles
- SQWareProduction for All: bugfix, take into acount parameters name with more than on space
- SQWareProduction for All: enhance, modify trap in Global lib to preserve log
- SQWareProduction for MongoDB: bugfix, modify gen list databases in gather indicator (when multiple node)
- SQWareProduction for MongoDB: enhance, autodetect if we are on primary or not
- SQWareProduction for MongoDB: enhance, exclude "config" database from backup because of rights issue
- SQWareProduction for MongoDB: enhance, modify mongosh usage when available
- SQWareProduction for MongoDB: enhance, use 'show dbs' to list db and enhance errors management
- SQWareProduction for Mssql: bugfix, take into acount database name with more than on space in Global lib and gather indicators
- SQWareProduction for MsSql: enhance, add 'PARTITION = ALL' when rebuild not partitionned index (better result)
- SQWareProduction for MySQL: bugfix, use 'show global variables' instead of 'show variables' in indicators and rotate slowquery
- SQWareProduction for PostgreSQL: enhance, generate drop tmp indexes even if rebuild indexes fail
- SQWareProduction for Sybase: enhance, add exclude 'proxy database', 'has proxy database', 'user created tempdb', 'archive databases' by default from gen list db
- SQWareRepository for All: enahance, add tsqw_AuditJobsOnDemandPrivs
- SQWareRepository for All: enhance, add column EndDate to tsqw_VolBackupsThreshold, tsqw_VolBackupsExclude, tsqw_VolBackupsExcludeDb, tsqw_VolBackupsExcludeGlobalDb, tsqw_VolThreshold
- SQWareRepository for All: enhance, add table tsqw_JobsOnDemandFollow to follow OnDemandJobs execution
- SQWareRepository for All: enhance, add table tsqw_JobsOnDemandParam and tsqw_AuditJobsOnDemandParam to param OnDemandJobs
- SQWareRepository for All: enhance, add table tsqw_JobsOnDemandPrivs to manage OnDemandJobs privilleges
- SQWareRepository for All: enhance, add table tsqw_JobsOnDemandSchedule and tsqw_AuditJobsOnDemandSchedule to schedule OnDemandJobs
- SQWareRepository for All: enhance, add tsqw_JobsOnDemandStatus and tsqw_JobsOnDemandStatusTranslate
- SQWareRepository for Oracle: enhance, Modify support date for 19c and 21c (MOS Doc ID 742060.1)
- SQWareRepository for PostgreSQL: bugfix, table_rows column of tsqwpg_VolTables to accept more than 10 billion
- SQWareRepository for SQWareCentral: enhance, add table tsqw_RepositoryVersion to follow version
- SQWareWeb for All: enhance, add column EndDate in CheckBackups and Thresholds
- SQWareWeb for All: enhance, add jobupid and jobpidctl in reports batches execution (to spot JobsOnDemand)
- SQWareWeb for All: enhance, add unit/OnDemandJobs and all/AllOnDemandJobs in jobs menu
- SQWareWeb for All: enhance, modify or in menu 2 to be more efficient
- SQWareWeb for All: enhance, take into acount EndDate for all check exceptions reports
- SQWareWeb for All: functionality, add JobsParam, JobsParamPrivs and JobsSchedule report and admin
- SQWareWeb for All: functionality, add kill in JobsSchedule
- SQWareWeb for All: functionality, add reports OnDemandJobs and AllOnDemandJobs to display OnDemandJobs execution traces
- SQWareWeb for MongoDB: bugfix, for check db backup when status "KEEP"
- SQWareWeb for PostgreSQL: bugfix, for check db backup when status "KEEP"
- SQWareWeb for SQWareCentral: enhance, add AsyncFiles and PerfFiles report to follow volumetry of log, sql and perf files
- SQWareWeb for SQWareRepository: enhance, add SQWareRepositoryVersions and SQWareRepositoryFiles report to follow SQWareRepository patches
- SQWareWeb for Sybase: bugfix, for check db backup when status "KEEP"
Major Versions 2023
- SQWareProduction for All: bugfix, modify test in .profile_confort to avoid return code 1
- SQWareProduction for All: enhance, add somme future reports for perf (Monitor*)
- SQWareProduction for All: functionality, add script sqwgen_FailWithoutMail
- SQWareProduction for MsSql: enhance, add trace backup footprint
- SQWareProduction for Oracle: bugfix, about ExpdpAllSchemas script (for sysdba connection and CDB env)
- SQWareProduction for Oracle: enhance, add script ExpdpAllPDB script to datapump all PDB in //
- SQWareProduction for Oracle: enhance, add traces in SQWareRepository for all types of dmpdp
- SQWareProduction for PostgreSQL: bugfix, add double quotes when generate drop commands
- SQWareProduction for PostgreSQL: bugfix, supp mail 'no clean' when PgIsInRecovery='true' for PITR
- SQWareProduction for PostgreSQL: enhance, add -DropTmpIndexes option to drop if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
- SQWareProduction for PostgreSQL: enhance, add gvsqw_DropTmpIndexes variable to force to drop or not if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
- SQWareProduction for PostgreSQL: enhance, add -NoDropTmpIndexes option to disable drop if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
- SQWareProduction for Sybase: bugfix, modify test MajorVersion in GatherStructure
- SQWareWeb for All: bugfix, allow modification of a user's password by an admin external_ad
- SQWareWeb for All: bugfix, modify rights on GlobalGrowth and ReportFS reports
- SQWareWeb for All: enhance, allow entering '$' and '#' in Administration
- SQWareWeb for All: enhance, code optimization for actions and languages in Administration
- SQWareCentral for All: enhance, add ability to force protocol for rsync ex "export gvsqw_RsyncPath_=--rsync-path=/usr/local/bin/rsync"
- SQWareCentral for All: enhance, add ability to force protocol for rsync ex "export gvsqw_RsyncProtocol_MyHost=--protocol=26"
- SQWareProduction for All: bugfix, structure changes not work since 2023.03 ...
- SQWareProduction for Oracle, bugfix: about ExpdpAllSchemas script
- SQWareProduction for Oracle: bugfix, indicators when datafile name contain \n \r or is missing
- SQWareProduction for Oracle: bugfix, modify purge of dmpdp files because Oracle put files in upper case on windows
- SQWareProduction for Sybase: enhance, add -LtmIgnore option to execute "dbcc settrunc (ltm,ignore)" after load
- SQWareRepository for Oracle: bugfix, modify clone RMAN script when RMAN directory is a symbolic link (for find command)
- SQWareRepository for PostgreSQL: bugfix, modify generation of backup_label file in PITR script (wall file apear when start by an upper letter, ex : FD/23000028)
- SQWareWeb for All: bugfix, init NbDays in SQWareCentral after timeout
- SQWareWeb for All: bugfix, modify reports AllIndexesChanges, AllStructuresChanges and AllTablesChanges
- SQWareWeb for All: enhance, add AllSchemes reports in "all" category
- SQWareWeb for All: enhance, add AllSchemes reports in "unit" category
- SQWareWeb for All: enhance, add AllStructuresLastStatusAsync reports in "all" category
- SQWareWeb for All: enhance, add AllStructuresStatusAsync reports in "all" category
- SQWareWeb for All: enhance, add AllStructuresStatusAsync reports in "unit" category
- SQWareWeb for All: enhance, add detail in compare structure reports
- SQWareWeb for All: enhance, add traces in apiOut
- SQWareCentral for All: enhance, add purge of tsqw_GenPathInfos
- SQWareProduction for Adabas: enhance, add PathInfos reports
- SQWareProduction for Adabas: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for All: enhance, add gfsqw_GatherPathInfos to follow var, logical path and physical path
- SQWareProduction for All: enhance, add PathInfos reports
- SQWareProduction for DB2: enhance, add PathInfos reports
- SQWareProduction for DB2: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for MongoDB: enhance, add PathInfos reports
- SQWareProduction for MongoDB: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for MongoDB: enhance, modify CopyDump script to not delete files included in copy list and use rsync
- SQWareProduction for MsSql: bugfix, modify retrieve method for hostname in gather indicators
- SQWareProduction for MySQL: enhance, add CopyMariaBackup script
- SQWareProduction for MySQL: enhance, add CopyXtraBackup script
- SQWareProduction for MySQL: enhance, add PathInfos reports
- SQWareProduction for MySQL: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for MySQL: enhance, modify CopyDump script to not delete files included in copy list and use rsync
- SQWareProduction for MySQL: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
- SQWareProduction for MySQL: enhance, -OptionsBeforeMySQL in restore scripts to put additional options before mysql command (by default, $gvsqw_OptionsBeforeMySQL)
- SQWareProduction for MySQL: enhance, -OptionsMySQL in restore scripts to put additional options during mysql command (by default, $gvsqw_OptionsMySQL)
- SQWareProduction for Oracle: bugfix, source env in sqwora_RmanClone for source
- SQWareProduction for Oracle: enhance, add PathInfos reports
- SQWareProduction for Oracle: enhance, add script ExpdpAllSc^Cmas to datpump all schemas one by one in //
- SQWareProduction for Oracle: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for PostgreSQL: enhance, add PathInfos reports
- SQWareProduction for PostgreSQL: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for PostgreSQL: enhance, modify CopyDump script to not delete files included in copy list and use rsync
- SQWareProduction for PostgreSQL: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
- SQWareProduction for Sybase: enhance, add PathInfos reports
- SQWareProduction for Sybase: enhance, add TestInstConnection script
- SQWareProduction for Sybase: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
- SQWareProduction for Sybase: enhance, modify CopyDump script to not delete files included in copy list and use rsync
- SQWareRepository for All: enhance, add table tsqw_GenPathInfos to insert var, logical path and physical path
- SQWareCentral for PostgreSQL: enhance, modify check backup for standby when not required
- SQWareProduction for All: bugfix, add touch to not rmdir ...
- SQWareProduction for All: enhance, add traces to debug (export gvsqw_Debug=true to use it)
- SQWareProduction for All: enhance, collect CPU number, type ... for Solaris
- SQWareProduction for DB2: bugfix, add "db2 connect ..." in Reorganize because lost connection due to "tee" for log
- SQWareProduction for DB2: bugfix, add "db2 connect ..." in RunStats because lost connection due to "tee" for log
- SQWareProduction for MsSql: bugfix, lfsqw_BackupPath in sqwmsq_TestInstConnection.ksh
- SQWareProduction for MsSql: bugfix, modify AlterDatabaseModifyLogGrowth to exclude offline and snapshot databases
- SQWareProduction for MsSql: bugfix, modify AlterDatabaseRecoverySimple to exclude offline and snapshot databases
- SQWareProduction for MsSql: bugfix, modify AlterDatabaseShrinkLogs to exclude offline and snapshot databases
- SQWareProduction for MsSql: enhance, add -AllFull option to BackupAllDatabases script to select all databases with RECOVERY=FULL (for backup log)
- SQWareProduction for MySQL: bugfix, take into account flag -F in restore script
- SQWareProduction for Oracle: bugfix, modify query when collect indicators on offline datafiles in multi-tenant architecture
- SQWareProduction for Oracle: bugfix, suppress "JOIN" in query for collect indexes infos when version <= 8i
- SQWareProduction for PostgreSQL: enhance, add -ForceDump option to force dump when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add -ForcePitr option to force PITR when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add gvsqw_ForceDump variable to force dump when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add gvsqw_ForcePitr variable to force PITR when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add -NoForceDump option to disable force dump when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add -NoForcePitr option to disable force PITR when cluster is in recovery
- SQWareProduction for PostgreSQL: enhance, add xlog/wal replay pause when PITR standby
- SQWareRepository for All: enhance, add column BckSlave to tsqw_VolBackupsThresholdDef and tsqw_VolBackupsThreshold to ask or not check on standby
- SQWareRepository for All: enhance, add table tsqw_VolBackupsExcludeAuto to exclude standby for backup check when not required
- SQWareRepository for PostgreSQL: enhance, add tsqwpg_IsInRecoveryHisto and tsqwpg_IsInRecovery to trace if PG is in recovery mode
- SQWareWeb for All: enhance, add management of BckSlave on VolBackupsThresholdDef and VolBackupsThreshold menu to ask or not check on standby
- SQWareWeb for All: enhance, add new column (Backup Standby) in CheckBackups
- SQWareCentral for All: enhance, add ReportSupport script to send support dates of DBMS
- SQWareCentral for Oracle: enhance, add check 'expdp full' in morning check
- SQWareProduction for All: bugfix, modify gather OS indicators
- SQWareProduction for MongoDB: enhance, add support for v6.0 1/4: run mongosh instead of mongo command
- SQWareProduction for MongoDB: enhance, add support for v6.0 2/4: add (prompt = ""; ) to suppress prompt display
- SQWareProduction for MongoDB: enhance, add support for v6.0 3/4: call 'setReadPref("primaryPreferred")' instead of setSecondaryOk() because deprecated
- SQWareProduction for MongoDB: enhance, add support for v6.0 4/4: output contain now ' instead of "
- SQWareProduction for MsSql: bugfix, add 'where bck.is_snapshot=0 and bck.is_copy_only=0' when collect backup traces
- SQWareProduction for MySQL: bugfix, suppress options before $gvsqw_ConnectString to accept "--defaults-file" in GatherIndicators
- SQWareProduction for Oracle: bugfix, add alter "session set NLS_NUMERIC_CHARACTERS='.,'" because NLS_NUMERIC_CHARACTERS var don't work in all cases ...
- SQWareProduction for Oracle: bugfix, modify gather PDB and TBS indicators for DG in multi-tenant
- SQWareProduction for Oracle: enhance, add trace of 'expdp full' (for check backups)
- SQWareProduction for PostgreSQL: bugfix, check if pg_is_in_recovery
- SQWareProduction for PostgreSQL: bugfix, "fast => TRUE" for PITR (>=15)
- SQWareProduction for Sybase: bugfix, modify search of dump to load with flag
- SQWareRepository for All: bugfix, extend fields in tsqw_GenHostInfos
- SQWareRepository for All: bugfix, modify size of HostRelease col in tsqw_GenHostInfos
- SQWareRepository for All: bugfix, put binary mode on database_name and username fields on tsqw_UsersDb
- SQWareRepository for All: bugfix, put database_name and username cols case sensitive in tsqw_UsersDb
- SQWareWeb for All: enhance, add support PHP 8.2
- SQWareWeb for All: enhance, load log and mail files for apiAudit jobs
- SQWareWeb for Oracle: enhance, add check 'expdp full'
- SQWareCentral for All: enhance, add banner
- SQWareCentral for Oracle: bugfix, add "echo" to avoid error when no instance on host for StartedInstances
- SQWareProduction for All: bugfix, return underlying code of executed command instead of 12 in RunJob script
- SQWareProduction for Cassandra: bugfix, modify Global.lib to trap version (to ignore for example "Picked up JAVA_TOOL_OPTIONS ...")
- SQWareProduction for MsSql: bugfix, add "PARTITION=$lvsqw_IndexPartitionNumber" when IndexPartitionNumber > 1 in RebuildIndex script
- SQWareProduction for MsSql: bugfix, exclude objects with special caracters [ or ] in RebuildIndex script
- SQWareProduction for MsSql: enhance, add -SizeMaxIndex option and gvsqw_SizeMaxIndexRebuild variable to take into account indexes <= $gvsqw_SizeMaxIndexRebuild Mb
- SQWareProduction for MsSql: enhance, add -SizeMinIndex option and gvsqw_SizeMinIndexRebuild variable to take into account indexes >= $gvsqw_SizeMinIndexRebuild Mb
- SQWareProduction for MySQL: bugfix, passwd masking in log messages
- SQWareProduction for Oracle: bugfix, add "exit" when collect DBMS_STATS datas to avoid blocking sqlplus
- SQWareProduction for PostgreSQL: bugfix, use pg_backup_start and pg_backup_stop (instead of pg_start_backup and pg_stop_backup) in PITR script for version >= 15
- SQWareProduction for PostgreSQL: enhance, use the non-exclusive backup (pg_start_backup/pg_backup_start) in PITR script for version >= 9.6
- SQWareRepository for All: enhance, add column rdbmstype to tsqw_LinkDbApplication
- SQWareRepository for Oracle: enhance, modify PK on tsqwora_DbmsStats (param_name not null)
- SQWareWeb for All: enhance, add free field for dbalias in linkDbApplication
- SQWareWeb for All: enhance, add support PHP 8.1
- SQWareWeb for All: enhance, modify strict join by like join on dbalias in reports LinksDbApplication, LinksDbApplicationStrict, LinksDbApplicationCompact (all and unit)
- SQWareWeb for MsSql: bugfix, display for LackBackupsJustified
- SQWareCentral for All: enhance, add CheckRunningDBMS script to find running DBMS on hosts
- SQWareCentral for All: enhance, add follow SqlFiles
- SQWareCentral for MsSql: bugfix, replacement of ins_date by ins_date to handle the case where ins_date is different in tsqwmsq_Files when check spaces
- SQWareCentral for Oracle: enhance, add purge of tsqwora_Ctlfiles and tsqwora_Logfiles
- SQWareCentral for Oracle: enhance, add purge of tsqwora_DbmsStats
- SQWareProduction for All: bugfix, add "eval" in gfsqw_ExecCommandTeeReturnCode (thks Luc for the report)
- SQWareProduction for MongoDB: enhance, add collect of adminCommand.getParameter when collect parameters indicators
- SQWareProduction for MySQL: bugfix, add \" when call gvsqw_RsyncOptions in sqwmys_CopyDumpDatabase.lib (thks Luc for the report)
- SQWareProduction for MySQL: enhance, modify maj version for MariaDB case (add 0 at the end of major version because version 10.10 for exemple ...) => 10.5 not 105 but 1005, 10.10 not 1010 but 10010
- SQWareProduction for MySQL: enhance, split collect database and users indicators to avoid errors
- SQWareProduction for Oracle: enhance, add collect of controlfiles
- SQWareProduction for Oracle: enhance, add collect of DBMS_STATS default parameters
- SQWareProduction for PostgreSQL: enhance, modify sqwpg_GatherStructure.lib to load in tsqwpg_AllIndexesTempo indexes like %ccnew% or %ccold%
- SQWareRepository for Oracle: enhance, add tsqwora_Ctlfiles
- SQWareRepository for Oracle: enhance, add tsqwora_DbmsStats
- SQWareRepository for PostgreSQL: enhance, add table tsqwpg_AllIndexesTempo to trace indexes %ccnew% or %ccold% created when REINDEX CONCURRENTLY and fail to drop them
- SQWareWeb for All: enhance, add report to follow SqlFiles
- SQWareWeb for MongoDB: bugfix, replacement of NbDays=5 by NbMonth=12 when call all/parameters/ParametersChanges.html (in menu2)
- SQWareWeb for Oracle: enhance, add reports (unit + all) of controlfiles and redologs
- SQWareWeb for Oracle: enhance, add reports (unit + all) of DBMS_STATS default parameters
- SQWareWeb for PostgreSQL: enhance, modify reports AllTempIndexes and TempIndexes to view contents of tsqwpg_AllIndexesTempo
- SQWareCentral for MongoDB: bugfix, modify sqwmng_GenLstUniqueNew.sql
- SQWareProduction for All: bugfix, modify call to gfsqw_EndMailError when tee
- SQWareProduction for All: bugfix, modify gfsqw_EndTrt + gfsqw_ExitTrt because tee prevents variable retrieval (suddenly, the script always exits in code 0)
- SQWareProduction for All: enhance, add lfsqw_ArchivingParameters fonction to exclude parameters from change tracking
- SQWareProduction for DB2: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for MongoDB: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for MsSql: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for MySQL: bugfix, trap "no version information available" message when check version
- SQWareProduction for MySQL: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for Oracle: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for PostgreSQL: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for Sybase: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareProduction for SybRs: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
- SQWareRepository for All: enhance, add table tsqw_ParametersChangesExclude (to exclude parameters from change tracking)
- SQWareRepository for All: enhance, add table tsqw_UsersDbAddInfos (to add user information in reports)
- SQWareWeb for All: enhance, add 'ChangementsParametresExclusion' tab in Jobs
- SQWareWeb for All: enhance, add 'UserAjoutInfos' tab in Jobs
- SQWareWeb for All: enhance, add distribution report dbms/Customer
- SQWareWeb for All: enhance, add distribution report dbms/env
- SQWareWeb for All: enhance, add management of ParametersChangesExclude (to exclude parameters from change tracking)
- SQWareWeb for All: enhance, add management of UserAddInfos (to add user information in reports)
- SQWareWeb for All: enhance, modify reports InventoryUsers and InventoryUsersFiltered to add user informations contained in tsqw_UsersDbAddInfos
- SQWareCentral for All: enhance, add tee and suppress tail for log management in all scripts (big change, need adapt your custom scripts!)
- SQWareProduction for All: enhance, add tee and suppress tail for log management in all scripts (big change, need adapt your custom scripts!)
- SQWareProduction for All: enhance, change log name for RunJob to ${lvsqw_Action}_${gvsqw_DateFullIso}_${gvsqw_GlobalPid}.log
- SQWareProduction for MsSql: enhance, Management of a lock file to avoid two backups of the same type at the same time
- SQWareProduction for MySQL : bugfix, modif gather indicator global vol, don't work in MariaDB 10.6, bug ?
- SQWareProduction for PostgreSQL: enhance, add CopyDumpAllDatabases to run CopyDumpDatabase in //
- SQWareProduction for PostgreSQL: enhance, add CopyDumpDatabase script to copy dump between to host (get and put methods)
- SQWareProduction for PostgreSQL: enhance, add RestoreAllDatabases to run RestoreDatabase in //
- SQWareProduction for PostgreSQL: enhance, add RestoreDatabase script to restore database dump made by pg_dump
- SQWareProduction for PostgreSQL: enhance, BackupArchiveXlog use pigz if installed instead of gzip (use "export gvsqw_ArchiveXlogPigzMaxProc=x" to limit the number of processes to x)
- SQWareProduction for PostgreSQL: enhance, BackupPitr use pigz if installed instead of gzip (use "export gvsqw_PitrPigzMaxProc=x" to limit the number of processes to x)
- SQWareProduction for PostgreSQL: enhance, disable Analyze, Reindex, Vacuum, BackupPitr jobs when pg_is_in_recovery=true
- SQWareProduction for PostgreSQL: enhance, DumpAllDatabases use pigz if installed instead of gzip (use "export gvsqw_DumpPigzMaxProc=x" to limit the number of processes to x)
- SQWareRepository for All: bugfix, alter tsqw_LinkDbApplication to make database_name case sensitive
- SQWareWeb for All: bugfix, sql error for audit changes in tsqwRepository with mysql
- SQWareWeb for All: bugfix, translation 3 labels for repository
Major Versions 2022
- SQWareProduction for DB2: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for Ingres: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for MongoDB: bugfix, suppress info message for gather indicators tables
- SQWareProduction for MongoDB: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for Oracle: enhance, add gvsqw_RmanMkdirOption to control create backup RMAN directory
- SQWareWeb for Adabas: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Adabas: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for DB2: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for DB2: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Ingres: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Ingres: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MongoDB: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MongoDB: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MsSql: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MsSql: enhance, add reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MySQL: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for MySQL: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Oracle: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Oracle: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for PostgreSQL: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for PostgreSQL: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Sybase: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for Sybase: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareWeb for SybRs: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
- SQWareWeb for SybRs: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
- SQWareProduction for Adabas: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for DB2: enhance, add support of gather indicators for DB2i (AS400) with unixODBC
- SQWareProduction for MySQL: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for Oracle: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for PostgreSQL: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for Sybase: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareProduction for SybRs: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
- SQWareRepository for All: enhance, add tsqw_GenHostInfos table to store system infos
- SQWareWeb for All: enhance, add create icon
- SQWareWeb for All: enhance, API Update for JobsFollow
- SQWareCentral for All: enhance, add version + volumetry in RefInstance file
- SQWareCentral for All: enhance, add version in RefInst file
- SQWareProduction for MySQL : enhance, add options for sqwmys_MysqlAdmin.ksh and add script sqwmys_GaleraAdmin.ksh
- SQWareProduction for Oracle: bugfix, gather structures in multitenant architecture (bad exit)
- SQWareProduction for Oracle: enhance, add GetAlertFile tools + alt alisas
- SQWareProduction for Oracle: enhance, add option for "mkdir -p" on backup RMAN script
- SQWareProduction for PostgreSQL: bugfix, multiple corrections for PG 8.3... (-w option for psql and datcollate, datctype fields in pg_database)
- SQWareProduction for Sybase: enhance, suppress mail when "dump tran" fail but "dump inc" success
- SQWareProduction for Sybase: functionnality, add sqwsyb_UpdtStatsParallelDatabase.ksh for calculate statistics in // mode on tables
- SQWareRepository for All: bugfix, add ins_date column for tracking schema changes on empty tables
- SQWareRepository for All: enhance, add tables tsqw_AdminTokenDynamic, tsqw_AdminTokenStatic, tsqw_AuditToken, tsqw_AuditConnectionsApi
- SQWareWeb for All: access, add TokenStatic
- SQWareWeb for All: enhance, API Update (tsqw_Repository management)
- SQWareWeb for All: enhance, API indicators, trace backups
- SQWareWeb for All: enhance, API indicators, trace VolFS
- SQWareWeb for All: enhance, Audit tsqw_Repository UPDATE and DELETE methods
- SQWareProduction for All: bugfix, remove spurious messages
- SQWareProduction for MongoDB: bugfix, exclude 'local' from dump scripts
- SQWareProduction for MongoDB: enhance, modify dump script to accept not authenticated mongodump
- SQWareProduction for MongoDB: enhance, modify dump script to add traces when tar command fail
- SQWareProduction for MongoDB: enhance, modify dump script to choose tar or not after mongodump
- SQWareProduction for Sybase: enhance, add flag -TryCum for dump script (try cumulative when dump tran fail)
- SQWareWeb for All: bugfix, multi_bar php5.3
- SQWareWeb for All: enhance, external connection management (like AD)
- SQWareCentral for All: enhance, modif check FS to view only 1 alert by host and mount
- SQWareProduction for Oracle: bugfix, gather structures in multitenant architecture (bad exit)
- SQWareProduction for Oracle: bugfix, modify when overload "xxx as sysdba"
- SQWareProduction for Oracle: enhance, add open/close PDB$SEED to avoid backup purge when perform a full backup in multitenant architecture
- SQWareProduction for Oracle: functionnality, add sqwora_MonitorWithAwrLastStat.ksh script to generate csv of latests ratios
- SQWareProduction for PostgreSQL: bugfix, add 'always' when check archive_mode before PITR
- SQWareProduction for PostgreSQL: bugfix, add 'always' when check archive_mode before run sqwArchmon
- SQWareProduction for PostgreSQL: enhance, add info2=dbo in tsqw_UsersDb when user is "Owner"
- SQWareProduction for Sybase: enhance, add ddlgen devices + ddlgen databases + conf file when backup all
- SQWareProduction for Sybase: functionnality, add sqwsyb_UpdtStatsParallelDatabase.ksh for calculate statistics in // mode on tables
- SQWareRepository for All: enhance, add column interactive in tsqw_AdminLoginsTypes table
- SQWareRepository for All: enhance, add external_ad and internal_api_update authentication_type
- SQWareRepository for All: enhance, add tables tsqw_AuditRepository and tsqw_AuditConnections
- SQWareRepository for All: enhance, extend size of virt_host_name and host_name fields in tsqw_Repository
- SQWareRepository for All: enhance, modify size_limit, threshold_c and threshold_w in decimal on tsqw_VolThresholdDef and tsqw_VolThreshold tables
- SQWareWeb for All: enhance, add decimal for threshold in Admin
- SQWareWeb for All: enhance, field length enlargement : host in Admin
- SQWareWeb for All: enhance, functions to get clients infos
- SQWareWeb for All: enhance, internal authentication
- SQWareProduction for All: enhance, add variable gvsqw_MailSubjetForceCase to force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin)
- SQWareProduction for Cassandra: enhance, Maj supported versions in help (4.0)
- SQWareProduction for MongoDB: enhance, Maj supported versions in help (5.1)
- SQWareProduction for MySQL: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
- SQWareProduction for MySQL: bugfix, some replace of '\r' in cygwin env
- SQWareProduction for Oracle: bugfix, modify "with admin option" by "with grant option" in createdb.sql
- SQWareProduction for Oracle: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
- SQWareProduction for Oracle: bugfix, some replace of '\r' in cygwin env
- SQWareProduction for Oracle: bugfix, trap warning message expdp scripts like "ORA-39173: Encrypted data has been stored unencrypted in dump file set."
- SQWareProduction for Oracle: bugfix, trap warning message expdp scripts like "ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set."
- SQWareProduction for Oracle: enhance, Maj supported versions in help (21c)
- SQWareProduction for PostgreSQL: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
- SQWareProduction for PostgreSQL: bugfix, some replace of '\r' in cygwin env
- SQWareProduction for Sybase: enhance, add flag -AddFlagName for CopyDumpDatabase and CopyDumpAllDatabases scripts
- SQWareProduction for Sybase: enhance, add flag -AddFlagName for DumpDatabase and DumpAllDatabases scripts
- SQWareProduction for Sybase: enhance, add flag -AddFlagName for LoadDatabase and LoadAllDatabases scripts
- SQWareProduction for Teradata: enhance, Maj supported versions in help (15.x, 16.x, 17.x)
- SQWareRepository for Cassandra: enhance, Maj support dates (4.0)
- SQWareRepository for MongoDB: enhance, Maj support dates (5.1)
- SQWareRepository for Oracle: enhance, Maj support dates (21c)
- SQWareRepository for Teradata: enhance, Maj support dates (15.x, 16.x, 17.x)
- SQWareWeb for All : bugfix, allow . in url for Admin
- SQWareWeb for All: bugfix, get parameter NbDays for Central
- SQWareWeb for All: bugfix, Modify support dates display (were not displayed when no data)
- SQWareWeb for All: bugfix, Put footer links in https mode
- SQWareWeb for All: enhance, add option of percent in pie
- SQWareWeb for All: enhance, put MonthlyGrowthAll.chart in bar format
- SQWareWeb for Cassandra: enhance, Maj supported versions in help (4.0)
- SQWareWeb for MongoDB: enhance, Maj supported versions in help (5.1)
- SQWareWeb for Oracle: enhance, Maj supported versions in help (21c)
- SQWareWeb for Teradata: enhance, Maj supported versions in help (15.x, 16.x, 17.x)
Major Versions 2021
- SQWareCentral for MongoDB: enhance, modify to take into account "basic env" (no repli, no authent, ...)
- SQWareProduction for All: bugfix, modify compute of FS rate in indicators to be equal with "df"
- SQWareProduction for DB2: bugfix, modify gather alert log file
- SQWareProduction for MongoDB: enhance, add check connection script
- SQWareProduction for MongoDB: enhance, add user access to databases collect
- SQWareProduction for MongoDB: enhance, modify to take into account "basic env" (no repli, no authent, ...)
- SQWareProduction for MongoDB: enhance, take into account "no authent mode"
- SQWareProduction for MsSql: enhance, add filter on snapshot db (for backup, rebuild, ... "All"
- SQWareProduction for MsSql: enhance, add user access to databases collect
- SQWareProduction for MySQL: enhance, add collect of user/db to store in tsqw_UsersDb
- SQWareProduction for MySQL: enhance, add user access to databases collect
- SQWareProduction for Oracle: bugfix, some correction for windows+cygwin (place of tempfiles, name without :, ...)
- SQWareProduction for Oracle: enhance, add more detail when collect table, partition, subpartitions, ...
- SQWareProduction for Oracle: enhance, add more detail when select FS list
- SQWareProduction for Oracle: enhance, add more FS in indicators
- SQWareProduction for Oracle: enhance, add user access to databases collect
- SQWareProduction for PostgreSQL: enhance, add user access to databases collect
- SQWareProduction for PostgreSQL: enhance, take into account PG 14
- SQWareProduction for Sybase: enhance, add more FS in indicators
- SQWareProduction for Sybase: enhance, add user access to databases collect
- SQWareRepository for All: enhance, add tsqw_UsersDb table
- SQWareRepository for MsSql: bugfix, suppress "typeset -u" when retrieve instance arg
- SQWareRepository for Oracle: enhance, add tsqwora_Tab, tsqwora_TabPart,tsqwora_TabSubPart,tsqwora_Ind,tsqwora_IndCol,tsqwora_IndPart,tsqwora_IndSubPart tables
- SQWareWeb for All: bugfix, % on input for Admin
- SQWareWeb for All: enhance, add Oracle Cluster
- SQWareWeb for All: enhance, add userExclusion in Admin
- SQWareWeb for All: enhance, add userInclusion in Admin
- SQWareWeb for MongoDB: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareWeb for MsSql: enhance, add more detail in all databases report
- SQWareWeb for MsSql: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareWeb for MySQL: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareWeb for Oracle: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareWeb for PostgreSQL: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareWeb for Sybase: enhance, add more detail in all databases report
- SQWareWeb for Sybase: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
- SQWareCentral for All: bugfix, add check source profile to avoid error when non-interactive shell not source profile ! (cygwin for example)
- SQWareCentral for All: bugfix, modify gfsqw_ComputeDuration to take into account negative duration
- SQWareProduction for All: enhance, Add ability to mute sending mail with $HOME/sqwConfig/Mute.cfg
- SQWareProduction for All: enhance, Search 100% compatibility with ksh, bash and cygwin in sqwgen_Global.lib
- SQWareProduction for Cassandra: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for Generic: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for Ingres: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for MsSql: bugfix, modify rebuild and update stat script to support tables with simple quote or space in their name
- SQWareProduction for MsSql: enhance, modify gvsqw_RebuildType to 'index' by default for rebuild
- SQWareProduction for MsSql: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseModifyLogGrowth to modify logs growth in Mb instead of %
- SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseRecoverySimple to alter databases to "RECOVERY SIMPLE"
- SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseShrinkLogs to shrink all logs
- SQWareProduction for MySQL: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for Oracle: enhance, add set env example files for RAC/ASM or standalone oratab
- SQWareProduction for Oracle: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for PostgreSQL: enhance, add postgresql.conf files for 9.4, 9.5, 9.6, 10, 11, 12, 13
- SQWareProduction for PostgreSQL: enhance, modify "GenCreateInstance" to create directories and generate postgres.conf ...
- SQWareProduction for PostgreSQL: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareProduction for Sybase: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
- SQWareRepository for All: bugfix, extend duration column in tsqw_VolBackups, tsqw_JobsFollow and tsqw_VolTapeBackups
- SQWareRepository for MsSql: enhance, add support for database_name with spaces ! (replace spaces by underscores in filenames)
- SQWareWeb for All: bugfix, case of one curve on multi-curves
- SQWareWeb for All: bugfix, special case of one curve (multi-curves)
- SQWareWeb for All: enhance, add bar chart
- SQWareWeb for MsSql: bugfix, modify syntax for rebuild COLUMNSTORE indexes (suppress sort_in_tempdb option)
- SQWareProduction for DB2: bugfix, modify delete backups
- SQWareProduction for MsSql: enhance, add "BackupLog" in default generated sqwmsq_Jobs.cfg
- SQWareWeb for All: bugfix, case of one curve on multi-curves
- SQWareWeb for All: enhance, add choice between name and id of application in Admin_Links
- SQWareWeb for All: enhance, add the updating of user's rights
- SQWareWeb for All: enhance, add updating cache
- SQWareWeb for All: enhance, add updating rights in MenuManagement
- SQWareWeb for All: enhance, block entry of spaces in Admin
- SQWareWeb for All: enhance, button customization in Admin
- SQWareWeb for Cassandra: bugfix, modify bad link for InventoryNodes
- SQWareCentral for Adabas: enhance, add containers usage in the morning check
- SQWareCentral for All: enhance, add Async and Awr file volumetry follow
- SQWareProduction for All: enhance, add follow of repo changes (patch, upgrade, add) in tsqw_FollowRepoChanges
- SQWareProduction for MsSql: enhance, add collect of MsSql jobs from msdb
- SQWareProduction for MsSql: enhance, add collect of MsSql jobs stats exec per day and month
- SQWareProduction for Oracle: enhance, RAC mode for Awr monitor and generation
- SQWareProduction for Oracle: enhance, test if not connected to CDB in indicators script
- SQWareRepository for All: enhance, add table tsqw_SqlFollow
- SQWareRepository for All: enhance, add tsqw_AwrFollow and tsqw_AsyncFollow tables
- SQWareRepository for All: enhance, add tsqw_FollowRepoChanges table
- SQWareRepository for MsSql: enhance, add tsqwmsq_JobHistoryStats and tsqwmsq_JobHistoryStatsMonth tables
- SQWareRepository for MsSql: enhance, add tsqwmsq_Jobs, tsqwmsq_JobSteps and tsqwmsq_JobHistory tables
- SQWareRepository for Oracle: enhance, add instance_number in tsqwora_Awr% tables and views
- SQWareWeb for Adabas: enhance, add warning on containers usage
- SQWareWeb for All: bugfix, Admin Fields size
- SQWareWeb for All: bugfix, Right groups management
- SQWareWeb for All: enhance, add Sql insert report for unit
- SQWareWeb for All: enhance, add SqlErr report for all DBMS
- SQWareWeb for All: enhance, add SqlErr report for unit
- SQWareWeb for All: enhance, add the follow of Repo changes (status OFF and delete repo)
- SQWareWeb for All: enhance, Authentication Type
- SQWareWeb for All: enhance, Traduction
- SQWareWeb for MsSql: enhance, add reports on MsSql jobs setting and execution
- SQWareWeb for MsSql: enhance, add reports on MsSql jobs stats exec per day and month
- SQWareWeb for Oracle: enhance, RAC mode for Awr reports
- SQWareCentral for All: enhance, add UpdateApiList script
- SQWareProduction for MsSql: enhance, use 'wmic volume get name' instead of xp_fixeddrives to get mount point
- SQWareProduction for Oracle: enhance, add BlockChangeTracking collect
- SQWareProduction for Oracle: enhance, add EncryptedTablespaces collect
- SQWareRepository for Oracle: enhance, add tsqwora_BlockChangeTracking table
- SQWareRepository for Oracle: enhance, add tsqwora_EncryptedTablespaces table
- SQWareWeb for All: bugfix, modify query for adminCheckBackupDefaultNbDays
- SQWareWeb for All: bugfix, modify query for adminCheckBackupSpecificNbDays
- SQWareWeb for All: enhance, add API list report (in management view, admin only)
- SQWareWeb for All: enhance, add Daybook for Management (admin only)
- SQWareWeb for Oracle: enhance, add BlockChangeTracking reports (all + unit)
- SQWareWeb for Oracle: enhance, add EncryptedTablespaces reports (all + unit)
- SQWareCentral for MsSql: enhance, add var to manage timeout+textsize in freetds.conf generation
- SQWareProduction for All: enhance, modify eval global var to keep " in content
- SQWareProduction for MongoDB: bugfix, one ajustement in indicators script
- SQWareProduction for MsSql: enhance, add TestInstConnection script to test instance connection
- SQWareProduction for MySQL: enhance, add TestInstConnection script to test instance connection (local+dist)
- SQWareProduction for Oracle: bugfix, modify RMAN backup for Standby
- SQWareProduction for Oracle: enhance, add TestInstConnection script to test instance connection (local+dist)
- SQWareProduction for Oracle: enhance, 'show all' connected with catalog when available
- SQWareProduction for PostgreSQL: enhance, add TestInstConnection script to test instance connection (local+dist)
- SQWareRepository for All: enhance, add GeneralInfos and Daybook tables
- SQWareRepository for All: enhance, add table AdminLoginsTypes to manage type of user
- SQWareRepository for Oracle: enhance, add table tsqwora_RepositoryClusters to manage ASM clusters
- SQWareWeb for All: enhance, add ins_date in Admin
- SQWareWeb for All: enhance, add help for Table and Chart
- SQWareWeb for All: enhance, add GeneralInfos for Management (admin only)
- SQWareWeb for All: enhance, add management in menu2 (all and unit)
- SQWareWeb for All: enhance, add online help for tables and charts
- SQWareWeb for MsSql: bugfix, modify LackBackupsDb.table and LackBackupsDbJustified.table
- SQWareWeb for Oracle: enhance, add InventoryPdb in all/various
- SQWareWeb for Oracle: enhance, add reports on ASM DG (unit and all)
- SQWareWeb for Oracle: enhance, move *DbaFeature* *DbaRegistry* *DbLinks* *MaxLog* *DgStatus* *RegistryHistory* from all/overview to all/various
- SQWareCentral for All: enhance, add trace of dbSQWare version on DBMS level
- SQWareCentral for All: enhance, some adjusts in HTML format mails
- SQWareProduction for All: enhance, add trace of dbSQWare version on DBMS level
- SQWareProduction for Oracle: bugfix, modify connect string in RMAN Clone (wallet)
- SQWareProduction for Oracle: bugfix, modify some indicators for Oracle 8i ...
- SQWareRepository for All: bugfix, modify url masking for avoid "Illegal mix of collations for operation 'concat'"
- SQWareWeb for All: enhance, add API REST engine (more than 1400 reports available)
- SQWareWeb for All: enhance, change css checkbox (right access)
- SQWareWeb for All: enhance, add custom2 and custom3 in menu2 (all and unit)
- SQWareWeb for Oracle: enhance, add reports in unit/growth OraInstanceInfos, OraDatabaseInfos (like all)
- SQWareWeb for Oracle: enhance, add reports in unit/tablespaces TablespacesInfo, DatafilesInfo (like all)
- SQWareWeb for Oracle: enhance, add reports in unit/various ArchivelogsNb, ArchivelogsNbDetail, ArchivelogsNbHourly, ArchivelogsNbHourlyDetail (in Nb)
