search cancel

Username in Login objects cannot be used in Advanced Search

book

Article ID: 227962

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

We would like to find in which Login object a particular Username is being used.

When using the Advanced search, with Filter criteria is Object content and the filters are set to search in all Object Types, including Login objects, I introduce the username (in this case univa) but no results are displayed.

But you can see that I have a Login object (LOGIN.UNIVA) with univa as Username/ID

Is this normal or is there a way to accomplish this using a query?

Cause

This is normal behavior, see documentation here

Full text search for content available on the following pages of the object definition:

  • Process pages and sub pages (Pre ProcessPost ProcessChild Process)
  • Documentation pages and sub pages (both for structured and unstructured documentation)
  • Title of objects
  • Archive keys of objects
  • Keys and values in STATIC VARA objects

The field Username inside a Login object or a CONN object for example for the RA Agents, is not stored in the Lucene index, so it's normal that the advanced research won't find it.

Environment

Release : 12.x and superior

Component : Automic Web Interface

Resolution

This can be achieved by a SQL query to the database:

For example, for Oracle, this would be a query that you could use to find the username called "univa" in all the Login objects not deleted that are defined in the client 22:

select OH.OH_name,OLC.OLC_Login 
from OH,OLC
where OH_IDNR=OLC_OH_IDNR and 
OLC_Login like '%univa%' and
OH_CLIENT=22 and 
oh.oh_deleteflag=0



Example of the result:

Attachments