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.