DX NetOps

Expand all | Collapse all

How to delete a device from Spectrum RM (Report Manager)

Jump to Best Answer
  • 1.  How to delete a device from Spectrum RM (Report Manager)

    Posted 12-16-2015 05:54 AM

    Hi Folks,

     

    We've a report scheduled daily and when i look at the result i'm finding deleted equipment.

     

    Take a look below. When i look at report manager web page in OneClick i'm still finding the deleted device.

     

    outage editor.JPG

     

    But at oneclick i can't find it.

    oneclick.JPG

     

    How can i avoid it in the further?

     

    Cheers,

     

    Carlos



  • 2.  Re: How to delete a device from Spectrum RM (Report Manager)

    Posted 12-18-2015 07:37 PM

    Hi Carlos,

     

    In what kind of report are you getting the destroyed models? Is it a canned report? Is it an Ad Hoc report using Web Intelligence?

    What are you querying in the reporting database to get destroyed models?

     

    Thanks,

    Silvio



  • 3.  Re: How to delete a device from Spectrum RM (Report Manager)

    Posted 12-23-2015 05:36 AM

    Hi Silvio,

     

    I'm using a custom report from Spectrum AdHoc with Web Intelligence documment.

     

    We're running the report below:

     

    --> Availability / Outage

         -> Start Time;

         -> End Time;

         -> Outage Duration (HH:MM:SS);

         -> Model Name;

     

    The filters used are:

    Model Class = Workstation Server;

    Planned;

    Ongoing;

    report_query.JPG

    Regards,

     

    Carlos



  • 4.  Re: How to delete a device from Spectrum RM (Report Manager)
    Best Answer

    Posted 12-28-2015 03:45 PM

    Report Manager is a historical reporting tool by design.

    Our "current" reports will not show destroyed devices.

    When we destroy a device in Report Manager we simply update a column to have a destroyed_time.  Otherwise, its value is NULL.

     

    So you will need to add "Active Devices" filter if you are running an asset type report in WEBI.

    From the latest screenshot it appears to be availability though.

     

    So you can drag over "destroyed_time" to the filters, and change the type from "in list" to "is Null".



  • 5.  Re: How to delete a device from Spectrum RM (Report Manager)

    Posted 12-28-2015 06:12 PM

    Hi,

    like Matthew explained.

    In the database, all old devices are stored - but marked with a destroy date.

    Therefore You have to filter the devices.

     

    If You use the filters and the device is still reported, then check the amount of bucketfiles?  Probably the database is not up to date.

    The update of the inventory in the SRM-DB runs only once daily. ... if You delete a device, you could run reports for it at the same date.

     

    If You are able to check the datasource via mySQL you will find the table for devicemodels.

    .. show tables like '%device%'; ..

    then use desc "tablename" ..

    then You should be able to build a query to fetch exactly this record.... and You will (hopefully) find a column with the destroy - date or destroy-flag.

     

    Best Regards

    Erich