DX Infrastructure Manager

Expand all | Collapse all

Remove niscache entries in bulk

Jump to Best Answer
  • 1.  Remove niscache entries in bulk

    Posted 09-05-2017 11:28 AM

    Is there anyway to force remove all the niscache entries from UIM database ? 



  • 2.  Re: Remove niscache entries in bulk

    Posted 09-05-2017 03:57 PM

    I know this step that can help you:

     

    How to Clean Niscache Folder on All Active Robots 



  • 3.  Re: Remove niscache entries in bulk

    Posted 09-05-2017 11:04 PM

    The above KB will not help to remove the entry from database. Need to remove the entry from DB.



  • 4.  Re: Remove niscache entries in bulk

    Broadcom Employee
    Posted 09-07-2017 06:01 AM

    We need to remove device entries in order to remove CI (Configuration Items) and MET (Metrics) entries existing in UIM database, because device entry is owner of these assets.

    If device is removed from UIM database, its assets also removed.

     

    Regards,

    Yu Ishitani



  • 5.  Re: Remove niscache entries in bulk

    Posted 09-18-2017 11:44 AM

    Can u please share some sample query to do the whole deletion ,niscache,CI and metrics. And there is any plans to flush the niscache by robot itself?



  • 6.  Re: Remove niscache entries in bulk

    Posted 09-27-2017 03:13 PM

    I would do this in 2 parts. I would also like to add only do this if you are very familiar with the UIM DB. If you delete something from S_QOS_DATA it will cascade and remove all RN/HN/DN data. Use at your own risk. 

     

    Part 1 - Set ci_metric_ids to null for a specific robot:

    This is assuming that you already know how to clear nis cache folder of the robot in question. After running the query below, bounce discovery_server and data_engine. Depending how many devices you have in your environment, you might have to wait 5 minutes or 30+ minutes before the ci_metric_id column is populated. Run query below:

     

    Update s_qos_data set ci_metric_id = NULL

    Where robot = '<robotname>'

     

     

     

    Part 2 - Delete NULL entries:

    After sufficient time has passed you can probably assume that any existing NULL entry probably does not exist anymore. It could also mean that a device is down and since it can not be polled it can not create a new ci_metric_id. So use your best judgement. Run the following query to delete NULL rows:

     

    delete from S_QOS_DATA

    where robot = '<robotname>'

    and ci_metric_id is NULL



  • 7.  RE: Re: Remove niscache entries in bulk

    Posted 01-08-2020 10:40 AM
    Is there an updated link for the "How to Clean Niscache Folder on All Active Robots " with the new site now? This one above doesn't work.

    Also can someone from Broadcom please fix this article:
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=131455

    They didn't even read the title of the article. "shoing"  >> "showing"

    ------------------------------
    Daniel Blanco
    Enterprise Tools Team Architect
    DBlanco@alphaserveit.com
    ------------------------------



  • 8.  RE: Re: Remove niscache entries in bulk
    Best Answer

    Broadcom Employee
    Posted 01-08-2020 10:56 AM
    Hi Daniel,

    Hope all is well.
    the new link to the clear niscache is below:
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=9570

    and I corrected the spelling mistake as requested in the other one :)

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------