[Sotiris Zdagkas]

Using the metrics view I can see the current usage but I cant see the location.
Is there a way to see in which machines are the active installations ?

Thank you.

[sdc-support]

Hello.

Unfortunately right now we don’t have a way to show the “active” machines in the Admin Console, but the raw information for it is stored in the Database, so you could get it doing a direct query on the Database. We are planing to add a feature to export this kind of information in a future relase.

Best regards.
Héctor – Pulse Support

[Sotiris Zdagkas]

Is there any way to do that when SDC is running with its embedded database?

Thanx

[sdc-support]

zdragkas,

The problem is not where the database is located but how you uniquely identify systems. We do a best effort mechanism that will give us a close approximation of how many systems are actively using the package. More may be done in a future release but right now we only support giving the total number of active systems.

Cheers
–Ray
SDC Support

[Sotiris Zdagkas]

Hello Ray,

According to the post reply by Héctor, I understand that I can execute a query and get the raw information (whatever raw means). So, the question was, can I execute this query somehow against the embedded database, or do I have to setup SDC with an external database?

As you can understand, it is very critical for managing your installations to know where these installations are, especially when the volume of licenses increases… (or at least to know approximately where they are).

In any case, is there a timeline for the next release which will include this feature ?

Thank you.

[sdc-support]

zdragkas, To connect to the embedded DB you need to go to http://db.apache.org/derby/ and get the Derby jdbc drivers, the one you need to use once you have the bin files is derby.jar.

To connect to the embedded DB you nee the following:

– DB credentials, sdc/sdc
– SDC Server should not be running
– derby.jar from the http://db.apache.org/derby/
– use the following jdbc url: jdbc:derby:${your_sdc_install_location}/database;create=false

On the database you could find the machine information under the SDC DB and on the table INST_MACHINE

We are planning to release a new version of SDC on July 13, but release could be no later than a week after this date, it will contain some enhancements about the ability to see this information.

Best Regards
Ignacio

[Author]

Posts