Client Management Suite

 View Only

The Valid Custom Inventory Data Types 

Nov 12, 2008 01:58 PM

It is a misnomer to state that Custom Inventory supports certain data types. Within the aexcustinv.exe process, all data is treated as a string type. It is incumbent on the Notification Server dataloader to interpret the data types defined in the column attributes, create the table properly in the database, and validate the incoming data.

So, it is a clearer to say that when creating custom inventory XML scripts, certain data types can be processed by the NS dataloader.

Currently, the dataloader will process the following data types:

Custinv Data TypeConverts to SQL Data Type
stringnvarchar
intint
dateTimedatetime
r4real
floatfloat
i2smallint
numbernumeric
booleanbit
uuiduniqueidentifier
bin.hexbinary
currencymoney
Note: These are case sensitive, so dateTime must be specified with a capital T in Time. Note: The number data type requires a precision and scale specification. An example is attached to this article.

The following image shows the database schema for the attached sample inventory.

License:AJSL
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
Support:User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.

Statistics
0 Favorited
0 Views
2 Files
0 Shares
0 Downloads
Attachment(s)
jpg file
6244.jpg   2 KB   1 version
Uploaded - Apr 10, 2020
txt file
datatypes.xml_.txt   2 KB   1 version
Uploaded - Apr 10, 2020

Tags and Keywords

Comments

Nov 17, 2008 05:18 PM

The dt:maxLength element is only required for string and bin.hex data types. It can be completely removed/unspecified for all others.

Related Entries and Links

No Related Resource entered.