C# prototype library for WinCC OA communication. For testing i created C# clients with gauges and a chart. Those clients are connected to WinCC OA datapoints (dpConnect, dpQueryConnect, dpGet, dpSet, …) For testing purposes i started some clients to see how it works with many clients and change rates of about 100 values/second…
An example how seamless WinCC OA is able to communicate with the Browser-Widget and JavaScript.
The sdb.ctl is a client library which can be used to access relational databases from the WinCC OA client without the need to install any database client software at the client. The connection to the relational database is handled by the WinCC OA server. The client communicates with the WinCC OA server only by data points. The SQL-Statements are transferred by data points to a WinCC OA control, this control executes the SQL-Statements and sends back the result to the client by data points.
Howto: sdb
A new HowTo and FAQ Portal for WinCC OA, Oracle and more is now online: http://www.winccoa.net/
This gallery contains 3 photos.
A very simple Windows-Phone-App to receive push notifications from WinCC OA (Alerts, Events, …) based on Windows-Azure-Mobile. Message on application tile. Messages in the notification center. Message history in the application.
Example how to query the downtime of a device which has an alert configuration on the state of the machine (state 0/1):
select element_name, sum(downtime) downtime from (
select e.element_name,
h.ts,
h.VALUE_NUMBER,
h.direction,
case
when h.DIRECTION = 0 then
CAST((h.ts + 0) - ((lag(h.ts, 1, h.ts) OVER(ORDER BY ts)) + 0) AS FLOAT)*24*60*60
else
null
end as downtime
from elements e
join alerthistory h
on e.element_id = h.ELEMENT_ID
where e.element_name like
'Device_%.Status'
and ts between to_date('01.07.2014','DD.MM.YYYY') and to_date('31.07.2014','DD.MM.YYYY')
) group by element_name
-- clean audit trail for the current container
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
USE_LAST_ARCH_TIMESTAMP => FALSE,
CONTAINER => DBMS_AUDIT_MGMT.CONTAINER_CURRENT );
END;
-- drop purge job
BEGIN
DBMS_AUDIT_MGMT.DROP_PURGE_JOB(
AUDIT_TRAIL_PURGE_NAME => 'Audit_Trail_PJ');
END;
/
-- create purge job for current container
BEGIN
DBMS_AUDIT_MGMT.CREATE_PURGE_JOB (
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
AUDIT_TRAIL_PURGE_INTERVAL => 12,
AUDIT_TRAIL_PURGE_NAME => 'Audit_Trail_PJ',
USE_LAST_ARCH_TIMESTAMP => FALSE,
CONTAINER => DBMS_AUDIT_MGMT.CONTAINER_CURRENT);
END;
/
/
Click the application in question on the task bar and press:
Windows-Key + Up ==> Maximize
Windows-Key + Left ==> place to left
Windows-Key + Right ==> place to right
Windows-Key + Down ==> Restore-Size
SELECT * FROM dba_scheduler_jobs WHERE job_name = 'J_ARCHIVEMON'
SELECT * FROM dba_scheduler_job_log WHERE job_name = 'J_SWITCHMON'
purge scheduler logs:
BEGIN
dbms_scheduler.purge_log;
END;
mac1:~ root# scutil –set HostName mac1
mac1:~ root# scutil –set ComputerName mac1
mac1:~ root# scutil –set LocalHostName mac1