ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Version of MDB

book

Article ID: 53391

calendar_today

Updated On:

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: