vCenter Credstore Pull Exec Time VI Offline Inventory  Package Updater  House Cleaner  Refresh Inventory Log Viewer

What we wanted to achieve was to make an appliance as easy to use as possible. Therefore we developed some tools to make your life easier using SexiGraf. First, the Home page let you monitor the health of your appliance thanks to collectd:

(click for live action)

Every tools are available through the web interface thanks to predefined dashboards like SexiGraf Web Admin or SexiGraf VI Offline Inventory. Just navigate to your sexigraf web-ui with your favorite browser and select one of these dashboards as seen below:


You will have access then to the tool grid which let you select what you want to access to. As we will add more features to SexiGraf, we may also add other web tools in this section, so it may evolve in the future:

vSphere Credential Store

Out of the box, SexiGraf will not pull any data as it don’t know where your vCenter servers are. First of all, after you’ve deployed it on your platform, you will have to add vCenter information to let the appliance start fetching data. This operation can be achieve from the Credential Store tool. Just go on the SexiGraf Web Admin dashboard and select Credential Store. You will then see the list of all vCenter you already have set up. If you want to add another entry, you just have to type the 3 mandatory parameters and press Add and set it up:

  • vCenter IP or FQDN. In case of FQDN, the appliance must be able to resolve it!
  • Username that SexiGraf will use to query the vCenter (any read-only account is enough, you can use SAM, UPN or single user format)
  • Password that comes with this username

As we distinguish VI stats from VSAN ones (because VI stats are pulled every 5min and VSAN stats every minute), you can choose if you want to query VI, or VSAN, or both by enable/disable it thanks to the Action menu on the right of the vCenter.

Note: The credentials are used to create a session that will last as long as possible using a session file to avoid login/logoff events.

 As soon as you added vCenter information, offline inventory will be generated. Just grab a coffee and wait a few minutes for SexiGraf to retrieve stats, and start Monitoring, like a boss!


Pull Exec Time

As SexiGraf will retrieve information on vCenter servers, it’s important to keep track of the time it takes to query API. So we added a Pull Exec Time dashboard that will keep track of these query durations for all calls that are made by the appliance (VI, VSAN and inventory). Usually, scripts run in a few seconds, so if queries took too long, you’ll be able to see it right away:


VI Offline Inventory

When you work with several vCenter on your platform, it could be a pain in the … tricky to find virtual machine for daily-basis administration tasks. What we used to do during our past job experience is to build some static inventory, to be able to search quickly cross-vCenter some virtual machine information. It can be really useful, specially if you have an outage and you want to see on which ESX was your vCenter VM.

So we thought about adding this ‘feature’ to SexiGraf as it could be useful to another admin. You could find this offline inventory available on the SexiGraf VI Offline Inventory dashboard.  It’s generated every 6 hours and let you search in any column listed. As we added a lot of info, we wanted to not make too messy, so we hid by default some columns. On the top of the page, you will be able to click on each button that represent a column to dynamically show/hide it.


Starting from SexiGraf 0.99d, you can click on any VM or Cluster to be redirected on a the corresponding VM Stats or Cluster FullStats dashboard. We’ve also added blue folder” path property:

Package Updater

As we plan to add lot of features and content to the SexiGraf appliance, we wanted to make update flawless for you. We didn’t want to say to you “Please update by redeploying a new appliance”. So we built a native updater that’s available in this section. When we will be releasing a new version of SexiGraf, we will provide you a *.sup package (for SexiGraf Update Package) that you will upload to your appliance thanks to this page. After the upload is successfull (it shouldn’t be long as the package will be usually just a few hundred Kb), you will be able to start the upgrade process. After a few confirmation (we’re never too safe), the upgrade process will start, letting you enjoy the up-to-date version of SexiGraf. Without any dataloss obviously.


House Cleaner (formerly Stats Remover)

The House Cleaner will let you manage Graphite data (Whisper files) and vCenter session data (Token files). Through this web-ui, you will be able to remove legacy or orphaned stats (i.e. after datastore removal), vCenter session files (for authentication troubleshooting) and oldest Whisper files that may no longer be used. They will be displayed in a nice data tree and will let you select any (one or more) files in order to remove them (don’t be afraid, it will ask you some noisy confirmation before hurting your SexiGraf). As Grafana is based on dynamic query on whisper files, the effect will be immediate, you will not need to restart anything, what you wanted gone is gone for sure!

In SexiGraf 0.99d we limit the scope to folders to avoid timeouts in big environments. We also added the “Auto Purge” feature (disabled by default) so you don’t have to worry about removed objects anymore like deleted items, temporary datastores, VM migrated from a cluster to another one, etc… We hard coded this feature to 120 days but we plan to make this setting tunable:

Refresh Inventory

The VI Offline Inventory is automatically updated every 6 hours. If you want to force a refresh, you can use this section to perform a manual update. Just navigate from the SexiGraf Web Admin dashboard to this section and follow the walk-through explanation (basically, you just have to press a one or two buttons, we told you we wanted to make it easy-as-pie!).


Log Viewer

This section have been added to make debugging easier for everyone. It will provides log detail for several components of SexiGraf (such as VI Offline inventory, or statistics runner, …). You will be able to display on your browser the content of these logs for troubleshooting purpose. It can guide you to identify the source of the issue (bad username/password combination, runtime error, …) and can be useful for us to give you a hand if you need.