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
Article ID: 53391
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:
Component:
Feedback
Yes
No
Powered by
