4 Replies Latest reply: May 15, 2012 4:13 AM by Gerardo Bartoccini RSS

Reporting on RSCD Agent Status

Gerardo Bartoccini

Hi,

I need help on creating a report which I thought it would be trivial, but apparently it's not.

 

IHAC which asked me something obvious:

"Can we create a report with day by day agents status?"

It doesn't have to be per server, but global. How many not licensed, how many unavailable, and so on.

Their managers want to see the trend and understand how the number of unreachable or not licensed servers is decreasing day by day.

It should contain Agent State and Job Start Run Time (USP job, I mean).

 

I spent some time attempting to create such a report but with no success.

The Agent State field is in the Server namespace, which doesn't contain date information, apart from Date Modified.

Unfortunately Date Modified is different for each server, which doesn't allow to group per day.

I attempted investigating on functions which could allow me to extract something like year/month/day from the Date Modified field but no luck.

 

Can anybody help on this?

I can't believe we can't create such a simple report.

 

Thanks

  • 1. Reporting on RSCD Agent Status
    Bill Robinson

    i think you would need to include a job run date and group by that date.

  • 2. Reporting on RSCD Agent Status
    Chetan Dixit

    which version of BDSSA ?

  • 3. Reporting on RSCD Agent Status
    Chetan Dixit

    you can try following steps to see if this the report are trying to achieve, basically there are 3 items used in the report server name, server modified date and agent status

     

    1. Go to Query Studio.
    2. Drag Server Modified Date.
    3. Right Click on the Server modified Date, then choose option Calculate.
    4. In Operation drop down select Year.
    5. In New Item Name Type Year.
    6. Click Insert.
    7. Delete Server Modified Date from report
    8. Drag Server Modified Date again.
    9. Right Click on the Server modified Date, then choose option Calculate.
    10. In Operation drop down select Month.
    11. In New Item Name Type Month.
    12. Click Insert.
    13. Delete Server Modified Date from report
    14. Drag Server Modified Date again.
    15. Right Click on the Server modified Date, then choose option Calculate.
    16. In Operation drop down select Day.
    17. In New Item Name Type Day.
    18. Click Insert.
    19. Delete Server Modified Date from report.
    20. Drag Server Name in report.
    21. Right Click on Server Name.
    22. Click on Summarize.
    23. Click on Advanced (Right bottom of screen).
    24. In the drop down Summary for Cells, choose Count
    25. Click Ok
    26. Drag Agent State in report
    27. Left Click on the Agent State
    28. Then in the top Query Studio menu choose Pivot ( 6th item from top right).

     

  • 4. Reporting on RSCD Agent Status
    Gerardo Bartoccini

    Thanks, will try this.