Class Name Object Name Type Description Select Where Table Name(s) BMC Analytics / Asset Management / Asset Information / Asset Status Character Status of the CI AssetLifecycleStatus.ASSETLIFECYCLESTATUS AssetLifecycleStatus
See the Self Help Document ID KA361833 in the BMC Knowledge Base for more information on the hierarchies, conditions, universe objects, and other characteristics of the universe.
Thanks for the reply.
I used the status objects and ci name object from the same class. As I mentioned earlier it returns multiple records each having different statuses.
How to determine current status of the asset?
Regarding: Self Help Document ID KA361833
I couldn't find this document in Knowledge base. I did a search in search box in knowledge base page.
It retunrs numerious results none related to this document.
i appreciate your help.
There should be one record per asset per dataset; that record will have the current status for the asset.
If you are bringing back multiple records per asset, my guess is they are either in different datasets (i.e. bmc.asset and bmc.addm) or your reconciliation process is creating duplicate records instead of updating the existing record.
I think I found the correct one
BMC Analytics\Asset Management\Asset Information\Asset System Fields\Instance ID
Using this along with BMC Analytics\Asset Management\Asset Information\Asset\Status appears to produce the correct results.
When searching for the Knowledge Article, just use the KA id: KA361833
I've checked this and had it independently verified and its working fine.
Thanks & Regards,
Article look up worked for me. Thanks for the tip.
Are you using max(instance Id) to get the correct result?
In that case, I can not filter out rest of the records as I can not get max(instance id) in query.
I can do this in a SQL by using subqueries and max of instance id.
What trick in Business Objecgs can get me just one record per asset using instance id?