My personal adventures in the quest for virtual perfectness.
The ability to schedule reports in VCOPS is quite cool. Taken from capacity IQ these reports can be run weekly or monthly on a specific time and day of week allowing you to show the report as CSV (to process inside a spreadsheet) or as a readable PDF document. Once SMTP is configured you're able to send the report to multiple users (you, your manager) using comma (,) or semi-column (;) separated e-mail addresses. Also: you can schedule reports on ANY level on ANY object (World, Folder, Datacenter, Cluster, Host, VM, Datastore), and here, the management of all schedules, can become a mess since there is no overview on where schedules are set.
Here is a little query you can run on the UI vm (this is where CapIQ is running).
FROM cmt_repsched AS R
INNER JOIN cm_objects AS O
ON R.cmt_object_id = O.object_id
INNER JOIN cmt_user AS U
ON R.cmt_user_id = U.cmt_user_id
INNER JOIN cmt_report_recurrence AS RR
ON R.cmt_user_id = RR.cmt_report_recurrence_id;
To run this query do:
- SSH to the UI vm and log in with root
- Run: su - postgres
- Run: psql cmapp
- Copy and paste the above query, this should create a view like this:
This should show all your report schedules, who and on which object it is defined.