8 Replies Latest reply: Mar 1, 2012 4:47 PM by Anne Brock RSS

how to get currest status of an asset?

naresh NameToUpdate

I am using ITSM universe given by BMC.

In Asset management classes I am trying to build a report with all the assets with status deployed.

I observed that there are multiple records stored in database as an asset goes through various status lifecycles.

 

How can I get current status of an asset?

  • 1. Re: how to get currest status of an asset?
    Jim Wilson
    Class NameObject NameTypeDescriptionSelectWhereTable Name(s)
    BMC Analytics / Asset Management / Asset Information / AssetStatusCharacterStatus of the CIAssetLifecycleStatus.ASSETLIFECYCLESTATUSAssetLifecycleStatus

     

    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.

     

     

    HTH

    Jim

     

  • 2. how to get currest status of an asset?
    naresh NameToUpdate

    Hello Jim,

    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.

    Question is:

    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.

  • 3. how to get currest status of an asset?
    Anne Brock

    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.

     

    Anne

  • 4. how to get currest status of an asset?
    Jim Wilson

    Hi Anne,

    Anne Brock wrote:

     

    There should be one record per asset per dataset; that record will have the current status for the asset.

     


    That seems to be part of the problem.  What Analytics object would you suggest to use to pull back individual Assets?

     

    Thanks & Regards,

    Jim

  • 5. how to get currest status of an asset?
    Jim Wilson

    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.

     

    @Naresh:

     

    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,

    Jim

  • 6. how to get currest status of an asset?
    naresh NameToUpdate

    Jim,

    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?

  • 7. how to get currest status of an asset?
    naresh NameToUpdate

    Anne,

    Thanks for the tip.

    Looks like along with Data set  = BMC.Asset I added filters for class id, relation ship names that seems to be working for me so far.

  • 8. how to get currest status of an asset?
    Anne Brock

    Oh, good, Naresh, glad that worked! Happy reporting!

     

    Anne