Datech Management Solutions Ltd. Asset Management Consultants Main Menu Home Maintenance Strategy EAM/CMMS RCM Clients Contact Us Search   Home Welcome to Datech Management Solutions Ltd. The field of asset management has come to the fore in recent years as a key strategic focus area of any asset intensive business which has dual objectives of regulatory compliance and maximum return on capital employed. DMS has the capability to provide complete management solutions to enable these objectives to be met. Datech Management Solutions Ltd. was formed in 2001 by professionals in the field of industrial maintenance management, to provide consultancy & implementation support for businesses requiring development & implementation of maintenance strategies. Our clients include blue chip companies in the defence, nuclear, automotive & chemical industries presenting unique challenges in highly regulated and productivity focused environments. DMS capabilities: Maintenance strategy definition & documentation  Reliability Centred Maintenance (RCM) training & facilitation Enterprise Asset Management / Computerised Maintenance Management System (EAM/CMMS) selection & implementation/optimisation support Technical documentation compilation & proof reading services In addition to our in-house consultancy resources, we have the ability to engage partners & associates if necessary. Whatever your asset management requirements, talk to us and we will be able to provide cost effective solutions. [ Back ] Who's Online We have 1 guest online   Copyright 2001 - 2011 Datech Management Solutions Ltd.

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1327753047)
5
SELECT * FROM mos_session WHERE session_id='058d910690591b13c73a28b7fba88411'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('c4ef237ae5a802385403006351b74e0c')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd2ac926a49aa4fdc744d52cff6ff3b06','1327753947','','0','1' )
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
9
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
10
SELECT access FROM mos_menu WHERE id='1'
11
SELECT * FROM mos_menu WHERE id='1'
12
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-01-28 07:32:27'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-01-28 07:32:27' )
 ORDER BY f.ordering
13
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
14
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
15
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
16
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
17
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=1
18
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
19
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenumenu_style' AND published='1' AND access <= '0'
ORDER BY parent,ordering
20
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
21
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenumenu_style' AND published='1' AND access <= '0'
ORDER BY parent,ordering
22
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
23
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
24
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
25
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
26
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)