Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal CMDB

Integrations > Third Party Integrations > Aperture VISTA > How to Use the Aperture VISTA Integration Adapter

How to Use the Aperture VISTA Integration Adapter

Prerequisite - Scripts
The following scripts should be run on the VISTA database:
- v600_VIP_DAL_DV_Devices.sql
- v600_Device_to_PDU.sql
The scripts are located in the discovery probe at <hp>\UCMDB\DataFlowProbe\runtime\probeManager\discoveryResources\VistaScripts
Prerequisite - Credentials
Population is accomplished using SQL queries over JDBC. The following credentials should be defined:
- Generic DB Protocol (SQL)
For credential information, see Supported Protocols.
Run the job
1. Run Range IPs by ICMP to discover the IP address of the SQL Server used by Aperture VISTA.
2. Run Database TCP Ports to discover SQL Server ports on the IP addresses discovered above.
3. Run MSSQL Connection by SQL to discover the SQL Server instance used by Aperture VISTA.
4. Run MSSQL Topology by SQL to discover database instances in the SQL Server instance discovered above.
5. Create a new integration point, and use the Aperture VISTA by SQL adapter to discover datacenter and power infrastructure from VISTA.