Discovery and Inventory Group

Expand all | Collapse all

Inventory Monitoring

  • 1.  Inventory Monitoring

    Broadcom Employee
    Posted 12-09-2015 09:13 AM

    Full server inventory scan policy scheduled to run every week tuesday, In Policy its not showing the status and in report task server-->task summary by resource also not showing. 

    How to check whether inventory scan is running or not in UNIX machines.

    Also for unix machines inventory taking more than 9hours to complete, utilizing high CPU. How to check?



  • 2.  RE: Inventory Monitoring

    Broadcom Employee
    Posted 12-09-2015 11:59 AM

    Hi, there are several ways:

    1. On the Unix, Linux and Mac (ULM) clients, you can run 'aex-cta list'. Every inventory policy actually runs a task to execute the inventory process. So, they will show in the client task agent utility. 

    2. In the NS Console, browse to the policy. In the 'Applies To/Compliance' section, try changing the view to 'Computers and Users'. This should list each computer and their individual success/failure percentage. You can double-click a computer here to open Resource Manager for that computer. 

    3. In the NS Console, browse to Reports, All Reports then expand the menu tree to Discovery and Inventory, Inventory, Cross-platform, Inventory Agent and run the report "'N' Most Recent Inventory Captures". You can click column headings to sort by that column. Click again to reverse the sort order. 

    4. If you right-click the menu entry (the report name) for a report in the left pane and select 'View as xml', you can scroll down about 2/3rds in the new window and see the actual sql that we use. This shows the tables that store the data for that report. Then, you can start building your own reports, if you like. In the case of this report, we use the Inv_Inventory_results table and the vHWInventoryResults view, along with supporting tables. 

     



  • 3.  RE: Inventory Monitoring

    Broadcom Employee
    Posted 12-10-2015 07:00 AM

    Thanks for your reply and suggestion. I used below query to check the start and end time of inventory scan, But still i could not able to find why inventory scan taking more time on UNIX machines. And is it possible to check in realtime backend process going on in the machine ?

    SELECT distinct ci.Name, i.Name as 'TaskName',  ti.StartTime, ti.EndTime, ti.InstanceStatus, ti.Success
     FROM vRM_Computer_Item ci
     JOIN Evt_Task_Instances ti
        ON ti._ResourceGuid = ci.Guid
     JOIN ItemVersions iv
        ON iv.VersionGuid = ti.TaskVersionGuid
     JOIN Item i
        ON i.Guid = iv.ItemGuid
        where i.Name like '%TaskName%'
    order by ti.EndTime desc