ExportUtil
Feature Description
Use this application to export objects from ALVAO Asset Management to a standard CSV file. The application will export only active Registry assets, i.e. "disposed assets", "recycle bin", and other system objects will be excluded from the export.
Command Line Syntax
ExportUtil /csv "CSV file name and path" {/conn "connection string" | /server "database server name" /db "database name"} /cols "column list" [/NotEmpty "column name"] [/TemplateFolder "folder name"]
Detailed Description of Parameters
Parameter |
Description |
/csv |
Name and path of the CSV file to which the object data will be exported. |
/conn /server /db |
These parameters contain connection settings for the ALVAO database. You can use connection strings (e.g. /conn "Data source=.\sqlexpress;Initial Catalog=test;Integrated Security = True"), or enter a specific SQL server and database (e.g. /server ".\sqlexpress" /db "test"). If you use the /server and /db parameters, the system will connect to the database using Integrated Windows Authentication. If you specify all parameters, only the /conn parameter will be used. The parameters /server and /db will be ignored. |
/cols |
Definition of columns that will be exported in the output file. See below. |
/NotEmpty |
Export only objects where the value of a specific object property is not empty. Note: The property name can be specified even without diacritics. |
/TemplateFolder |
Export only certain object kinds in object templates under a certain folder. The parameter here is the folder name. Note: The folder name can be specified without diacritics. |
Description of Supported Columns
Columns in the /cols parameters are comma-separated. We recommend enclosing the entire parameter value with inverted commas.
Column |
Meaning |
Value Example |
@id |
Unique identifier (INT number) of the object in the database Asset Management (NodeId). |
1245 |
@name |
Object name in the Objects Tree. |
HP LP2475w, LCD, 24" |
@class |
Object kind. |
Monitor |
@path |
Object path in the Objects Tree. |
Organization/Liverpool/Peter Jenkins |
@adguid |
GUID object identifier from Active Directory (contains a value, provided the object was created or paired by importing from AD). |
{f50c0d0f-fede-4aaa-9509-7632e48251cc} |
[object property] |
Any object property. Properties need to be enclosed in square brackets. Note: The property name can be specified with or without diacritics. |
SN1234 |
Example of parameter value: "@id,@name,@path,@class,[serial number],[asset number],[hostname]"
Scenarios
Export of objects with a value in the "Inventory number" property
ExportUtil.exe /csv "c:\data\objects.csv" /server server\sql2005 /db alvao /cols "@id,@name,@path,@class,[serial number],[inventory number],[hostname]" /NotEmpty "inventory number"
Export of all objects whose object template is stored in the "IT Assets" folder
ExportUtil.exe /csv "c:\data\objects.csv" /server server\sql2005 /db alvao /cols "@id,@name,@path,@class,[serial number],[inventory number],[hostname]" /TemplateFolder "it assets"
Did not find what you were looking for? Ask our technical support team.
|