Version of MDB

Products

• Advantage Data Transport
• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Server Automation
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

How to find the version of MDB in ITCM?

Solution:

Open SQL Management Studio and run the following query against the MDB:

select * from mdb

(OR)

Open command prompt and type the following commands:

osql -S localhost -d mdb -E -e -b -Q "exit(select mdbmajorversion, mdbminorversion, buildnumber from mdb)"

If 'osql' is unavailable you can use 'isql' with the same syntax.

isql -S localhost -d mdb -E -e -b -Q "exit(select mdbmajorversion, mdbminorversion, buildnumber from mdb)"

Environment

Release: UASIT.99000-11.2-Asset Intelligence
Component: