Skip to main content

Assets & Configuration Items - Key Tables

Full column listings for the 4 key tables in this category.

CONN (25 columns)

# Column Type Length Nullable Default
1 Dsite smallint NO
2 Ddevnum smallint NO
3 Dtype smallint YES
4 Dconnector bit NO ((0))
5 Dtx smallint YES
6 Dty smallint YES
7 DDevstart int YES
8 DDevend int YES
9 Dsconnpoint smallint YES
10 Deconnpoint smallint YES
11 Dstraight smallint YES
12 Dtext smallint YES
13 Dmemo ntext 1073741823 YES
14 Dothersite smallint YES
15 DCNid int YES ((0))
16 Dcompanynum int YES ((0))
17 DSLAid int YES ((-1))
18 dseriousness int YES ((0))
19 ConnBlob varbinary -1 YES
20 Dchangeseq int YES ((1))
21 DGoodsInSHID int YES ((0))
22 DIssueCDID int YES ((0))
23 DWarrantyEndDate datetime YES
24 DSupplierSLAID int YES ((0))
25 DSupplierPriorityID int YES ((0))

CONNCHANGE (8 columns)

# Column Type Length Nullable Default
1 DCID int NO
2 DCDSite int NO
3 DCDevNum int NO
4 DCFieldID int NO
5 DCOldValue nvarchar 4000 YES
6 DCNewValue nvarchar 4000 YES
7 DCWho nvarchar 4000 YES
8 DCWhen datetime YES

DEVICE (117 columns)

# Column Type Length Nullable Default
1 Dsite int NO
2 ddevnum int NO
3 Dtype smallint YES
4 Dconnector bit NO ((0))
5 Dtx smallint YES
6 Dty smallint YES
7 DDevstart int YES
8 DDevend int YES
9 Dsconnpoint smallint YES
10 Deconnpoint smallint YES
11 Dstraight smallint YES
12 Dtext smallint YES
13 Dmemo ntext 1073741823 YES
14 Dnondiagram bit NO ((0))
15 dinvno nvarchar 4000 YES
16 dpingservice int YES ((0))
17 DCNid int YES ((0))
18 Dcompanynum int YES ((0))
19 DSLAid int YES ((-1))
20 DGuid nvarchar 4000 YES
21 dseriousness int YES ((0))
22 dcontractid int YES ((-1))
23 DcontractvalueCurrent float YES ((0))
24 DcontractvaluePrior float YES ((0))
25 Dlastchangeofvaluedate datetime YES
26 DWarrantyStartDate datetime YES
27 DWarrantyEndDate datetime YES
28 DWarrantyNote ntext 1073741823 YES
29 DeviceBlob varbinary -1 YES
30 Dchangeseq int YES ((1))
31 DLabourWarrantyStartDate datetime YES
32 DLabourWarrantyEndDate datetime YES
33 DGoodsInSHID int YES ((0))
34 DIssueCDID int YES ((0))
35 dinactive bit NO ((0))
36 DParentDid int YES ((0))
37 Did int YES ((0))
38 DSupplierPurchaseDate datetime YES
39 DSupplierExpiryDate datetime YES
40 DSupplierSLAID int YES ((0))
41 DSupplierPriorityID int YES ((0))
42 DSupplierReference nvarchar 4000 YES
43 DGFIDeviceID int YES ((0))
44 DSupplierHeaderID int YES ((0))
45 DTeamviewerID nvarchar 4000 YES ('')
46 DTeamviewerPassword nvarchar 4000 YES ('')
47 DSnowID nvarchar 1000 YES ('')
48 dcommissioned int YES ((1))
49 dCommissionDate datetime YES ((0))
50 DKaseyaID nvarchar 100 YES ('')
51 DStatus int NO ((-1))
52 CFsoftwareDetailsHTML nvarchar -1 YES
53 dbusiness_owner_id int YES ((0))
54 dtechnical_owner_id int YES ((0))
55 dcautomateid int YES ((0))
56 DNinjaRMMId int YES ((0))
57 DNinjaRMMUrl nvarchar 500 YES ('')
58 DNinjaRMMRemoteControl nvarchar 500 YES ('')
59 DBusinessCentralID nvarchar 100 YES ('')
60 DIntuneId nvarchar 100 YES ('')
61 DitemStockId int YES ((0))
62 DnonConsignable bit YES ((0))
63 DitemId int YES ((0))
64 DPRTGId int YES ((0))
65 DDevice42Id int YES ((0))
66 DDattoId nvarchar 100 YES ('')
67 DDattoAlternateId int YES ((0))
68 DDattoUrl nvarchar 100 YES ('')
69 DreservedOlid int YES ((0))
70 DreservedOlseq int YES ((0))
71 dbusiness_owner_cab_id int YES ((0))
72 dtechnical_owner_cab_id int YES ((0))
73 DAteraId nvarchar 100 YES ('')
74 DLansweeperId nvarchar 100 YES ('')
75 DLansweeperUrl nvarchar 500 YES ('')
76 DLastUpdate datetime YES ((0))
77 ditemcost float YES ((0))
78 DITGlueId nvarchar 100 YES ('')
79 DITGlueUrl nvarchar 1000 YES ('')
80 djamfid int YES ((0))
81 djamftype nvarchar 100 YES ('')
82 DSyncroId int YES ((0))
83 ddomotzagentid int YES ((0))
84 ddomotzid int YES ((0))
85 dnewsnowid int YES ((0))
86 DAuvikNetworkId nvarchar 100 YES ('')
87 DAuvikDeviceId nvarchar 100 YES ('')
88 DAuvikUrl nvarchar 1000 YES ('')
89 dpassportalid bigint YES
90 DQualysId nvarchar 100 YES
91 daddigyid nvarchar 50 YES
92 dliongardid int YES
93 dliongardenvironmentid int YES
94 diskaseyaagent bit YES
95 dstbid int YES
96 DAzureTenantId nvarchar 100 YES ('')
97 dncdid int YES
98 dprtgdetailsid int YES
99 djamfdetailsid int YES
100 DIMPORTGUID uniqueidentifier YES (newsequentialid())
101 dlast_modified datetime YES ((0))
102 dassetchartjson nvarchar -1 YES
103 dcriticality int YES ((0))
104 distemplate bit YES
105 dcreatedfromtemplate int YES
106 CFbitlockerRecoveryPasswords nvarchar 1000 YES
107 Dchangeguid uniqueidentifier YES (newid())
108 dstid int YES
109 dshid int YES
110 downingservice int YES
111 downingbusinessapp int YES
112 CFMSPCBLHID nvarchar 1000 YES
113 denvironment int YES
114 downingportfolio int YES
115 downingci int YES
116 dmanufacturerid int YES ((0))
117 darea int YES

DEVICECHANGE (20 columns)

# Column Type Length Nullable Default
1 DCID int NO
2 DCDSite int NO
3 DCDevNum int NO
4 DCFieldID int NO
5 DCOldValue nvarchar 4000 YES
6 DCNewValue nvarchar 4000 YES
7 DCWho nvarchar 4000 YES
8 DCWhen datetime YES
9 dcsoftwareid int YES ((0))
10 dcuserid int YES ((0))
11 DCOldSite int YES ((0))
12 DCNewSite int YES ((0))
13 dccustomfieldid int YES
14 dcitemid int YES ((0))
15 DCDID int YES
16 pk bigint NO
17 dcfieldname nvarchar 500 YES
18 dcwhoid int YES
19 dcoriginalwhoid int YES
20 dcoriginalappid int YES
Back to top