Hi Rafeeq,
Thanks for the update - I actually found the info I needed.
SELECT SEM_COMPUTER.COMPUTER_NAME, PATTERN.PATTERN_TYPE, PATTERN.PATTERNDATE, PATTERN.REVISION
FROM SEM_COMPUTER INNER JOIN
SEM_AGENT ON SEM_COMPUTER.COMPUTER_ID = SEM_AGENT.COMPUTER_ID INNER JOIN
SEM_CONTENT ON SEM_AGENT.AGENT_ID = SEM_CONTENT.AGENT_ID INNER JOIN
PATTERN ON SEM_CONTENT.PATTERN_IDX = PATTERN.PATTERN_IDX
WHERE (PATTERN.PATTERN_TYPE = 'SYKNAPPS_CAL')
@Mick 2009 - you got a thumbs up for that, but isn't it so that RU7 is the last one of the SEP11 family ?
I barely believe that there will be some further development in that direction.