How to export the report from Custom UI?

[Venkat_A]

I want to know How to export the report from Custom UI?

Can i customize the report?

[abhilashhb]

Right now there is no reporting in vCOPS Custom UI. There are just capacity and optimization reports that you get on the UI portal.

There's an option of generating reports using xml.

[Venkat_A]

how to get that Capacity and optimization reports ? how to export that?

[abhilashhb]

Go to https://<vcops-ip>/vsphere-ui and go to reports tab. you will see a lot of reports. Once you run them you can download them as PDF or CSV. You could also schedule them and get them delivered to your mail address by configuring SMTP.

[Venkat_A]

I want to know, how to create a custom report in Vsphere UI.

For ex: i want to pull for entire period of time the CPU utilization of that entire datacenter machines?

[mark_j]

Try these:

http://communities.vmware.com/thread/429057?tstart=90

then

http://communities.vmware.com/thread/435402?tstart=0

[Venkat_A]

It is still some what confusing. I am pretty new to VCOPS, so can someone guide me with step by step procedure?

i am not able to find  user_ciq_metrics_collected.xml in both Analytics and UI VM. Can someone guide me with the location?

[dhanarajramesh]

Dear Venkat, as you new for VCOPs  you can use RVtool which is free. you can use this tool to connect your vcenter and you can get all of your reports. mostly all of the users usings this.

[Venkat_A]

Dhanraj,

Rvtools cannot give the old history. I need for the complete one yr history data.

[abhilashhb]

These are the sample files you will find in xmlviews

AbnormalVMListSample.xml

BadgeSummaryTableSample.xml

CustomViewsAndReports.xml

CustomViewsAndReports.xsd

manager-bean-createView.xml

PerfomanceTrendSample.xml

You can find it under /usr/lib/vmware-vcops/user/conf/xmlviews in the UI VM.

[Ramraj_4k]

  Browse the Analytics VM  --->   /usr/lib/vmware-vcops/tools/RepositoryAdapter/Conf/Conf.properties file

If your vcops is installed on the Virtual appliance mode then , Mention only the FSDB details...rest of the SQL & Oracle DB is applicable for the Vcops - exe based installation either in Windows /Linux based OS.

Updat the follwoing value only ..

#source FSDB

sourcefsdbDriver=com.integrien.fsdbjdbcdriver.FSDBJDBCDriver

sourcefsdbUrl=rmi\://<IP address>\:1199/DBMS

Mention the output path :

#incremental = false means full for maxDays days

incremental = false

maxDays = 365

retryConnectCount = 5

#milliseconds

delayBetweenRetries = 10000

exportToCsv = true

csvFilePath = C:/csv.csv

csvDelimiter = ,

[Venkat_A]

Hi Ramraj,

Thanks for the resposne, but the above steps is used for what? i need to export the report of my dashboard in the Custom UI for 1 year duration.

Now after the above steps performed, then how to pull the report?

[Venkat_A]

Hi Abhilash,

I want to know the location of this file "user_ciq_metrics_collected.xml"

[Ramraj_4k]

As per the settings, FSDB is integrated DB in VCops Applicance...so just need to mention the IP address for the Analytics VM...inoder to collect the Data from the source..

#source FSDB

sourcefsdbDriver=com.integrien.fsdbjdbcdriver.FSDBJDBCDriver

sourcefsdbUrl=rmi\://<IP address>\:1199/DBMS

Mention the output path to define the destination location for the report has to be stored...by default upto six months able to get the data from the vCops DB...

#incremental = false means full for maxDays days

incremental = false

maxDays = 365

retryConnectCount = 5

#milliseconds

delayBetweenRetries = 10000

exportToCsv = true

csvFilePath = C:/csv.csv

csvDelimiter = ,

[Venkat_A]

Thanks Ramraj,

But my question is different. From Custom UI there is no OOB report you can pull, you need to do some experimental things. I want the details of those.

[abhilashhb]

Try here /usr/lib/vmware-vcops/user/conf/analytics/

There is a file called sys_ciq_metrics_collected.xml

[Ramraj_4k]

There is no default settings in Custom UI for to export the report ... it's requires some experimental steps as this mentioned previous comments..

[Venkat_A]

Yes Ramraj,

I am asking about that steps. seems like so many people tried using that. So need a step by step info on that.

[Ramraj_4k]

Try that settings as mentioned on the previous comments...

For Step by Step execution details ... Refer -->vcops-enterprise5-admin-guide

[gradinka]

Venkat_A

The custom-reports are available only in vSphere UI. They will not show up in the Custom UI.
You can contact vmware support and ask for the instructions, they can provide the necessary steps upon request.

The procedure is a bit tricky and error prone, hence not publicly available.