We intend to use it but I've not had much luck with getting it to connect to Cisco's backend database just yet. In all fairness, I've not had a ton of time to spend working on it.
There is similar functionality (from a reporting standpoint) available via the Cisco SmartNet Total Care portal which is bundled with SmartNet contracts now (you must be running a collector within your network) but it would be nice to have everything wrapped up (and actionable from a configuration change/upgrade standpoint) within the Orion ecosystem.
I'm pretty bad at keeping track of the forums but if you ping me in a month or so I'll likely have more to report on the Smart Connector front.
I have tried but could not get it to work properly, i even had it run for a couple of days once but it never finished.