API tools faq
paste
Advertisement
Guest User

asdfasdf

a guest
Jul 19th, 2019
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.37 KB | None | 0 0
raw download clone embed print report
  1. IF NOT EXISTS (
  2. select * from sysobjects where name='cleanedresult' and xtype='U'
  3. ) CREATE TABLE cleanedresult (
  4. [commit_data] NVARCHAR(40),
  5. [date_committed] DATETIME,
  6. [subject] NVARCHAR(176),
  7. [ddts] NVARCHAR(10),
  8. [headline] NVARCHAR(60),
  9. [refs] NVARCHAR(10),
  10. [author] NVARCHAR(15),
  11. [loc_add] INT,
  12. [loc_del] INT,
  13. [loc_mod] INT,
  14. [files] NVARCHAR(1107),
  15. [DEManager] NVARCHAR(8),
  16. [DIRECTOR] NVARCHAR(8),
  17. [Attribute] NVARCHAR(117),
  18. [Component] NVARCHAR(7),
  19. [PIN] NVARCHAR(9),
  20. [Severity] INT,
  21. [RG] NVARCHAR(1),
  22. [Qualex] INT
  23. );
  24. INSERT INTO cleanedresult VALUES
  25. (N'2d1abd51942d1badb320e74e93327379c871d4cb','2019-07-16 20:38:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq26633',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq26633',N'Abraham Lincoln',64,19,45,N'binos/tools/bin/install/fast_rld/cat9k_fpga_preupgr.sh'', ',N'sonle',N'skodnad',N'cloned-from-CSCvq13018 cloned-from-CSCvq26624 xe1612-ccb-yes',N'cat9300',N'switching',2,N'N',3),
  26. (N'd9b281b58563b67be67db6f3db649376c4730fc5','2019-07-16 17:44:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq50843',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq50843',N'Abraham Lincoln',2,0,2,N'binos/mgmt/dmi/ncsshd_bp/src/scripts/execute_confd_cli.sh'', ',N'rayyagar',N'prab92',N'-OIB -SS 1612SITBlocker -TS xe1612-TS xe1612-ccb-yes xe16121-TS xe16121-ccb-yes cloned-from-CSCvp77792',N'cedge',N'sdwan',2,N'Y',3),
  27. (N'55eee7d5c401fef38b69109229047c203df6f30d','2019-07-16 17:24:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq37240',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq37240',N'Abraham Lincoln',2,1,1,N'vob/ios/sys/mcp/mcprp-imsp/features/acl/imsp_acl_mgr.c'', ''vob/ios/sys/mcp/mcprp-imsp/features/cts/imsp_cts_sgacl_matrix.c'', ',N'abadami',N'mallik',N'aquarius-7 -OIB',N'petra',N'iot',3,N'N',5),
  28. (N'50484147278113615171eae236f3c336d5a2cffe','2019-07-16 17:10:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq47952',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq47952',N'Abraham Lincoln',26,8,18,N'binos/platforms/ngwc/doppler_sdk/drivers/serdes/Vendor/src/avago_serdes.c'', ',N'rmadalap',N'bmrao',N'sf-mod sf-mod-oib xe1612 sf-mod-ss xe1612-ss xe1612-baseline xe1612-mr1',N'cat9600',N'switching',2,N'N',3),
  29. (N'5281322e879fbf74ef80f1138bed4dcf76f278ae','2019-07-16 16:57:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvp98689',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvp98689',N'Abraham Lincoln',20,8,12,N'vob/.acme_project/proj.lu'', ''vob/ss.comp1/uc_infra/src/voip/recmsp/record_control_api.c'', ',N'nsuryawa',N'mkalapar',N'1610_next 1611_next v1612_next',N'all',N'voice',3,N'Y',2),
  30. (N'dbc61c2335342c19f217f5670ced10c59fa21841','2019-07-16 16:22:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvp46414',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvp46414',N'Abraham Lincoln',8,2,6,N'binos/cpp/dp/hardware/crypto_device/cdal_offload/src/cdal_offload_ipsec.c'', ',N'jimchu',N'wangrn',N'1ru-oib curie-security curie-sdwan xe1612-oib routing-AUT',N'isr',N'sdwan',3,N'N',1),
  31. (N'5d3d3ed85a2348327c14ff881889f20654fd8938','2019-07-16 15:07:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvp48278',N'We''re going to win bigly.',N'CSCvp48278',N'NSYNC',229,374,-145,N'binos/build/make-lib/functions.mk'', ''binos/build/make-lib/lib_rules.mk'', ''binos/build/make-lib/variables.mk'', ''binos/infra/green/obja/ewlc/Makefile.binos'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_be.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_be_oper.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_defaults.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_ewlc_ap_group_db_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_ewlc_eventq.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_ewlc_oper_alt_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_ewlc_oper_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_ewlc_oper_emul_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_nmsp_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_rogued_db.tpp'', ''binos/infra/green/obja/ewlc/src/ewlc_obja_wstatsd_db.tpp'', ''binos/infra/tdl/macros/std_exec_context.stg'', ''binos/infra/tdl/macros/std_green.stg'', ''binos/infra/tdl/macros/std_traversal.stg'', ''binos/tools/tdlc/src/ODFileWriter.java'', ''binos/tools/tdlc/src/TDLC.java'', ''binos/tools/tdlc/src/TDLCOptions.java'', ''binos/tools/tdlc/src/TDLPP.java'', ',N'vikannap',N'harsh',N'null',N'all',N'infra',6,N'N',7),
  32. (N'734ecc4896958a44dcdb866a777d4ec53189126c','2019-07-16 09:55:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvq32569',N'We''re going to win bigly.',N'CSCvq32569',N'NSYNC',15,13,2,N'binos/mgmt/webui/features/configureCli/configCliCtrl.js'', ''binos/mgmt/webui/features/netFlow/netFlowController.js'', ''binos/mgmt/webui/scripts/lua/features/confCliCommand.lua'', ''binos/mgmt/webui/scripts/lua/features/execCliCommand.lua'', ',N'jplammoo',N'rbraj',N'asig-tag polaris-csdl nxe-1.4-res cwe-650',N'all',N'webui',2,N'N',4),
  33. (N'761db8f05bef1d5b93e20926d4d3504f003dd8e6','2019-07-16 07:09:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvp94493',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvp94493',N'Abraham Lincoln',116,54,62,N'vob/ios/sys/src-ubr/apps/vdoc/ubrcce_mcast.h'', ''vob/ios/sys/src-ubr/apps/vdoc/ubrcce_mcast_ipc_clc.c'', ''vob/ios/sys/src-ubr/docsis/docsis_ipc_clc.c'', ',N'macai',N'fli',N'#NAME?',N'cbr-8',N'cable',3,N'Y',7),
  34. (N'c021a8582333ddfd9453cc57b0632c7140a5afcd','2019-07-16 05:45:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq47536',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq47536',N'Abraham Lincoln',54,9,45,N'binos/ewlc/common/include/ewlc_client_global.h'', ''binos/ewlc/wncd/mewlc/src/wncd_mewlc.c'', ''binos/ewlc/wsa/wsa_wncmgrd/src/wsa_tables.tpp'', ''binos/ewlc/wsa/wsa_wncmgrd/src/wsa_wncmgr_certificate.c'', ''binos/ewlc/wsa/wsa_wncmgrd/src/wsa_wncmgrd_api.c'', ',N'visavla',N'akhanna',N'icapewlc1612-SS xe1612-mr1 xe1612-ccb-no',N'ewlc',N'wireless',2,N'N',5),
  35. (N'400c88730f8742998485107e298156b7ae4c16cf','2019-07-16 05:34:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq44877',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq44877',N'Abraham Lincoln',8,8,0,N'binos/ewlc/common/infra/src/ewlc_platform_ev_stats.c'', ',N'visavla',N'akhanna',N'ewlcme ewlc-me-ss xe1612 ewlc-prof-me mewlc-prof-pns ewlc-vc xe1612-mr1 xe1612-ccb-review xe1612-ccb-yes',N'ewlc',N'wireless',2,N'N',7),
  36. (N'd4a26e6a24c3cb4e133f91ecde0b8aa22cf0d183','2019-07-16 05:04:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvp30786',N'We''re going to win bigly.',N'CSCvp30786',N'NSYNC',59,7,52,N'binos/infra/ptl/src/ewlc_maps.ptl'', ''binos/infra/ptl/src/ewlc_show_client.ptl'', ',N'bfajalia',N'ayanc',N'#NAME?',N'ewlc',N'wireless',3,N'N',5),
  37. (N'1bcb9a6a90e8c50ea6e16866fe331fc7ac9034a7','2019-07-16 04:55:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq37916',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq37916',N'Abraham Lincoln',42,3,39,N'binos/fman/fp/src/fman_cef.c'', ',N'satyajda',N'prab92',N'-SS -TS 1612SITBlocker SIT_BUG xe1612-ccb-yes 192-1612-eft -RegressionGating',N'cedge',N'sdwan',1,N'N',4),
  38. (N'af2901c3f4b30dd03bba2140980b70f7ee59341a','2019-07-16 03:58:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvq45496',N'We''re going to win bigly.',N'CSCvq45496',N'NSYNC',27,12,15,N'binos/drivers/userspace/usphy/src/ubr_bcm31442_cli.c'', ''binos/drivers/userspace/usphy/src/ubr_usphy.c'', ',N'chhoppe',N'daorloff',N'ST:d31-ump -nooib',N'cbr-8',N'cable',3,N'Y',5),
  39. (N'af4dc7ac78b33e64ed395c40e92235a3824d3dd7','2019-07-16 02:17:00',N'Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.',N'CSCvq27477',N'It''s not who I am underneath, but what I do that defines me.',N'CSCvq27477',N'Abraham Lincoln',54,56,-2,N'vob/ios/sys/mcp/mcprp-ubr/snmp/ubr_entity_util.c'', ''vob/ios/sys/src-ubr/mibs/ipc/test/ubr_snmp_test_chain.c'', ''vob/ios/sys/src-ubr/ubr-infra/common/src/ubr_entity_alarms.c'', ',N'guyin',N'fli',N'PSIT -SS xe16101g-mf ccb-yes Not-Required-In-v1612_1_throttle',N'cbr-8',N'cable',2,N'Y',7),
  40. (N'5781827210802a559ce5a39a4a9d70ac35c9cb4c','2019-07-16 00:02:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvq50817',N'We''re going to win bigly.',N'CSCvq50817',N'NSYNC',27,41,-14,N'binos/platforms/ngwc/fed3_0/feature/l2/npd/leaba/cmn/src/la_l2_adapt.c'', ''binos/platforms/ngwc/fed3_0/feature/l2/npd/leaba/cmn/src/la_l2_init.c'', ''binos/platforms/ngwc/fed3_0/feature/l3/npd/leaba/cmn/src/la_l3_adapt.c'', ''binos/platforms/ngwc/fed3_0/infra/fed3_rm/include/fed3_rm.h'', ''binos/platforms/ngwc/fed3_0/punject/cmn/src/fed3_punject_tx.c'', ''binos/tools/bin/cat9k-boothelper.sh'', ''binos/tools/bin/cat9k-capsule-upgrade.sh'', ''binos/tools/bin/install/fast_rld/cat9k_preupgrd_boothelper.sh'', ',N'vdukki',N'skodnad',N'#NAME?',N'cat9300',N'switching',2,N'N',1),
  41. (N'5358d775b815626379b0f1c2cbbc2b78743383b1','2019-07-15 22:56:00',N'Don''t wanna be a fool for you Just another player in your game for two You may hate me, but it ain''t no lie, Baby, bye, bye, bye...',N'CSCvq33195',N'We''re going to win bigly.',N'CSCvq33195',N'NSYNC',19,1,18,N'binos/ewlc/ap/tagmgr/filter/src/filter.c'', ''binos/ewlc/ap/tagmgr/filter/src/filter_deps.tpp'', ',N'girishg',N'vaseshad',N'ewlc-eft -ss sjsu cloned-from-CSCvo00477 xe1612-ccb-yes ewlc-ss ewlc-eft-it DT_RCA bgl18-cz CZ-C9800 CZ-Wireless ewlc',N'ewlc',N'wireless',2,N'N',2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!