Creating a custom real time database dashboard (89395)

Is it possible to create a custom database (Oracle/SQLServer) dashboard?

Will the forceRefresh() function provided? If so where is this function documented?

The forceRefresh() is not supported hence that is why it is not documented. This function is likely to be removed in a future release of the database cartridges.

The information given below may provide some assistance but the requirement for a real time dashboard should be directed to Quest Professional Services who can be contacted via a Quest Sales representative. of the Foglight Communities - http://communities.quest.com/

The forceRefresh() function only seems to return an anonymous data object. There does not appear to be any logic executed with the function that would trigger real time data collection.

This is what the function does:

ts = server.get("TopologyService");
return ts.createAnonymousDataObject(ts.getType("DBWC_ForceRefresh")

Real time data in a dashboard apparently basically means that while a dashboard is accessed a callback to an agent is created and data is pulled on the fly and immediately sent back to the server so that it can be displayed in the dashboard. There is a service called AgentCallbackService that allows you to invoke agent callbacks.

An example is given below:

server.get("AgentCallbackService").invokeCallback(args['agent_id'],"generat
eDatafileFragmentation", [uuid, args['tablespace_name'], args['datafile_name']] as Object[]) time = System.currentTimeMillis();^M while (System.currentTimeMillis() - time < 20000) {
for (val in
(server.get("TopologyService").getObject(theData.getUniqueId()).get("callba
cks")))
{
if (val.request_id == uuid) {
if(DBWC_LogFactory.getCurrentLogLevelByModule
(DBWC_Module.DBWC_ORACLE) == DBWCLog_Level.DBWC_DEBUG){ DBWC_LogFactory.getLog(DBWC_Module.DBWC_ORACLE).writeMessage(DBWCLog_Level.
DBWC_DEBUG, "uuid found" + uuid) };
return val.datafiles_frag;
}
}

So this suggests the following: when calling that callback function it does an asynchronous call. When calling an agent specific callback (generateDatafileFragmentation in this example) provide the ID of the agent that you are going to ask. Possibly some further parameters that the agent may need to formulate the response. When submitted a unique ID after a few minutes the Topology Service can be to iterate through objects that came in via callback. If any of those share the unique ID,it can be processed.