Home
About

Items +
Software +
Invoices +
Agents +
Files +
Contracts +
Locations +
Racks +

Item Types
Contr. Types
Status Types
Tags
Users

Print Labels
Reports
Browse Data

Settings
Translations
DB Log
Item:4
Rack:1
Item:5
Rack:1
Rack:1
Item:5
Rack:1
Item:5
Item:4
Rack:1
Item:4
Item:5
Item:new
Item:4
Item:new
Item:1
Invoice:1
Invoice:new
Item:new
File:new
Item:3
Contract:new
Item:new
About:
Rack:1
Item:new
Rack:1
Item:new
Item:new
About:
Item:new
Item:new
Rack:1
Item:3
Rack:1
Item:3
Rack:1
Item:3
Rack:1
Item:new
Item:3

Demo mode, no save possible
DB (SQLite)
Full Backup

Version 1.6
sivann

History of Changes

ID Date SQL IP User
156 22/01/2012  DELETE from itemtypes where id=25 94.68.244.159 admin 
155 22/01/2012  DELETE from labelpapers where id=18 94.68.244.159 admin 
154 22/01/2012  DELETE from labelpapers where id=15 94.68.244.159 admin 
153 22/01/2012  DELETE from labelpapers where id=19 94.68.244.159 admin 
152 22/01/2012  DELETE from labelpapers where id=17 94.68.244.159 admin 
151 22/01/2012  delete from contract2item where itemid=5 94.68.244.159 admin 
150 22/01/2012  delete from item2soft where itemid=5 94.68.244.159 admin 
149 22/01/2012  delete from item2inv where itemid=5 94.68.244.159 admin 
148 22/01/2012  delete from itemlink where itemid1=5 94.68.244.159 admin 
147 22/01/2012  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='27', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0' WHERE id=5 94.68.244.159 admin 
146 22/01/2012  delete from contract2item where itemid=5 94.68.244.159 admin 
145 22/01/2012  delete from item2soft where itemid=5 94.68.244.159 admin 
144 22/01/2012  delete from item2inv where itemid=5 94.68.244.159 admin 
143 22/01/2012  delete from itemlink where itemid1=5 94.68.244.159 admin 
142 22/01/2012  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='28', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0' WHERE id=5 94.68.244.159 admin 
141 22/01/2012  delete from contract2item where itemid=5 94.68.244.159 admin 
140 22/01/2012  delete from item2soft where itemid=5 94.68.244.159 admin 
139 22/01/2012  delete from item2inv where itemid=5 94.68.244.159 admin 
138 22/01/2012  delete from itemlink where itemid1=5 94.68.244.159 admin 
137 22/01/2012  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='20', rackposdepth='6', usize='6', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0' WHERE id=5 94.68.244.159 admin 
136 22/01/2012  delete from contract2item where itemid=4 94.68.244.159 admin 
135 22/01/2012  delete from item2soft where itemid=4 94.68.244.159 admin 
134 22/01/2012  delete from item2inv where itemid=4 94.68.244.159 admin 
133 22/01/2012  delete from itemlink where itemid1=4 94.68.244.159 admin 
132 22/01/2012  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='Poweredge 2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='30', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2' WHERE id=4 94.68.244.159 admin 
131 22/01/2012  UPDATE itemtypes SET typedesc='switch', hassoftware=1 WHERE id='12' 94.68.244.159 admin 
130 22/01/2012  UPDATE itemtypes SET typedesc='router', hassoftware=1 WHERE id='9' 94.68.244.159 admin 
129 22/01/2012  UPDATE itemtypes SET typedesc='mobile-phone', hassoftware=1 WHERE id='15' 94.68.244.159 admin 
128 22/01/2012  UPDATE itemtypes SET typedesc='cable', hassoftware=0 WHERE id='22' 94.68.244.159 admin 
127 22/01/2012  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.244.159 admin 
126 22/01/2012  UPDATE itemtypes SET typedesc='VOIP-Phone', hassoftware=0 WHERE id='16' 94.68.244.159 admin 
125 22/01/2012  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.244.159 admin 
124 22/01/2012  UPDATE itemtypes SET typedesc='Storage-DAS', hassoftware=0 WHERE id='23' 94.68.244.159 admin 
123 22/01/2012  UPDATE itemtypes SET typedesc='Server', hassoftware=0 WHERE id='11' 94.68.244.159 admin 
122 22/01/2012  UPDATE itemtypes SET typedesc='Router', hassoftware=0 WHERE id='8' 94.68.244.159 admin 
121 22/01/2012  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.244.159 admin 
120 22/01/2012  UPDATE itemtypes SET typedesc='PDA', hassoftware=0 WHERE id='14' 94.68.244.159 admin 
119 22/01/2012  UPDATE itemtypes SET typedesc='PC-Portable', hassoftware=1 WHERE id='5' 94.68.244.159 admin 
118 22/01/2012  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.244.159 admin 
117 22/01/2012  UPDATE itemtypes SET typedesc='Motorized reader', hassoftware=0 WHERE id='10' 94.68.244.159 admin 
116 22/01/2012  UPDATE itemtypes SET typedesc='Monitor', hassoftware=0 WHERE id='7' 94.68.244.159 admin 
115 22/01/2012  UPDATE itemtypes SET typedesc='FAX', hassoftware=0 WHERE id='6' 94.68.244.159 admin 
114 22/01/2012  delete from contract2item where itemid=5 94.68.244.159 admin 
113 22/01/2012  delete from item2soft where itemid=5 94.68.244.159 admin 
112 22/01/2012  delete from item2inv where itemid=5 94.68.244.159 admin 
111 22/01/2012  delete from itemlink where itemid1=5 94.68.244.159 admin 
110 22/01/2012  UPDATE items set itemtypeid='23', function='', manufacturerid='2', label='', warrinfo='', model='MD1200', sn='', sn2='', sn3='456BCE', locationid='1', locareaid='', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='10', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='2', rackposdepth='6', usize='4', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0' WHERE id=5 94.68.244.159 admin 
109 22/01/2012  DELETE from contract2item where itemid=5 94.68.244.159 admin 
108 22/01/2012  DELETE from item2soft where itemid=5 94.68.244.159 admin 
107 22/01/2012  UPDATE itemtypes SET typedesc='switch', hassoftware=1 WHERE id='12' 94.68.244.159 admin 
106 22/01/2012  UPDATE itemtypes SET typedesc='router', hassoftware=1 WHERE id='9' 94.68.244.159 admin 
105 22/01/2012  UPDATE itemtypes SET typedesc='mobile-phone', hassoftware=1 WHERE id='15' 94.68.244.159 admin 
104 22/01/2012  UPDATE itemtypes SET typedesc='cable', hassoftware=0 WHERE id='22' 94.68.244.159 admin 
103 22/01/2012  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.244.159 admin 
102 22/01/2012  UPDATE itemtypes SET typedesc='VOIP-Phone', hassoftware=0 WHERE id='16' 94.68.244.159 admin 
101 22/01/2012  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.244.159 admin 
100 22/01/2012  UPDATE itemtypes SET typedesc='Server', hassoftware=0 WHERE id='11' 94.68.244.159 admin 
99 22/01/2012  UPDATE itemtypes SET typedesc='Router', hassoftware=0 WHERE id='8' 94.68.244.159 admin 
98 22/01/2012  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.244.159 admin 
97 22/01/2012  UPDATE itemtypes SET typedesc='PDA', hassoftware=0 WHERE id='14' 94.68.244.159 admin 
96 22/01/2012  UPDATE itemtypes SET typedesc='PC-Portable', hassoftware=1 WHERE id='5' 94.68.244.159 admin 
95 22/01/2012  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.244.159 admin 
94 22/01/2012  UPDATE itemtypes SET typedesc='Motorized reader', hassoftware=0 WHERE id='10' 94.68.244.159 admin 
93 22/01/2012  UPDATE itemtypes SET typedesc='Monitor', hassoftware=0 WHERE id='7' 94.68.244.159 admin 
92 22/01/2012  UPDATE itemtypes SET typedesc='FAX', hassoftware=0 WHERE id='6' 94.68.244.159 admin 
91 22/01/2012  delete from contract2item where itemid=4 94.68.244.159 admin 
90 22/01/2012  delete from item2soft where itemid=4 94.68.244.159 admin 
89 22/01/2012  delete from item2inv where itemid=4 94.68.244.159 admin 
88 22/01/2012  delete from itemlink where itemid1=4 94.68.244.159 admin 
87 22/01/2012  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='Poweredge 2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='3', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2' WHERE id=4 94.68.244.159 admin 
86 22/01/2012  delete from contract2item where itemid=4 94.68.244.159 admin 
85 22/01/2012  delete from item2soft where itemid=4 94.68.244.159 admin 
84 22/01/2012  delete from item2inv where itemid=4 94.68.244.159 admin 
83 22/01/2012  delete from itemlink where itemid1=4 94.68.244.159 admin 
82 22/01/2012  UPDATE items set itemtypeid='11', function='DNS Server', manufacturerid='2', label='', warrinfo='', model='2950', sn='', sn2='', sn3='123ABC', locationid='1', locareaid='1', origin='', warrantymonths=60, purchasedate='1326153600', purchprice='', dnsname='dns1', userid='1', comments='', maintenanceinfo='Clean with blower once every 12 months', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='3', rackposdepth='6', usize='2', status='0', macs='', ipv4='1.2.3.4', ipv6='', remadmip='', panelport='', switchid='3', switchport='', ports='2' WHERE id=4 94.68.244.159 admin 
81 22/01/2012  DELETE from contract2item where itemid=4 94.68.244.159 admin 
80 22/01/2012  DELETE from item2soft where itemid=4 94.68.244.159 admin 
79 22/01/2012  delete from contract2inv where invid=1 94.68.244.159 admin 
78 22/01/2012  delete from soft2inv where invid=1 94.68.244.159 admin 
77 22/01/2012  delete from item2inv where invid=1 94.68.244.159 admin 
76 22/01/2012  UPDATE invoices SET vendorid='2', buyerid='7', number='1234AB-C', description='', date='1327017600' WHERE id=1 94.68.244.159 admin 
75 22/01/2012  delete from contract2inv where invid=1 94.68.244.159 admin 
74 22/01/2012  delete from soft2inv where invid=1 94.68.244.159 admin 
73 22/01/2012  delete from item2inv where invid=1 94.68.244.159 admin 
72 22/01/2012  DELETE from tags where id=4 94.68.244.159 admin 
71 22/01/2012  DELETE from tags where id=5 94.68.244.159 admin 
70 22/01/2012  DELETE from itemtypes where id=17 94.68.244.159 admin 
69 22/01/2012  DELETE from itemtypes where id=19 94.68.244.159 admin 
68 22/01/2012  DELETE from itemtypes where id=18 94.68.244.159 admin 
67 22/01/2012  DELETE from itemtypes where id=21 94.68.244.159 admin 
66 22/01/2012  DELETE from itemtypes where id=13 94.68.244.159 admin 
65 22/01/2012  DELETE from itemtypes where id=20 94.68.244.159 admin 
64 01/08/2011  UPDATE users set username='admin', userdesc='administrator', pass='admin', usertype='1' WHERE id=1 94.68.227.213 admin 
63 01/08/2011  delete from contract2item where itemid=3 94.68.227.213 admin 
62 01/08/2011  delete from item2soft where itemid=3 94.68.227.213 admin 
61 01/08/2011  delete from item2inv where itemid=3 94.68.227.213 admin 
60 01/08/2011  delete from itemlink where itemid1=3 94.68.227.213 admin 
59 01/08/2011  UPDATE items set itemtypeid='8', function='', manufacturerid='3', label='', warrinfo='', model='Imaginary Router', sn='', sn2='', sn3='', locationid='1', locareaid='', origin='', warrantymonths=48, purchasedate='1282867200', purchprice='', dnsname='', userid='1', comments='', maintenanceinfo='', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='1', rackid='1', rackposition='10', rackposdepth='6', usize='3', status='0', macs='', ipv4='', ipv6='', remadmip='', panelport='', switchid='', switchport='', ports='0' WHERE id=3 94.68.227.213 admin 
58 01/08/2011  DELETE from contract2item where itemid=3 94.68.227.213 admin 
57 01/08/2011  DELETE from item2soft where itemid=3 94.68.227.213 admin 
56 01/08/2011  DELETE from contract2item where itemid=2 94.68.227.213 admin 
55 01/08/2011  DELETE from item2soft where itemid=2 94.68.227.213 admin 
54 01/08/2011  DELETE FROM contract2soft WHERE softid=1 94.68.227.213 admin 
53 01/08/2011  DELETE FROM soft2inv WHERE softid=1 94.68.227.213 admin 
52 01/08/2011  delete from item2soft where softid=1 94.68.227.213 admin 
51 01/08/2011  UPDATE software set invoiceid='', slicenseinfo='', manufacturerid='5', stitle='Enterprise Linux', sversion='6', sinfo='', purchdate='1304812800', licqty='1', lictype='0' WHERE id=1 94.68.227.213 admin 
50 08/05/2011  delete from contract2item where itemid=1 94.68.251.178 admin 
49 08/05/2011  delete from item2soft where itemid=1 94.68.251.178 admin 
48 08/05/2011  delete from item2inv where itemid=1 94.68.251.178 admin 
47 08/05/2011  delete from itemlink where itemid1=1 94.68.251.178 admin 
46 08/05/2011  UPDATE items set itemtypeid='1', function='software firewall', manufacturerid='2', label='', warrinfo='', model='Optiplex 790', sn='123-456', sn2='', sn3='', locationid='1:1', origin='', warrantymonths=36, purchasedate='', purchprice='', dnsname='zeus', userid='1', comments='', maintenanceinfo='', ispart='0', hd='', cpu='', cpuno='0', corespercpu='0', ram='', rackmountable='0', rackid='-', rackposition='-', rackposdepth='6', usize='-', status='0', macs='', ipv4='10.1.1.1', ipv6='', remadmip='', panelport='', switchid='-', switchport='', ports='0' WHERE id=1 94.68.251.178 admin 
45 08/05/2011  DELETE FROM contract2inv WHERE contractid=1 94.68.251.178 admin 
44 08/05/2011  DELETE FROM contract2soft WHERE contractid=1 94.68.251.178 admin 
43 08/05/2011  DELETE FROM contract2item WHERE contractid=1 94.68.251.178 admin 
42 08/05/2011  UPDATE contracts SET type='1', subtype='', title='Remote Support #1', number='A123456', description='400 Hours of remote admin support', comments='9:00-5:00', contractorid='6', startdate='1304208000', currentenddate='1336867200', renewals='#####admin', parentid='', totalcost='500' WHERE id=1 94.68.251.178 admin 
41 08/05/2011  DELETE FROM contract2inv WHERE contractid=1 94.68.251.178 admin 
40 08/05/2011  DELETE FROM contract2soft WHERE contractid=1 94.68.251.178 admin 
39 08/05/2011  DELETE FROM contract2item WHERE contractid=1 94.68.251.178 admin 
38 08/05/2011  UPDATE contracts SET type='1', subtype='', title='Remote Support #1', number='A123456', description='400 Hours of remote admin support', comments='9:00-5:00', contractorid='6', startdate='1304208000', currentenddate='1336867200', renewals='#####admin', parentid='', totalcost='500' WHERE id=1 94.68.251.178 admin 
37 08/05/2011  DELETE FROM contract2inv WHERE contractid=1 94.68.251.178 admin 
36 08/05/2011  DELETE FROM contract2soft WHERE contractid=1 94.68.251.178 admin 
35 08/05/2011  DELETE FROM contract2item WHERE contractid=1 94.68.251.178 admin 
34 08/05/2011  DELETE FROM contract2soft WHERE softid=1 94.68.251.178 admin 
33 08/05/2011  DELETE FROM soft2inv WHERE softid=1 94.68.251.178 admin 
32 08/05/2011  delete from item2soft where softid=1 94.68.251.178 admin 
31 08/05/2011  DELETE from contract2item where itemid=1 94.68.251.178 admin 
30 08/05/2011  DELETE from item2soft where itemid=1 94.68.251.178 admin 
29 08/05/2011  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.251.178 admin 
28 08/05/2011  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.251.178 admin 
27 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
26 08/05/2011  UPDATE itemtypes SET typedesc='PC-Portable', hassoftware=1 WHERE id='5' 94.68.251.178 admin 
25 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
24 08/05/2011  UPDATE itemtypes SET typedesc='Monitor', hassoftware=0 WHERE id='7' 94.68.251.178 admin 
23 08/05/2011  UPDATE itemtypes SET typedesc='FAX', hassoftware=0 WHERE id='6' 94.68.251.178 admin 
22 08/05/2011  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.251.178 admin 
21 08/05/2011  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.251.178 admin 
20 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
19 08/05/2011  UPDATE itemtypes SET typedesc='PC-Portable', hassoftware=1 WHERE id='5' 94.68.251.178 admin 
18 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
17 08/05/2011  UPDATE itemtypes SET typedesc='FAX', hassoftware=0 WHERE id='6' 94.68.251.178 admin 
16 08/05/2011  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.251.178 admin 
15 08/05/2011  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.251.178 admin 
14 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
13 08/05/2011  UPDATE itemtypes SET typedesc='PC-Portable', hassoftware=1 WHERE id='5' 94.68.251.178 admin 
12 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
11 08/05/2011  UPDATE itemtypes SET typedesc='WiFi Access Point', hassoftware=0 WHERE id='4' 94.68.251.178 admin 
10 08/05/2011  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.251.178 admin 
9 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
8 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
7 08/05/2011  UPDATE itemtypes SET typedesc='UPS', hassoftware=0 WHERE id='3' 94.68.251.178 admin 
6 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
5 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
4 08/05/2011  UPDATE itemtypes SET typedesc='Printer', hassoftware=0 WHERE id='2' 94.68.251.178 admin 
3 08/05/2011  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 94.68.251.178 admin 
2 23/11/2010  UPDATE contracttypes SET name='Support & Maintenance' WHERE id='1' 195.130.122.26 admin 
1 23/11/2010  UPDATE itemtypes SET typedesc='PC', hassoftware=1 WHERE id='1' 195.130.122.26 admin 
server time = 0.012 secs