clearing date filed value of a Configuration Item via GRLoader

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

I need to know how to set a date field in the database to the value EMPTY via the GRLoader.

Environment

SDM 17.x

Resolution

1) Create a XML file to import the file.

Example:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
<GRLoader> 
<ci> 
<name>testname</name> 
<serial_number>1234</serial_number> 
<class>Bridge</class> 
</ci> 
</GRLoader> 

2. Run GRLoader calling the XML file above, which creates the CI "testname" with a creation_date = 1234567890

where 123456789 is the current date in Unix format.

3. Create or update the previous XML to clear the creation_date field:

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
<GRLoader> 
<ci> 
<name>testname</name> 
<serial_number>1234</serial_number> 
<class>Bridge</class> 
<creation_date>EMPTY</creation_date> 
</ci> 

4. Run GRloader to update the CI using the XML above.

Additional Information

Populating CMDB