Client Automation - Boot Server information on the MDB

Products

• CA Client Automation - IT Client Manager
• CA Client Automation

Issue/Introduction

How to verify Boot Server information directly on the MDB?

Environment

Client Automation - All Supported versions

Resolution

First thing to do is obtain Boot Server ID, which can be done running the following query:

SELECT * FROM csm_object WHERE class=1000

Once the desired Boot Server is identified, the following query can be executed to retrieve its information using the ID obtained from previous query:

SELECT * FROM csm_property WHERE object=xxx

This is the same information seen on DSM Explorer.

NOTE: Keep in mind that there may be a time difference in the dates from GUI and MDB caused by regional configuration on SQL and the DM server.