Template:SQWareWebPres

Presentation

Usage

It is the specific part of 'graphic' restitution of dbSQWare™ for {{{1}}}.
SQWareWeb {{{1}}} formats (graphs or tables) datas uploaded in [[SQWareRepository:{{{2}}}|SQWareRepository {{{1}}}]] by many scripts of [[SQWareProduction:{{{2}}}|SQWareProduction module for {{{1}}}]]. Almost all of the data presented are dynamically generated (volumes, versions, ...), only the data type repository or settings are stored manually in the relevant tables.
Example of static table : [[SQWareRepository:{{{2}}}#tsqw_Repository|tsqw_Repository]]

Examples of pages presented for {{{1}}}:

• Inventory of {{{3}}}s {{{1}}} with volumetry, version, environnement, ...
• Distribution of {{{3}}} in number/volumetry per environnement/client/version
• Detail of volumetry ({{{4}}})
• Trace of scripts executions of [[SQWareProduction:{{{2}}}|SQWareProduction {{{1}}}]] (beginning, end, options, duration, return code, ...)
• Performances datas
• Capacity planning
• ...

Presentation model of SQWareWeb™ for {{{1}}}.

Explanation of directories

Directories located in $gvsqw_RootexpdbWebdba/htdocs/{{{2}}} :

• bin : Directory containing standard scripts

• general : Directory containing general reports for all managed {{{3}}}s
• detail : Directory containing contient specific report for one selected {{{3}}} {{{1}}}
• tech : Directory containing contient "technical" reports, some general and others specific per {{{3}}} {{{1}}}
• dashboard : Directory containing contient changes on {{{3}}}s (removed/created, patched/upgraded), and distributions

{{{5}}}