Urgent Bug, htp()

Ja Steam
2011-02-12
2013-05-28
  • Ja Steam
    Ja Steam
    2011-02-12

    Hello,

    I'm not sure why this happened, but at some point, I had a comma removed during the output using, htp().

    First 50 rows were properly formatted. The next 50 rows end up with a missing comma !

    See last line(missing comma between service_tag and  status_name):

      
            {
                "INVENTORY_ID": 770,
                "INVENTORY_NAME": "HUBDB",
                "CUST_ID": null,
                "CUST_NAME": "",
                "SERVICE_TAG": "96J",
                "STATUS_NAME": "Production",
                "HARDWARE_TYPE": "SERVER",
                "MODEL_NAME": "PE 1950",
                "EXPIRY_DATE": "2010-07-03 00:00:00",
                "ETH0": "",
                "WARRANTY_NAME": "s",
                "SUPPLIER_NAME": "Dell",
                "PROJECT_NAME": "",
                "COST_CENTER_NAME": "",
                "RACK_NAME": "",
                "DATA_CENTER_NAME": "",
                "SEQ": 70,
                "TOTALROWS": 338
            },
            {
                "INVENTORY_ID": 772,
                "INVENTORY_NAME": "HUBDB20A",
                "CUST_ID": null,
                "CUST_NAME": "",
              [b]  "SERVICE_TAG": "B6T603J""STATUS_NAME": "Production",[/b]
    
     
  • Ja Steam
    Ja Steam
    2011-02-12

    Current work around

    -> htp.p(jsonObj.to_char);

    Cannot replicate bug. I'm pulling 50 rows at a time. First set is ok, second set is missing a comma as highlighted above.

     
  • Please post the entire output which fails.

     
  • Ja Steam
    Ja Steam
    2011-02-14

    Oddly, the first 50 rows come out ok. The the next 50 go wrong.

    DECLARE
    ret json_list; 
    jsonObj json;
    tempObj json;
    tempData json_value;
    p_query varchar2(25) :='';
    vSQL varchar2(2000) := ' SELECT inventory_name FROM ( SELECT q.*
                                                ,rownum seq
                                                ,count(*) over () totalrows 
                                                FROM ( SELECT inventory_name 
                                                      FROM mvw_inventory
                                                      WHERE (lower(inventory_name) like lower(''%'||p_query||'%'')
                                                          or  lower(status_name) like lower(''%'||p_query||'%'')
                                                          or  lower(cust_name) like lower(''%'||p_query||'%'')
                                                          or  lower(model_name) like lower(''%'||p_query||'%'')
                                                          or  lower(warranty_name) like lower(''%'||p_query||'%'')
                                                          or  lower(service_tag) like lower(''%'||p_query||'%'')
                                                          or  lower(eth0) like lower(''%'||p_query||'%'')
                                                          or  lower(cost_center_name) like lower(''%'||p_query||'%'')
                                                          or  lower(project_name) like lower(''%'||p_query||'%'')
                                                          or  lower(hardware_type) like lower(''%'||p_query||'%'')
                                                          or  lower(data_center_name) like lower(''%'||p_query||'%''))
                                               ) q
                                               )
                                WHERE  seq >  0
                              AND seq <=  0 +  50';
                              -- seq <= 50 + 50 ;
    BEGIN
      jsonObj := json();
       dbms_output.put_line(vSQL);
      ret := json_dyn.executeList(vSQL);
        tempObj := json(ret.get_elem(1));
        tempData := tempObj.get('TOTALROWS');
        jsonObj.put('total',to_number(tempData.to_char)); 
        jsonObj.put('results',ret);
        -- bug with HTP.()
        jsonObj.htp();
        --jsonObj.print;
        
    END;
    
     
  • Ja Steam
    Ja Steam
    2011-02-14

    Sorry, small mistake its not limited on inventory_name its *.

    Here is the proper version:

    DECLARE
    ret json_list; 
    jsonObj json;
    tempObj json;
    tempData json_value;
    field varchar2(35) := 'INVENTORY_NAME';
    dir varchar2(5) := 'ASC';
    p_query varchar2(25) :='';
    vSQL varchar2(2000) := ' SELECT * FROM ( SELECT q.*
                                                ,rownum seq
                                                ,count(*) over () totalrows 
                                                FROM ( SELECT * 
                                                      FROM mvw_inventory
                                                      WHERE (lower(inventory_name) like lower(''%'||p_query||'%'')
                                                          or  lower(status_name) like lower(''%'||p_query||'%'')
                                                          or  lower(cust_name) like lower(''%'||p_query||'%'')
                                                          or  lower(model_name) like lower(''%'||p_query||'%'')
                                                          or  lower(warranty_name) like lower(''%'||p_query||'%'')
                                                          or  lower(service_tag) like lower(''%'||p_query||'%'')
                                                          or  lower(eth0) like lower(''%'||p_query||'%'')
                                                          or  lower(cost_center_name) like lower(''%'||p_query||'%'')
                                                          or  lower(project_name) like lower(''%'||p_query||'%'')
                                                          or  lower(hardware_type) like lower(''%'||p_query||'%'')
                                                          or  lower(data_center_name) like lower(''%'||p_query||'%''))
                                               ) q
                                               )
                                WHERE  seq >  0
                                AND seq <=  0 +  50';
                                -- seq <= 50 + 50;
    BEGIN
      --create empty structure
      jsonObj := json();
      --IF cust IS NULL THEN
       --dbms_output.put_line(vSQL);
    
         ret := json_dyn.executeList(vSQL);
        
      
        tempObj := json(ret.get_elem(1));
        tempData := tempObj.get('TOTALROWS');
        jsonObj.put('total',to_number(tempData.to_char)); 
        jsonObj.put('results',ret);
        -- bug with HTP.()
       ----------------jsonObj.htp();
        --HTP.P(jsonObj.to_char);
        --dbms_output.put_line(jsonObj.to_char);
        jsonObj.print;
        
    END;
    
     
  • Hi,

    I do not have a database with same tables that you got, but the syntax looks alright.
    Can you post the json output, then I can try to debug.

    /Jonas

     
  • Ja Steam
    Ja Steam
    2011-02-15

    Hello Jonas,

    I will look at  your code, but I have a feeling that it will be orientated around the trim of a comma when going through the CLOB.

    Thanks for your help.

     
  • Ja Steam
    Ja Steam
    2011-03-27

    Hello Jonas,

    Still having difficulties with large output., this time it fail in a """. see line 279(JSONLint)

    {"results":[{"INVENTORY_ID":810,"INVENTORY_NAME":"HUBAPP11","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.11","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":900,"INVENTORY_NAME":"ORIDB05","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"21D133J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-08-05 00:00:00","ETH0":"10.196.8.139","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":758,"INVENTORY_NAME":"HUBSTBY10B","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"F8Y0J1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2008-02-19 00:00:00","ETH0":"10.3.101.2","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1016,"INVENTORY_NAME":"NOTEBOOK 3","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GP5B04J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-10-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1228,"INVENTORY_NAME":"MONITOR 13","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2008","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1315,"INVENTORY_NAME":"MONITOR 56","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":688,"INVENTORY_NAME":"IFSDB3","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6XH6D1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 6650","EXPIRY_DATE":"2004-01-01 00:00:00","ETH0":"10.3.72.10","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":764,"INVENTORY_NAME":"HUBSTBY30A","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JGC3S1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2008-08-08 00:00:00","ETH0":"10.3.101.21","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK-K5","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":716,"INVENTORY_NAME":"CDWH","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"1SZ8R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-02-01 00:00:00","ETH0":"10.3.44.99","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"DWH","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1305,"INVENTORY_NAME":"MONITOR 51","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPV","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":668,"INVENTORY_NAME":"UBAPP01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JK65TY","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2012-06-30 00:00:00","ETH0":"10.3.97.1","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":748,"INVENTORY_NAME":"CGN-APP04","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"23ZH93J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-11-26 00:00:00","ETH0":"10.3.74.4","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1369,"INVENTORY_NAME":"CGN-APP02","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"2NRGX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-05-09 00:00:00","ETH0":"10.3.74.2","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"GIT","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":944,"INVENTORY_NAME":"RACK-K1","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1162,"INVENTORY_NAME":"NOTEBOOK 76","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9ZBV03J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-07-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1104,"INVENTORY_NAME":"NOTEBOOK 47","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BC5K31J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D600","EXPIRY_DATE":"2007-04-22 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1116,"INVENTORY_NAME":"NOTEBOOK 53","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"B3HT03J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-07-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":682,"INVENTORY_NAME":"IFSDB6","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"3L0TX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-05-16 00:00:00","ETH0":"10.1.1.55","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1038,"INVENTORY_NAME":"NOTEBOOK 14","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"DY7DL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-11-13 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1112,"INVENTORY_NAME":"NOTEBOOK 51","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"C441N1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude X1","EXPIRY_DATE":"2008-05-11 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1222,"INVENTORY_NAME":"MONITOR 10","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1261,"INVENTORY_NAME":"MONITOR 29","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":780,"INVENTORY_NAME":"IFS-STY","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GRD3B3J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-12-04 00:00:00","ETH0":"10.3.72.9","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1363,"INVENTORY_NAME":"MONITOR 80","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPV","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":866,"INVENTORY_NAME":"RACK03","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":756,"INVENTORY_NAME":"HUBSTBY30B","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5W0S81J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2007-09-21 00:00:00","ETH0":"10.3.101.22","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1130,"INVENTORY_NAME":"NOTEBOOK 60","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BPDSL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-11-20 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":724,"INVENTORY_NAME":"DWHAPP2","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"1R4L42J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2009-03-05 00:00:00","ETH0":"10.3.72.22","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"DWH","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":908,"INVENTORY_NAME":"IFS01-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"DS93B3J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-12-04 00:00:00","ETH0":"10.3.253.92","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":910,"INVENTORY_NAME":"IFS-STBY-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"C73TX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-05-16 00:00:00","ETH0":"10.3.253.96","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"RACK10","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":968,"INVENTORY_NAME":"JDA-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"3X1M94J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2012-04-26 00:00:00","ETH0":"10.3.253.102","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"RACK-66","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":714,"INVENTORY_NAME":"IFSAPP3","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BFPRL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2009-11-21 00:00:00","ETH0":"10.3.72.18","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":828,"INVENTORY_NAME":"ORIWEB02","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4P7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"10.196.9.2","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1407,"INVENTORY_NAME":"RT-TST-01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"75498812","STATUS_NAME":"Testing","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"1721 Modular Access Router","EXPIRY_DATE":"2013-03-22 00:00:00","ETH0":"182.16.33.2","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"RACK05","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1170,"INVENTORY_NAME":"NOTEBOOK 80","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9GWZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1018,"INVENTORY_NAME":"NOTEBOOK 4","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"3VLPG4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2012-09-21 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":902,"INVENTORY_NAME":"ORIDB04","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"51D133J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-08-05 00:00:00","ETH0":"10.196.8.138","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1026,"INVENTORY_NAME":"NOTEBOOK 8","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"2KJ5S3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-07-15 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1246,"INVENTORY_NAME":"MONITOR 22","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":964,"INVENTORY_NAME":"KCP-BLADE04","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"G6LFX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-05-07 00:00:00","ETH0":"10.196.253.6","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K1","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1333,"INVENTORY_NAME":"MONITOR 65","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":904,"INVENTORY_NAME":"ORIDB06","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"41D133J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-08-06 00:00:00","ETH0":"10.196.8.140","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1339,"INVENTORY_NAME":"MONITOR 68","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1343,"INVENTORY_NAME":"MONITOR 70","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1909W","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVETORY_ID":824,"INVENTORY_NAME":"ORIMQ02","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"2P7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":754,"INVENTORY_NAME":"HUBSTBY20B","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1W0S81J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2007-09-21 00:00:00","ETH0":"10.3.101.12","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1066,"INVENTORY_NAME":"NOTEBOOK 28","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4XGKH2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-10-01 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"QS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":572,"INVENTORY_NAME":"POWER01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"23982183429021","STATUS_NAME":"Production","HARDWARE_TYPE":"POWER","MODEL_NAME":"Pronix Modular Line 2x20","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Pronix","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":848,"INVENTORY_NAME":"ESHOP06","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"B1NR53J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-10-03 00:00:00","ETH0":"10.3.98.6","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":638,"INVENTORY_NAME":"KCP-BLADE03","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"4QNS92J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-06-09 00:00:00","ETH0":"10.196.253.4","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K2","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":648,"INVENTORY_NAME":"HUB-BLADE02","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"DWJGX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-05-09 00:00:00","ETH0":"10.3.253.7","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK07","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1054,"INVENTORY_NAME":"NOTEBOOK 22","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6QW064J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4200","EXPIRY_DATE":"2012-01-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1252,"INVENTORY_NAME":"MONITOR 25","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1285,"INVENTORY_NAME":"MONITOR 41","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":778,"INVENTORY_NAME":"IFSDB8","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FN7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":920,"INVENTORY_NAME":"CDWH-STBY","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"6H1MZB1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2010-02-06 00:00:00","ETH0":"10.3.253.80","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Online","COST_CENTER_NAME":"ERP","RACK_NAME":"RACK-K3","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1405,"INVENTORY_NAME":"SRV-TST-01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"414INTM1","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2014-03-19 00:00:00","ETH0":"172.12.1.48","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Email Marketing","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK-K4","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":834,"INVENTORY_NAME":"ORIMQ01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JN7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1118,"INVENTORY_NAME":"NOTEBOOK 54","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"63WZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":776,"INVENTORY_NAME":"HUBDB30A","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"71D133J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-09-02 00:00:00","ETH0":"10.3.100.21","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":702,"INVENTORY_NAME":"MGMT","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JW03R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-01-30 00:00:00","ETH0":"10.3.72.160","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":650,"INVENTORY_NAME":"HUB-BLADE01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"2BCRL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2009-11-21 00:00:00","ETH0":"10.3.253.5","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK07","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":628,"INVENTORY_NAME":"RT-BGP-1","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"78005443","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"7201 Router","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1084,"INVENTORY_NAME":"NOTEBOOK 37","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"F1G954J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-01-14 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":774,"INVENTORY_NAME":"HUBDB20B","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"C6T603J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-03 00:00:00","ETH0":"10.3.100.12","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1210,"INVENTORY_NAME":"MONITOR 4","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1277,"INVENTORY_NAME":"MONITOR 37","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1319,"INVENTORY_NAME":"MONITOR 58","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":720,"INVENTORY_NAME":"IFSAPP4","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"J30J83J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-11-12 00:00:00","ETH0":"10.3.72.19","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":962,"INVENTORY_NAME":"KCP-BLADE02","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"34KGX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-05-03 00:00:00","ETH0":"10.196.253.2","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K4","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":788,"INVENTORY_NAME":"TXT-STBY","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"GSD3B3J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-12-04 00:00:00","ETH0":"10.3.75.34","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"TXT","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":860,"INVENTORY_NAME":"EPI-SERVER","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5KZ6C2J ","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2950","EXPIRY_DATE":"2009-07-07 00:00:00","ETH0":"10.3.75.73","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1080,"INVENTORY_NAME":"NOTEBOOK 35","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FNZ953J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-26 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1070,"INVENTORY_NAME":"NOTEBOOK 30","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"425FG4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-09-12 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1042,"INVENTORY_NAME":"NOTEBOOK 16","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"43WZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"GIT","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1078,"INVENTORY_NAME":"NOTEBOOK 34","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HJBPR1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Optiplex GX280","EXPIRY_DATE":"2009-07-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":752,"INVENTORY_NAME":"CGN-APP05","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"D2ZH93J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-11-26 00:00:00","ETH0":"10.3.74.5","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"ERP","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":880,"INVENTORY_NAME":"RACK12","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Rital - Water Cooled","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":812,"INVENTORY_NAME":"HUBAPP18","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.18","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1166,"INVENTORY_NAME":"NOTEBOOK 78","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"255B74J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2012-02-25 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1299,"INVENTORY_NAME":"MONITOR 48","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2008","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":814,"INVENTORY_NAME":"HUBAPP12","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.12","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1072,"INVENTORY_NAME":"NOTEBOOK 31","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5XGKH2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-10-01 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":652,"INVENTORY_NAME":"KCP-BLADE05","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"GVNFX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-05-07 00:00:00","ETH0":"10.3.253.3","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-64","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1108,"INVENTORY_NAME":"NOTEBOOK 49","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5V6P83J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-11-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1152,"INVENTORY_NAME":"NOTEBOOK 71","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"53WZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1134,"INVENTORY_NAME":"NOTEBOOK 62","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9J9YB4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2012-05-27 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1082,"INVENTORY_NAME":"NOTEBOOK 36","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"90LHR1J","STATUS_NAME":"Prduction","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D610","EXPIRY_DATE":"2008-07-24 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":674,"INVENTORY_NAME":"ORIDB01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BVWHN1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2008-05-24 00:00:00","ETH0":"10.196.8.128","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1204,"INVENTORY_NAME":"MONITOR 1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1230,"INVENTORY_NAME":"MONITOR 14","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1909W","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":960,"INVENTORY_NAME":"KCP-BLADE01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"DL5ST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PEM1000e (16 slots)","EXPIRY_DATE":"2013-07-22 00:00:00","ETH0":"10.196.253.1","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K5","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":836,"INVENTORY_NAME":"ORIMQ03","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5K8792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"10.10.10.10","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1056,"INVENTORY_NAME":"NOTEBOOK 23","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1YD052J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"OptiPlex GX620","EXPIRY_DATE":"2009-03-14 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"GIT","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1325,"INVENTORY_NAME":"MONITOR 61","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1032,"INVENTORY_NAME":"NOTEBOOK 11","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"161PB2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-06-26 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1110,"INVENTORY_NAME":"NOTEBOOK 50","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"44VT03J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-07-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1138,"INVENTORY_NAME":"NOTEBOOK 64","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6CZFD1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D400","EXPIRY_DATE":"2007-12-07 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1303,"INVENTORY_NAME":"MONITOR 50","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2007","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":726,"INVENTORY_NAME":"DWHAPPT","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"BJR7G2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2009-08-24 00:00:00","ETH0":"192.168.2.44","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1226,"INVENTORY_NAME":"MONITOR 12","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1242,"INVENTORY_NAME":"MONITOR 20","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1283,"INVENTORY_NAME":"MONITOR 40","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1240,"INVENTORY_NAME":"MONITOR 19","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2003","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1150,"INVENTORY_NAME":"NOTEBOOK 70","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"693163J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-10-06 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1148,"INVENTORY_NAME":"NOTEBOOK 69","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BHG693J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2010-11-25 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"DWH","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":918,"INVENTORY_NAME":"EXTSTCX01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"3MKF0D1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2010-08-05 00:00:00","ETH0":"10.196.253.64","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"RACK-K1","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":642,"INVENTORY_NAME":"HUB-BLADE05","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"FNJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PEM1000e (16 slots)","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.253.12","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK10","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":822,"INVENTORY_NAME":"ORISTWEB01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1P7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"10.196.9.31","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1180,"INVENTORY_NAME":"NOTEBOOK 85","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GR0HS3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D430","XPIRY_DATE":"2011-07-02 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1232,"INVENTORY_NAME":"MONITOR 15","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2007","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1351,"INVENTORY_NAME":"MONITOR 74","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2008","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1301,"INVENTORY_NAME":"MONITOR 49","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":784,"INVENTORY_NAME":"TXT-APP03","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"H30J83J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-11-12 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"TXT","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":856,"INVENTORY_NAME":"RACK02","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1317,"INVENTORY_NAME":"MONITOR 57","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1909W","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":906,"INVENTORY_NAME":"QADBTEST","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8BFB32J","STATUS_NAME":"Testing","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2009-02-11 00:00:00","ETH0":"10.3.104.136","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"QA","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":930,"INVENTORY_NAME":"HUBCX03old","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"4L64S1J","STATUS_NAME":"Offline","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2008-08-08 00:00:00","ETH0":"10.3.253.74","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1331,"INVENTORY_NAME":"MONITOR 64","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2006","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":708,"INVENTORY_NAME":"IFSBCK","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"57RSL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2950","EXPIRY_DATE":"2009-11-21 00:00:00","ETH0":"10.3.72.100","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":912,"INVENTORY_NAME":"CGN-TXT-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"4YYNX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-05-14 00:00:00","ETH0":"10.3.253.94","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-K5","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":914,"INVENTORY_NAME":"JDA-STBY-SAS","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"7KKH93J","STATUS_NAME":"Offline","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-11-26 00:00:00","ETH0":"10.3.253.90","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":722,"INVENTORY_NAME":"CITRIX WEBINT","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"6772R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-01-30 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":830,"INVENTORY_NAME":"ORISUPP02","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GN7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":626,"INVENTORY_NAME":"RT-BGP-2","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"78005451","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"7201 Router","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":976,"INVENTORY_NAME":"HUBCX01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"385NHH1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX4-240","EXPIRY_DATE":"2012-05-06 00:00:00","ETH0":"10.3.253.104","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK11","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1100,"INVENTORY_NAME":"NOTEBOOK 45","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"2VH070J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"OptiPlex GX150","EXPIRY_DATE":"2004-08-29 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":618,"INVENTORY_NAME":"OSW-ASA","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"JMX1132L0FA","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"ASA5520","EXPIRY_DATE":"2009-05-05 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1094,"INVENTORY_NAME":"NOTEBOOK 42","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"H3Y953J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-26 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"QS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":736,"INVENTORY_NAME":"WEBTRENDS","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BP4JX3J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"R900","EXPIRY_DATE":"2011-09-02 00:00:00","ETH0":"10.6.100.34","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1014,"INVENTORY_NAME":"NOTEBOOK 2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FKNJ71J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude X300","EXPIRY_DATE":"2007-08-17 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1208,"INVENTORY_NAME":"MONITOR 3","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIR_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1132,"INVENTORY_NAME":"NOTEBOOK 61","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9PZ2H2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-09-21 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1046,"INVENTORY_NAME":"NOTEBOOK 18","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"G5VT03J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-07-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":936,"INVENTORY_NAME":"HUBCX05","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"75L9D2J","STATUS_NAME":"Testing","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2010-07-27 00:00:00","ETH0":"10.3.253.76","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":922,"INVENTORY_NAME":"CGN-TXT-STBY-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"359103J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-06-27 00:00:00","ETH0":"10.3.253.98","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK04","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":696,"INVENTORY_NAME":"CITRIX2","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"94R6R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-01-31 00:00:00","ETH0":"10.3.72.33","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":826,"INVENTORY_NAME":"ORIWEB01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"3P7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"10.196.9.1","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":888,"INVENTORY_NAME":"JDA-DB01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"3J4M94J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"R610","EXPIRY_DATE":"2012-04-26 00:00:00","ETH0":"10.3.74.70","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"TXT","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":980,"INVENTORY_NAME":"KCPCX01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"J75NHH1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX4-240","EXPIRY_DATE":"2012-05-06 00:00:00","ETH0":"10.196.253.66","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK-K3","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":786,"INVENTORY_NAME":"TXT-DB01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JFB103J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-06-27 00:00:00","ETH0":"10.3.75.33","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"TXT","COST_CENTER_NAME":"DWH","RACK_NAME":"RACK04","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":692,"INVENTORY_NAME":"IFSDB5","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5FPRL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2009-11-21 00:00:00","ETH0":"10.3.72.12","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":838,"INVENTORY_NAME":"ESHOP02","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"240J83J ","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-11-12 00:00:00","ETH0":"10.3.98.2","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1088,"INVENTORY_NAME":"NOTEBOOK 39","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"3SZ753J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-25 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1214,"INVENTORY_NAME":"MONITOR 6","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":670,"INVENTORY_NAME":"PRG-QADBTEST2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"DDLTM1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2008-05-10 00:00:00","ETH0":"10.3.104.133","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"QA","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1220,"INVENTORY_NAME":"MONITOR 9","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPV","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1359,"INVENTORY_NAME":"MONITOR 78","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1206,"INVENTORY_NAME":"MONITOR 2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1238,"INVENTORY_NAME":"MONITOR 18","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1244,"INVENTORY_NAME":"MONITOR 21","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1250,"INVENTORY_NAME":"MONITOR 24","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1349,"INVENTORY_NAME":"MONITOR 73","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1907FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1256,"INVENTORY_NAME":"MONITOR 27","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"E178FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1176,"INVENTORY_NAME":"NOTEBOOK 83","CUST_ID":null,"CUST_NAME""","SERVICE_TAG":"JXWR44J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2012-01-05 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":940,"INVENTORY_NAME":"APP-SERVER-NEW2","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"6Z5BG4J","STATUS_NAME":"Development","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M610","EXPIRY_DATE":"2012-09-14 00:00:00","ETH0":"172.16.3.59","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":808,"INVENTORY_NAME":"HUBAPP19","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"CFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.19","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":916,"INVENTORY_NAME":"EXTCX01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"DGV4P1J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2010-06-09 00:00:00","ETH0":"10.196.8.12","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"RACK-K5","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1323,"INVENTORY_NAME":"MONITOR 60","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1908FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":832,"INVENTORY_NAME":"ORISUPP01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HN7792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1086,"INVENTORY_NAME":"NOTEBOOK 38","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"82WZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1064,"INVENTORY_NAME":"NOTEBOOK 27","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"922JH1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude X300","EXPIRY_DATE":"2008-02-08 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1124,"INVENTORY_NAME":"NOTEBOOK 57","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"602944J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4200","EXPIRY_DATE":"2011-12-21 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":766,"INVENTORY_NAME":"HUBSTBY10A","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1HC3S1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2008-08-08 00:00:00","ETH0":"10.3.101.1","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":634,"INVENTORY_NAME":"VPN-KCP","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"FCZ11327209","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"3825 Integrated Services Router","EXPIRY_DATE":"2009-08-30 00:00:00","ETH0":"","WARRANTY_NAME":"1 year ext","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1357,"INVENTORY_NAME":"MONITOR 77","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1216,"INVENTORY_NAME":"MONITOR 7","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1289,"INVENTORY_NAME":"MONITOR 43","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1248,"INVENTORY_NAME":"MONITOR 23","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1281,"INVENTORY_NAME":"MONITOR 39","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1908FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1313,"INVENTORY_NAME":"MONITOR 55","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1908FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":728,"INVENTORY_NAME":"RDWH","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JJZST1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2008-09-15 00:00:00","ETH0":"10.3.72.102","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"DWH","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1114,"INVENTORY_NAME":"NOTEBOOK 52","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"7T1YR2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2010-02-17 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1146,"INVENTORY_NAME":"NOTEBOOK 68","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5KJ5S3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-08-15 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1174,"INVENTORY_NAME":"NOTEBOOK 82","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8GWZ94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":970,"INVENTORY_NAME":"CDWH-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"G87YT3J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2013-07-23 00:00:00","ETH0":"10.3.253.100","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"DWH","COST_CENTER_NAME":"SP-EX","RACK_NAME":"RACK-K4","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1393,"INVENTORY_NAME":"TESTBLADE","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"TESTBLADE","STATUS_NAME":"Development","HARDWARE_TYPE:"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-09-23 00:00:00","ETH0":"","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"HUB","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1106,"INVENTORY_NAME":"NOTEBOOK 48","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"3YD0S2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2010-02-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":644,"INVENTORY_NAME":"HUB-BLADE04","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"66KST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PEM1000e (16 slots)","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.253.11","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK12","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":802,"INVENTORY_NAME":"HUBAPP14","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"7GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.14","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":952,"INVENTORY_NAME":"RACK-K5","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"noname","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":772,"INVENTORY_NAME":"HUBDB20A","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"B6T603J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-03 00:00:00","ETH0":"10.3.100.11","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1365,"INVENTORY_NAME":"MONITOR 81","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1279,"INVENTORY_NAME":"MONITOR 38","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":746,"INVENTORY_NAME":"CGN-APP03","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"3NRGX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-05-09 00:00:00","ETH0":"10.3.74.3","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1353,"INVENTORY_NAME":"MONITOR 75","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1909W","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1020,"INVENTORY_NAME":"NOTEBOOK 5","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GCPGS3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2011-07-02 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1098,"INVENTORY_NAME":"NOTEBOOK 44","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"7V6P83J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-11-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1329,"INVENTORY_NAME":"MONITOR 63","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":684,"INVENTORY_NAME":"IFSDB1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1HP0F2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2009-08-10 00:00:00","ETH0":"10.3.72.7","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":858,"INVENTORY_NAME":"E-ROOM","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"80J6C2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2950","EXPIRY_DATE":"2009-07-07 00:00:00","ETH0":"10.3.75.72","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1403,"INVENTORY_NAME":"CHA-TST-01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"442JSN1","STATUS_NAME":"Development","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2014-03-19 00:00:00","ETH0":"172.16.2.44","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1074,"INVENTORY_NAME":"NOTEBOOK 32","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"529G54J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-01-18 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1068,"INVENTORY_NAME":"NOTEBOOK 29","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"296962J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D610","EXPIRY_DATE":"2009-04-04 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":790,"INVENTORY_NAME":"HUBAPP09","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.9","WARRANTY_NAME":"1 year","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1060,"INVENTORY_NAME":"NOTEBOOK 25","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6V6P83J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-11-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1401,"INVENTORY_NAME":"DA-TST-01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"443INTM1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2016-03-19 00:00:00","ETH0":"172.2.16.45","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1335,"INVENTORY_NAME":"MONITOR 66","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":706,"INVENTORY_NAME":"IFSTERM2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HWFW32J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVE","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2009-02-22 00:00:00","ETH0":"10.3.72.25","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":820,"INVENTORY_NAME":"ORISTAPP01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6K8792J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1855","EXPIRY_DATE":"2010-05-26 00:00:00","ETH0":"","WARRANTY_NAME":"4 years ext","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":816,"INVENTORY_NAME":"HUBAPP22","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5P0WQ3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-06-10 00:00:00","ETH0":"10.3.96.22","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":672,"INVENTORY_NAME":"Online-exstore01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4H8C82J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2009-05-08 00:00:00","ETH0":"undefined","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1309,"INVENTORY_NAME":"MONITOR 53","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1263,"INVENTORY_NAME":"MONITOR 30","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1267,"INVENTORY_NAME":"MONITOR 32","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1909V","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1371,"INVENTORY_NAME":"HUBAPP10","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.93.10","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":632,"INVENTORY_NAME":"VPN-OSW","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"FCZ1144706N","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"3825 Integrated Services Router","EXPIRY_DATE":"2009-11-30 00:00:00","ETH0":"","WARRANTY_NAME":"1 year","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK06","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":942,"INVENTORY_NAME":"ESX01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"CW9LD4J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M610","EXPIRY_DATE":"2012-04-15 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":948,"INVENTORY_NAME":"RACK-K3","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":874,"INVENTORY_NAME":"RACK07","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":796,"INVENTORY_NAME":"HUBAPP21","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.96.21","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":844,"INVENTORY_NAME":"IFSAPP05","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JFJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.72.20","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1034,"INVENTORY_NAME":"NOTEBOOK 12","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JCQ2Q2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2010-01-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1048,"INVENTORY_NAME":"NOTEBOOK 19","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9Y04B4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2012-05-04 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":616,"INVENTORY_NAME":"RT-PRG-OLO","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"JAD07040L7P","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"2611XM Multiservice Router","EXPIRY_DATE":"2009-06-16 00:00:00","ETH0":"192.168.22.12","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K4","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":704,"INVENTORY_NAME":"IFSTERM1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8YSZC1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2007-11-30 00:00:00","ETH0":"10.3.72.24","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1361,"INVENTORY_NAME":"MONITOR 79","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1291,"INVENTORY_NAME":"MONITOR 44","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1050,"INVENTORY_NAME":"NOTEBOOK 20","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HY08S2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2010-02-22 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1341,"INVENTORY_NAME":"MONITOR 69","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1908FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1028,"INVENTORY_NAME":"NOTEBOOK 9","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"J51PB2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-06-26 00:00:00","ETH0":"","WARRANTY_NME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1024,"INVENTORY_NAME":"NOTEBOOK 7","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HX0FK0J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude C400","EXPIRY_DATE":"2005-11-17 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"ADM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1102,"INVENTORY_NAME":"NOTEBOOK 46","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"825QS2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"OptiPlex 745","EXPIRY_DATE":"2010-03-04 00:00:00","ETH0":"","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":850,"INVENTORY_NAME":"ESHOP07","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"91NR53J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-10-03 00:00:00","ETH0":"10.3.98.7","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1022,"INVENTORY_NAME":"NOTEBOOK 6","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GPL0C2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-07-03 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":654,"INVENTORY_NAME":"KCP-BLADE06","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"D1LS92J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-06-07 00:00:00","ETH0":"10.3.253.1","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":958,"INVENTORY_NAME":"RACK-66","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"noname","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1254,"INVENTORY_NAME":"MONITOR 26","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2008","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":768,"INVENTORY_NAME":"HUBDB10A","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"86T603J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-03 00:00:00","ETH0":"10.109.101.92","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1224,"INVENTORY_NAME":"MONITOR 11","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1355,"INVENTORY_NAME":"MONITOR 76","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1218,"INVENTORY_NAME":"MONITOR 8","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":742,"INVENTORY_NAME":"CGN-APP01","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"1NRGX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-05-09 00:00:00","ETH0":"10.3.74.1","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":630,"INVENTORY_NAME":"KCP-ASA","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"JMX1132L0FB","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"ASA5520","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":738,"INVENTORY_NAME":"CGN-CONDB","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"DT7PX2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-05-14 00:00:00","ETH0":"10.3.75.66","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Cognos Planning","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":972,"INVENTORY_NAME":"XBACKUP-SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"CPD5D4J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2012-07-07 00:00:00","ETH0":"10.3.253.106","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK10","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":698,"INVENTORY_NAME":"CITRIX3","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"6FPRL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-01-31 00:00:00","ETH0":"10.3.72.34","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1090,"INVENTORY_NAME":"NOTEBOOK 40","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"128GG3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-02-06 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":954,"INVENTORY_NAME":"RACK-64","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"noname","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1160,"INVENTORY_NAME":"NOTEBOOK 75","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"7TBQ64J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2009-02-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1178,"INVENTORY_NAME":"NOTEBOOK 84","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GMY823J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D430","EXPIRY_DATE":"2010-08-01 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1269,"INVENTORY_NAME":"MONITOR 33","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2004","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1271,"INVENTORY_NAME":"MONITOR 34","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2005","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell",PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":946,"INVENTORY_NAME":"RACK-K2","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":818,"INVENTORY_NAME":"HUBDB30B","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"81D133J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-09-02 00:00:00","ETH0":"10.3.100.22","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1144,"INVENTORY_NAME":"NOTEBOOK 67","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"75CV03J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-07-10 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1076,"INVENTORY_NAME":"NOTEBOOK 33","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4R6S64J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2012-02-11 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-EX","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1058,"INVENTORY_NAME":"NOTEBOOK 24","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"6J1QZ0J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D600","EXPIRY_DATE":"2007-01-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1375,"INVENTORY_NAME":"ORIFLAMEBIZ_SAS","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"2G9653J","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"MD3000","EXPIRY_DATE":"2010-10-12 00:00:00","ETH0":"10.196.192.4","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Email Marketing","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-65","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1040,"INVENTORY_NAME":"NOTEBOOK 15","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8V6P83J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-11-19 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1044,"INVENTORY_NAME":"NOTEBOOK 17","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"DLS1S3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2011-02-06 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":646,"INVENTORY_NAME":"HUB-BLADE03","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"7GP613J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PE1855 (10 slots)","EXPIRY_DATE":"2010-07-17 00:00:00","ETH0":"10.3.253.9","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK12","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":622,"INVENTORY_NAME":"RT-INT-BACKUP","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"FCZ0941712G","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"2811 Integrated Services Router","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1275,"INVENTORY_NAME":"MONITOR 36","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2008","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1265,"INVENTORY_NAME":"MONITOR 31","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1297,"INVENTORY_NAME":"MONITOR 47","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":592,"INVENTORY_NAME":"RACK01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":804,"INVENTORY_NAME":"HUBCOMM01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9PHST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.99.1","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"HUB","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1156,"INVENTORY_NAME":"NOTEBOOK 73","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FGHPN3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-05-01 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"QS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1136,"INVENTORY_NAME":"NOTEBOOK 63","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GHG693J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2010-11-25 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1096,"INVENTORY_NAME":"NOTEBOOK 43","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"F55B74J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E4300","EXPIRY_DATE":"2012-02-25 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"QS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":690,"INVENTORY_NAME":"IFSDB4","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JSMXL2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2009-11-19 00:00:00","ETH0":"10.3.72.11","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"RACK04","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":924,"INVENTORY_NAME":"HUBCX02","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"72DF0D1","STATUS_NAME":"Production","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX3-20","EXPIRY_DATE":"2010-07-03 00:00:00","ETH0":"10.3.253.64","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK04","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1337,"INVENTORY_NAME":"MONITOR 67","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"E178FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":792,"INVENTORY_NAME":"ESHOP01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"2GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00,"ETH0":"10.3.98.1","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":846,"INVENTORY_NAME":"ESHOP05","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"81NR53J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-10-03 00:00:00","ETH0":"10.3.98.5","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":620,"INVENTORY_NAME":"VPN-HUB","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"FCZ1132720A","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"3825 Integrated Services Router","EXPIRY_DATE":"2009-09-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK06","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1120,"INVENTORY_NAME":"NOTEBOOK 55","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"9Q7G54J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-01-18 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1052,"INVENTORY_NAME":"NOTEBOOK 21","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FRG893J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Vostro Desktop 200","EXPIRY_DATE":"2010-11-22 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1311,"INVENTORY_NAME":"MONITOR 54","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"Model2004","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1273,"INVENTORY_NAME":"MONITOR 35","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":676,"INVENTORY_NAME":"ORIDBDEV1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"FVWHN1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2008-05-24 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Online","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":760,"INVENTORY_NAME":"HUBSTBY20C","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"C9PJD2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-30 00:00:00","ETH0":"10.3.101.13","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":700,"INVENTORY_NAME":"CITRIX4","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"CTXBR2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-05-05 00:00:00","ETH0":"10.3.72.35","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"OR3-BIZ","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1373,"INVENTORY_NAME":"HUBAPP13","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"3GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"","WARRANTY_NAME":"4 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1036,"INVENTORY_NAME":"NOTEBOOK 13","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BH4FD1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Optiplex GX280","EXPIRY_DATE":"2007-12-07 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1122,"INVENTORY_NAME":"NOTEBOOK 56","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"BGWY94J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"OptiPlex 360","EXPIRY_DATE":"2012-04-28 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1154,"INVENTORY_NAME":"NOTEBOOK 72","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"JXRRV3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude XT","EXPIRY_DATE":"2011-07-31 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":934,"INVENTORY_NAME":"QACX","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"3Q1D92J","STATUS_NAME":"Testing","HARDWARE_TYPE":"ARRAY","MODEL_NAME":"CX-300","EXPIRY_DATE":"2009-05-30 00:00:00","ETH0":"10.3.253.78","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"EMC","PROJECT_NAME":"QA","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"RACK12","DATA_CENTER_NAME":"PRG"},{"INVENTORY_ID":1327,"INVENTORY_NAME":"MONITOR 62","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":686,"INVENTORY_NAME":"IFSDB2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"H2FW01J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2950","EXPIRY_DATE":"2007-02-17 00:00:00","ETH0":"10.3.72.8","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1345,"INVENTORY_NAME":"MONITOR 71","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1140,"INVENTORY_NAME":"NOTEBOOK 65","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"71FLX1J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude X1","EXPIRY_DATE":"2008-11-02 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":782,"INVENTORY_NAME":"TXT-APP01","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"60T613J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-07-17 00:00:00","ETH0":"10.3.75.1","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"TXT","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":852,"INVENTORY_NAME":"ESHOP08","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"C1NR53J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-10-03 00:00:00","ETH0":"10.3.98.8","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":878,"INVENTORY_NAME":"RACK11","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Rital - Water Cooled","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1168,"INVENTORY_NAME":"NOTEBOOK 79","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"2YSXQ3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-06-10 00:00:00","ETH0":"","WARRANTY_AME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":624,"INVENTORY_NAME":"RT-CA","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"FCZ0909203N","STATUS_NAME":"Production","HARDWARE_TYPE":"ROUTER","MODEL_NAME":"1841 Integrated Services Router","EXPIRY_DATE":"4000-01-01 00:00:00","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1347,"INVENTORY_NAME":"MONITOR 72","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1293,"INVENTORY_NAME":"MONITOR 45","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1707FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1287,"INVENTORY_NAME":"MONITOR 42","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1708FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":718,"INVENTORY_NAME":"DWH-APP01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"HYT6R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2009-05-30 00:00:00","ETH0":"10.3.72.21","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":868,"INVENTORY_NAME":"RACK04","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":966,"INVENTORY_NAME":"KCP-BLADE07","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"7YWWQ3J","STATUS_NAME":"Production","HARDWARE_TYPE":"CHASSIS","MODEL_NAME":"PEM1000e (16 slots)","EXPIRY_DATE":"2013-06-10 00:00:00","ETH0":"10.3.253.13","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-66","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":678,"INVENTORY_NAME":"DEVDB01","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"JVWHN1J","STATUS_NAME":"Development","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2010-05-24 00:00:00","ETH0":"10.3.112.1","WARRANTY_NAME":"2 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1128,"INVENTORY_NAME":"NOTEBOOK 59","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"H51PB2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-06-26 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1062,"INVENTORY_NAME":"NOTEBOOK 26","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"DNZ953J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-26 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":612,"INVENTORY_NAME":"SWITCH05","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"1234","STATUS_NAME":"Production","HARDWARE_TYPE":"SWITCH","MODEL_NAME":"Catalyst 3750G-48TS Switch","EXPIRY_DATE":"2009-05-25 00:00:00","ETH0":"","WARRANTY_NAME":"1 year","SUPPLIER_NAME":"Cisco","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"RACK-K4","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1321,"INVENTORY_NAME":"MONITOR 59","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":762,"INVENTORY_NAME":"HUBSTBY30C","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"F9PJD2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-30 00:00:00","ETH0":"10.3.101.23","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":840,"INVENTORY_NAME":"ESHOP03","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"375GG2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2009-09-10 00:00:00","ETH0":"10.3.98.3","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":680,"INVENTORY_NAME":"IFSPOUND","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"CRRVW1J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 2850","EXPIRY_DATE":"2008-10-20 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":872,"INVENTORY_NAME":"RACK06","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"noname","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":770,"INVENTORY_NAME":"HUBDB10B","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"96T603J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2010-07-03 00:00:00","ETH0":"10.3.100.2","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":876,"INVENTORY_NAME":"RACK10","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Rital - Water Cooled","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":950,"INVENTORY_NAME":"RACK-K4","CUST_ID":4,"CUST_NAME":"Intermotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":870,"INVENTORY_NAME":"RACK05","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"Dell - Standard","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":798,"INVENTORY_NAME":"ESHOP11","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5GJST3J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE M600","EXPIRY_DATE":"2013-07-21 00:00:00","ETH0":"10.3.98.11","WARRANTY_NAME":"5 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Orisales","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1172,"INVENTORY_NAME":"NOTEBOOK 81","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"4CB8L2J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D620","EXPIRY_DATE":"2009-11-09 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJET_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1092,"INVENTORY_NAME":"NOTEBOOK 41","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8XHPN3J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2011-05-01 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":956,"INVENTORY_NAME":"RACK-65","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"RACK","MODEL_NAME":"noname","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"Indefinite","SUPPLIER_NAME":"","PROJECT_NAME":"Infrastructure","COST_CENTER_NAME":"COMM","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1164,"INVENTORY_NAME":"NOTEBOOK 77","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"DFRFC4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-06-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1212,"INVENTORY_NAME":"MONITOR 5","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1908V","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1142,"INVENTORY_NAME":"NOTEBOOK 66","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"649L43J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":694,"INVENTORY_NAME":"CITRIX1","CUST_ID":8,"CUST_NAME":"JSNotions Inc.","SERVICE_TAG":"84R6R2J","STATUS_NAME":"Production","HARDWARE_TYPE":"BLADE","MODEL_NAME":"PE 1955","EXPIRY_DATE":"2010-01-31 00:00:00","ETH0":"10.3.72.32","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Development","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1030,"INVENTORY_NAME":"NOTEBOOK 10","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"GFRFC4J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-06-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1012,"INVENTORY_NAME":"NOTEBOOK 1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"739S44J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude E6400","EXPIRY_DATE":"2012-01-05 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"DWH","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":710,"INVENTORY_NAME":"IFSAPP1","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"D5LH93J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1850","EXPIRY_DATE":"2007-12-05 00:00:00","ETH0":"10.3.72.16","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1234,"INVENTORY_NAME":"MONITOR 16","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1295,"INVENTORY_NAME":"MONITOR 46","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1307,"INVENTORY_NAME":"MONITOR 52","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1703FP","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1236,"INVENTORY_NAME":"MONITOR 17","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"","STATUS_NAME":"Production","HARDWARE_TYPE":"MONITOR","MODEL_NAME":"1704FPT","EXPIRY_DATE":"","ETH0":"","WARRANTY_NAME":"","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":712,"INVENTORY_NAME":"IFSAPP2","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"8C61K2J","STATUS_NAME":"Production","HARDWARE_TYPE":"SERVER","MODEL_NAME":"PE 1950","EXPIRY_DATE":"2009-10-23 00:00:00","ETH0":"10.3.72.17","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"IFS (ERP)","COST_CENTER_NAME":"SP-IFS","RACK_NAME":"RACK-K5","DATA_CENTER_NAME":"KCP"},{"INVENTORY_ID":1126,"INVENTORY_NAME":"NOTEBOOK 58","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"5Y9L43J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"Latitude D630","EXPIRY_DATE":"2010-09-16 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"SP-ORI","RACK_NAME":"","DATA_CENTER_NAME":""},{"INVENTORY_ID":1158,"INVENTORY_NAME":"NOTEBOOK 74","CUST_ID":null,"CUST_NAME":"","SERVICE_TAG":"HRG693J","STATUS_NAME":"Production","HARDWARE_TYPE":"NOTEBOOK","MODEL_NAME":"XPS M1330","EXPIRY_DATE":"2010-11-27 00:00:00","ETH0":"","WARRANTY_NAME":"3 years","SUPPLIER_NAME":"Dell","PROJECT_NAME":"Personal Hardware","COST_CENTER_NAME":"QS","RACK_NAME":"","DATA_CENTER_NAME":""}]}
    
     
  • Ja Steam
    Ja Steam
    2011-03-27

    {"results":}

     
  • Ja Steam
    Ja Steam
    2011-03-27

    I'm still running into issue with large output.
    Cannot even out or copy the failed out(too large for reply). it fails on """.

    Let me know how I can forward it to you. Its about over 200K characters.

     
  • Ja Steam
    Ja Steam
    2011-03-27

    Hello Jonas,

    Upload the output which ended up with incorrect JSON formatting.

    http://jsnotions.homelinux.com/output.txt

    Feel free to look at it. At some point the formatting did a tripe double quote (""")

     
  • The url do not respond

     
  • Some additional info would be nice - database charset - database version.
    And an example script that yields the error (and which does not make assumptions on tables and data).

     
  • Ja Steam
    Ja Steam
    2011-03-27

    Hello Jonas,

    Here is 50 rows that encode properly and 300+ which fail. Below I 've included the on-demand Oracle Apex process. I;ve test both links and they work. If this doesn't work for you please provide me a destination where I can upload both txt files.

    Here is the 50 that works

    http://jsnotions.homelinux.com/output_50.txt

    Here is the 300+ that doesn't work

    http://jsnotions.homelinux.com/output.txt

    DECLARE 
    ret json_list; 
    jsonObj json; 
    vSQL varchar2(4000);
    p_query varchar2(25) := wwv_flow.g_x10;
    BEGIN 
    --create empty structure 
    jsonObj := json(); 
    vSQL := 'SELECT * FROM VW_INVENTORY 
               WHERE (lower(inventory_name) like lower(''%'||p_query||'%'')
                              or  lower(status_name) like lower(''%'||p_query||'%'')
                              or  lower(custt_name) like lower(''%'||p_query||'%'')
                              or  lower(model_name) like lower(''%'||p_query||'%'')
                              or  lower(warranty_name) like lower(''%'||p_query||'%'')
                              or  lower(service_tag) like lower(''%'||p_query||'%'')
                              or  lower(eth0) like lower(''%'||p_query||'%'')
                              or  lower(cost_center_name) like lower(''%'||p_query||'%'')
                              or  lower(project_name) like lower(''%'||p_query||'%'')
                              or  lower(hardware_type) like lower(''%'||p_query||'%'')
                              or  lower(data_center_name) like lower(''%'||p_query||'%''))';
    ret := json_dyn.executeList(vSQL); 
    jsonObj.put('results',ret); 
    jsonObj.htp();
    END;
    

    Database is Oracle 11.2.0.1 Enterprise Ed.. Apex 3.2 + Listener 1.1. No patchset have been applied.

    I've also included the process which renders the 300 properly:

    DECLARE
    field varchar2(25) := lower(wwv_flow.g_x04);
    dir varchar2(5) := wwv_flow.g_x05;
    p_fields varchar2(400) := wwv_flow.g_x09;
    p_query varchar2(25) := wwv_flow.g_x10;
    counter number := 0;
    vJSON_Str varchar2(32767) := '';
    vTempClob CLOB;
    vClob CLOB;
    vBuffer      VARCHAR2(32767);
    vOffset  INTEGER :=1;
    vRead  INTEGER := 32000;
    vSize number;
        cursor c1 is SELECT
                 inventory_id
                ,inventory_name
                --,cust_id
                 ,decode(cust_id,null,'null', cust_id) cust_id
                ,cust_name
                ,service_tag
                ,status_name
                ,hardware_type
                ,model_name
                ,expiry_date
                ,eth0
                ,warranty_name
                ,supplier_name
                ,project_name
                ,cost_center_name
                ,rack_name
                ,data_center_name
                ,totalrows
                FROM (
                  select q.*
                        ,rownum seq
                        ,count(*) over () totalrows
                    from (
                          -------------------------------------------------------------------------
                           SELECT  * from MVW_INVENTORY
                           WHERE (lower(inventory_name) like lower('%'||p_query||'%')
                                   or  lower(status_name) like lower('%'||p_query||'%')
                                   or  lower(cust_name) like lower('%'||p_query||'%')
                                   or  lower(model_name) like lower('%'||p_query||'%')
                                                          or  lower(warranty_name) like lower('%'||p_query||'%')
                                                          or  lower(service_tag) like lower('%'||p_query||'%')
                                                          or  lower(eth0) like lower('%'||p_query||'%')
                                                          or  lower(cost_center_name) like lower('%'||p_query||'%')
                                                          or  lower(project_name) like lower('%'||p_query||'%')
                                                          or  lower(hardware_type) like lower('%'||p_query||'%')
                                                          or  lower(data_center_name) like lower('%'||p_query||'%')
                                )
                            ORDER BY decode(dir,'ASC',decode(field
                                                             ,'expiry_date', to_char(expiry_date,'YYYYMMDD')
                                                             ,'cust_name',cust_name
                                                             ,'inventory_name',inventory_name
                                                             ,'service_tag', service_tag
                                                             ,'status_name', status_name
                                                             ,'project_name', project_name
                                                             ,'cost_center_name', cost_center_name
                                                             ,'model_name', model_name
                                                             ,'eth0', eth0
                                                             ,'hardware_type', hardware_type
                                                             ),0),
                                                        decode(dir,'DESC',decode(field
                                                             ,'expiry_date', to_char(expiry_date,'YYYYMMDD')
                                                             ,'cust_name',cust_name
                                                             ,'inventory_name',inventory_name
                                                             ,'service_tag', service_tag
                                                             ,'status_name', status_name
                                                             ,'project_name', project_name
                                                             ,'cost_center_name', cost_center_name
                                                             ,'model_name', model_name
                                                             ,'eth0', eth0
                                                             ,'hardware_type', hardware_type
                                                         ),0) desc 
                         --------------------------------------------------------------------------
                         ) q
              );
    BEGIN
      -- passback data
      FOR cs IN c1 LOOP
      counter := cs.totalrows;
      vJSON_Str := '{"INVENTORY_ID":'|| cs.inventory_id ||',
      "INVENTORY_NAME":"'||cs.inventory_name||'",
      "CUST_ID":'||cs.cust_id||',
      "CUST_NAME":"'||cs.cust_name||'",
      "SERVICE_TAG":"'||cs.service_tag||'",
      "STATUS_NAME":"'||cs.status_name||'",
      "HARDWARE_TYPE":"'||cs.hardware_type||'",
      "MODEL_NAME":"'||cs.model_name||'",
      "EXPIRY_DATE":"'||cs.expiry_date||'",
      "ETH0":"'||cs.eth0||'",
      "WARRANTY_NAME":"'||cs.warranty_name||'",
      "SUPPLIER_NAME":"'||cs.supplier_name||'",
      "PROJECT_NAME":"'||cs.project_name||'",
      "COST_CENTER_NAME":"'||cs.cost_center_name||'",
      "RACK_NAME":"'||cs.rack_name||'",
      "DATA_CENTER_NAME":"'||cs.data_center_name||'"
      },';
     vTempClob := vJSON_Str;
      vClob := vClob || vTempClob;
     END LOOP;
     IF (counter >= 1) THEN
     HTP.P('{"total":'|| counter ||',"results":[');
       -- Need to trim the last comma, otherwise the JSON will be invalid
       SELECT dbms_lob.getlength(vClob) INTO vSize FROM dual;
       vSize := vSize-1;
       dbms_lob.trim(vClob, vSize);
       LOOP
         dbms_lob.read(vClob, vRead, vOffset, vBuffer);
         vOffset := vOffset + vRead;
         HTP.P(vBuffer);
       END LOOP;
     ELSE
      HTP.P('{"total":'|| counter ||',"results":[]}');
     END IF;
    EXCEPTION
     WHEN NO_DATA_FOUND THEN
      HTP.P(']}');
    END;
    
     
  • Ja Steam
    Ja Steam
    2011-03-27

    Hello Jonas,

    Current work around is apex built in function ( apex_util.json_from_sql).
    One last thing, database is UTF8

    /Jan

    DECLARE 
    vSQL varchar2(4000);
    p_query varchar2(25) := wwv_flow.g_x10;
    BEGIN
    vSQL := 'SELECT * FROM VW_INVENTORY 
               WHERE (lower(inventory_name) like lower(''%'||p_query||'%'')
                              or  lower(status_name) like lower(''%'||p_query||'%'')
                              or  lower(cust_name) like lower(''%'||p_query||'%'')
                              or  lower(model_name) like lower(''%'||p_query||'%'')
                              or  lower(warranty_name) like lower(''%'||p_query||'%'')
                              or  lower(service_tag) like lower(''%'||p_query||'%'')
                              or  lower(eth0) like lower(''%'||p_query||'%'')
                              or  lower(cost_center_name) like lower(''%'||p_query||'%'')
                              or  lower(project_name) like lower(''%'||p_query||'%'')
                              or  lower(hardware_type) like lower(''%'||p_query||'%'')
                              or  lower(data_center_name) like lower(''%'||p_query||'%''))';
                              
     apex_util.json_from_sql(vSQL);
    
     END;
    
     
  • Hi - sorry for the late reply,

    It might be a UTF8 db problem - I will try to install a UTF8 database and test encoding and decoding,

    /Jonas

     
  • Ja Steam
    Ja Steam
    2011-04-26

    Hello Jonas,

    Sorry for the late reply. I will test the latest revision on Saturday and get back to you.

    Thanks

    /Jan

     
  • MIchele Paoli
    MIchele Paoli
    2011-09-07

    I have same problem
    it affected version 1.02 too
    And I need a Solution :-)