Use BMC Discovery queries to extract migration data for migration planning

Identify ITSM owners.

Identify the IT Service Management (ITSM) owners (usually by reaching out to the operational support teams).

Check CMDB.

Identify the number of configuration management databases (CMDBs) that contain asset information, and then identify the sources of that information.

Identify discovery tools and check for use of BMC Discovery.

If your organization is using BMC Discovery to send data about your environment to the CMDB tool, check the scope and coverage of its scans. For example, check if BMC Discovery is scanning all data centers and if the access servers are located in perimeter zones.

Check the level of application modelling.

Check if applications are modelled in BMC Discovery. If not, recommend the use of the BMC Discovery tool to model which running software instances provide an application and business service.

Extract data on physical and virtual servers.

To extract data on the physical and virtual servers scanned by BMC Discovery, use Query Builder to run the following query:

search Host show key as 'Serverid', virtual, name as 'HOSTNAME', os_type as 'osName', os_version as 'OS Version', num_logical_processors as 'Logical Processor Counts', cores_per_processor as 'Cores per Processor', logical_ram as 'Logical RAM', #Consumer:StorageUse:Provider:DiskDrive.size as 'Size'

Note: You can use extracted data to determine the appropriate instance sizes for migration.

Extract data on modeled applications.

If your applications are modeled in BMC Discovery, you can extract data about the servers that run the application software. To get the server names, use Query Builder to run the following query:

search SoftwareInstance show key as 'ApplicationID', #RunningSoftware:HostedSoftware:Host:Host.key as 'ReferenceID', type, name

Note: Applications are modeled in BMC Discovery by a collection of running software instances. The application is dependent on all the servers that run the application software.

Extract data on databases.

To get a list of all scanned databases and the servers these databases are running on, use Query Builder to run the following query:

search Database show key as 'Key', name, type as 'Source Engine Type', #Detail:Detail:ElementWithDetail:SoftwareInstance.name as 'Software Instance', #Detail:Detail:ElementWithDetail:SoftwareInstance.product_version as 'Product Version', #Detail:Detail:ElementWithDetail:SoftwareInstance.edition as 'Edition', #Detail:Detail:ElementWithDetail:SoftwareInstance.#RunningSoftware:HostedSoftware:Host:Host.key as 'ServerID'

Extract data on server communication.

To get information on all the network communications between servers that’s collected by BMC Discovery from historic network communications logs, use Query Builder to run the following query:

search Host
 TRAVERSE InferredElement:Inference:Associate:DiscoveryAccess
 TRAVERSE DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:NetworkConnectionList
 TRAVERSE List:List:Member:DiscoveredNetworkConnection
 PROCESS WITH networkConnectionInfo

Extract data on application discovery.

To get information on application dependencies, use Query Builder to run the following query:

search SoftwareInstance show key as 'SRC App ID', #Dependant:Dependency:DependedUpon:SoftwareInstance.key as 'DEST App ID'

Extract data on business services.

To extract data on business services provided by hosts, use Query Builder to run the following query:

search Host show name, #Host:HostedSoftware:AggregateSoftware:BusinessService.name as 'Name'