DX Unified Infrastructure Management

  • Private Community

  • 1.  Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 14, 2017 07:28 AM

    can anyone help us by providing one sample report on the same



  • 2.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 14, 2017 08:03 AM

    What type of report are you looking for?



  • 3.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 14, 2017 08:42 AM

    Such as :

    1. Bandwidth utilization report (Daily, Weekly, Monthly)
    2. Disk Space Utilization Report (Daily, weekly monthly)
    3. Memory & CPU Utilization report (Daily, Weekly , monthly)
    4. Availability Report (Daily, weekly, monthly)
    5. Interface availability (Daily, weekly and monthly) with no of occurrences.

     

    NOTE: Report should be for all servers.(How to create these many reports by using MSSQL queries.)



  • 4.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 14, 2017 08:50 AM
      |   view attached

    Is it the SQL query or the report creation in iReport (or Jasperstudio) that is a problem?

    In attachment a iReport example to produce a availability report for previous month.  This is based on the qos view: V_QOS_NET_CONNECT.

    Attachment(s)

    zip
    System Availability - Last Month.jrxml.zip   3 KB 1 version


  • 5.  Re: Need to build the repot in iReport using MSSQL queries in CA
    Best Answer

    Posted Mar 15, 2017 12:47 AM

    Hi good morning,

     

    Thanks for your reply, but the problem is still there am not able to open this report its giving error.

    Can you send a another sample report. And explain the steps, how you create that report, what are all the SQL queries needs to create that report. Will wait for your positive response.

     

    Error snapshot that am getting while opening system availability report. :

     



  • 6.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 15, 2017 04:29 AM
      |   view attached

    Sorry, I posted a jrxml file compiled with Jasperstudio.

    Here is the original .jasper file that you can use in both iReport and Jasperstudio.

    Attachment(s)

    zip
    System Availability - Last Month.jasper.zip   17 KB 1 version


  • 7.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 16, 2017 12:21 AM

    Sorry again same problem not able to open or run the report.

     

    error msg while running the report. :

     

    Is there anyone that can help me to sort this issue.

     

    just help me with suitable guideline , i want to create a disk utilization report of 5 server in iReport, an using MSSQL database, just suggest how can i create and what are all the SQL queries that are required to create  this report.

     

    And can anyone share a sample report on the same.



  • 8.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 16, 2017 02:44 AM

    In the error screen that you included you also have:

    If you use here the icon: you will receive:

    From there you can copy the sql statements and use them in SQL Enterprise, and copy a modified version back if needed.



  • 9.  Re: Need to build the repot in iReport using MSSQL queries in CA

    Posted Mar 16, 2017 02:39 AM

    Did you use the sql procedure to create qos views? (see: QOS_Views MS SQL script (Feb 2016) )

    Because the sql in this report uses V_QOS_NET_CONNECT.