sp_version

Syntax

sp_version [script_file, [all]]

Parameters

• script_file – is the name of the installation script (the default value is NULL).
• all – reports details about the installation scripts, such as the date it was run and the time it took to run.

Examples

• Example 1 – Returns the script name, version, and status of all installation scripts that have been run:

  sp_version

  Script          Version 
  Status
  -----------      -----------------------------------------------------------------------
  installmaster    15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu
  Sep 23 22:12:12 2004
  Complete 
  installmaster    15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu 
  Sep 23 22:12:12 2004
  Complete
  installmodel     15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-
  bit/OPT/Mon Sep 27 23:40:02 2004
  Complete

• Example 2 – Returns information about the installmaster installation script:

  sp_version        installmaster

  -----------      ---------------------------------------------------------
  installmaster    15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:12 2004
  Complete

• Example 3 – Returns script file name, date, time, version, and status for all the installation scripts run:

  sp_version  null, 'all'

  Script
  Version           Status
  Start/End Date ---------------------------------------------------------------------
  installdbccdb     15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-
  bit/OPT/Mon Sep 27 23:40:02 2004
  Complete [Started=Sep 29 2004  4:41PM]-[Completed=Sep 29 2004  4:42PM]
  installmaster
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:
  12 2004
  Complete [Started=Sep 29 2004  3:49PM]-[Completed=Sep 29 2004  3:58PM]
  installmodel
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27 23:
  40:02 2004
  Complete [Started=Sep 29 2004  4:51PM]-[Completed=Sep 29 2004  4:51PM]

• Example 4 – Returns script file name, version, and status of installation of all the install scripts having names like install%:

  sp_version 'install%'

  Script
  Version           Status
  ----------        -------------------------------------------------------
  installdbccdb
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27
  23:40:02 2004     Complete
  installmaster
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:
  12 2004           Complete
  installmodel
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1861/32-bit/OPT/Mon Sep 27 23:
  40:02 2004         Complete

• Example 5 – Returns all detailed information about installation scripts matching the wildcard “install%”:

  sp_version 'install%', 'all'

  Script
  Version           Status
  Start/End Date
  ---------------------------------------------------------------------
  installmaster
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:
  12 2004
  Complete [Started=Sep 29 2004  3:49PM]-[Completed=Sep 29 2004  3:58PM]

• Example 6 – Returns all detailed information about the installmaster installation script:

  sp_version 'installmaster', 'all'

  Script
  Version           Status
  Start/End Date
  ---------------------------------------------------------------------
  installmaster
  15.0/EBF XXXXX/B/Sun_svr4/OS 5.8/asemain/1/32-bit/OPT/Thu Sep 23 22:12:
  12 2004
  Complete [Started=Sep 29 2004  3:49PM]-[Completed=Sep 29 2004  3:58PM]

Usage

sp_version allows you to determine the current version of the scripts (installmaster, installdbccdb, and so on) installed on the SAP ASE server, and whether they ran successfully or not, and the time they took to complete

Permissions

Any user can execute sp_version. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are: